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

Access all the information you need to begin using the My SQL 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 My SQL 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 My SQL 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 My SQL Database Service (MDS) and how to incorporate cloud-based database storage into their infrastructure and applications. Readers who are new to My SQL will appreciate the tutorial chapter, and those familiar with My SQL will learn the latest features of MDS as well as how to build inexpensive, powerful My SQL database servers in the Oracle Cloud Infrastructure (OCI).

Table of Content

1. Getting Started with My SQL in the Cloud.- 2. Oracle Cloud Infrastructure.- 3. A Brief Tutorial of My SQL.- 4. My SQL 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.

About the author

​Charles Bell conducts research in emerging technologies. He is a member of the Oracle My SQL Development team and is one of the principal developers for the My SQL Database Service (MDS) team supporting My SQL 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.