MySQL Database Service Revealed: Running MySQL as a Service in the Oracle Cloud Infrastructure

by Charles Bell

Overview

Access all the information you need to begin using the MySQL Database Service (MDS) in the Oracle Cloud Infrastructure (OCI). MDS is Oracle’s new platform as a service (PAAS) offering for open-source database users. This book covers getting started with an account in OCI, gives a brief overview of OCI services available, and provides a short tutorial on MDS. Reading this book helps you take advantage of the powerful OCI features by building your own MySQL database in the cloud. 
Examples in this book center around running MDS in OCI, and include several of the popular use cases as well as advice on how to implement them. In addition, you will learn more about the related MDS OCI features, such as the high availability features currently available. Finally, you will learn how to back up and restore your data as well as how to get your data into and out of the cloud. The skills you learn in this book will help you get started using MDS and letting Oracle do the heavy lifting of managing MDS operations and implementation.

What You Will Learn

• Use Oracle Cloud Infrastructure (OCI)
• Deploy MySQL Database Service (MDS) systems in the cloud
• Connect your applications to MDS
• Back up and recover using the data recovery features of MDS
  
• Employ the newest high availability features of MDS

Who This Book Is For
Systems engineers, developers, and database professionals who want to learn about the powerful features of the MySQL Database Service (MDS) and how to incorporate cloud-based database storage into their infrastructure and applications. Readers who are new to MySQL will appreciate the tutorial chapter, and those familiar with MySQL will learn the latest features of MDS as well as how to build inexpensive, powerful MySQL database servers in the Oracle Cloud Infrastructure (OCI).

Product Details

ISBN-13:	9781484289457
Publisher:	Apress
Publication date:	12/09/2022
Sold by:	Barnes & Noble
Format:	eBook
File size:	46 MB
Note:	This product may take a few minutes to download.

About the Author

​Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team and is one of the principal developers for the MySQL Database Service (MDS) team supporting MySQL as a service in the Oracle Cloud Infrastructure (OCI). He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005.
Dr. Bell is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, database systems, cloud systems, software engineering, Internet of Things, and sensor networks.
Dr. Bell lives in a small town in rural Virginia with his loving wife. He spends his limited free time as a practicing Maker, focusing on microcontroller projects and refinement of 3D printers. 

Table of Contents

1. Getting Started with MySQL in the Cloud.- 2. Oracle Cloud Infrastructure.- 3. A Brief Tutorial of MySQL.- 4. MySQL Database Service.- 5. Backup and Restore.- 6. Point-in-Time Recovery.- 7. Data Import and Export.- 8. High Availability.- 9. OCI Command-Line Interface and Application Programming Interfaces.- 10. Migrating to MDS.