© Navin Sabharwal, Shakuntala Gupta Edward 2020
N. Sabharwal, S. G. EdwardHands On Google Cloud SQL and Cloud Spannerhttps://doi.org/10.1007/978-1-4842-5537-7_8

8. Best Practices

Navin Sabharwal1  and Shakuntala Gupta Edward2
(1)
New Delhi, India
(2)
Ghaziabad, India
 

Now that you are familiar with the relational database offerings of GCP—Cloud SQL and Cloud Spanner—it’s time to look at some of the best practices that will enable you to plan the usage of these cloud databases efficiently. Let’s begin with Cloud SQL.

Cloud SQL Best Practices

This section covers the best practices for efficient usage of the Cloud SQL instance.

Plan Resources Efficiently

Ensure sufficient resources are available as per the workload.

Storage

If an instance runs out of storage ...

Get Hands On Google Cloud SQL and Cloud Spanner: Deployment, Administration and Use Cases with Python now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial