Chapter 4. Cloud SQL: managed relational storage

 

This chapter covers

  • What is Cloud SQL?
  • Configuring a production-grade SQL instance
  • Deciding whether Cloud SQL is a good fit
  • Choosing between Cloud SQL and MySQL on a VM

Relational databases, sometimes called SQL (pronounced like sequel) databases, are one of the oldest forms of structured data storage, going back to the 1980s. The term relational database comes from the idea that these databases store related data and then allow you to combine it to ask complex questions, such as “How old are this year’s top five highest paid employees?”

This ability makes relational databases great general-purpose storage systems. As a result, most cloud hosting providers offer some sort of push-button option to get a relational database up and running. In Google Cloud, this is called Cloud SQL, and if you went through the exercise in chapter 2, you’re already a little bit familiar with it.

4.1. What’s Cloud SQL?

4.2. Interacting with Cloud SQL

4.3. Configuring Cloud SQL for production

4.4. Scaling up (and down)

4.5. Replication

4.6. Backup and restore

4.7. Understanding pricing

4.8. When should I use Cloud SQL?

4.9. Cost

4.10. Weighing Cloud SQL against a VM running MySQL

Summary

sitemap