You're reading from Google Cloud Certified Professional Cloud Developer Exam Guide Modernize your applications using cloud-native services and best practices

Product type Paperback

Published in Sep 2021

Publisher Packt

ISBN-13 9781800560994

Length 382 pages

Edition 1st Edition

Tools

Google App Engine

Concepts

Cloud Native

Author (1):

Sebastian Moreno

View More author details

Table of Contents (21) Chapters

Preface

1. Section 1: Welcome to the Google Cloud Developers' Guide

2. Chapter 1: Google Cloud Platform Developer Fundamentals FREE CHAPTER

3. Chapter 2: Security Fundamentals and Best Practices

4. Section 2: Developing and Modernizing Applications on Google Cloud Platform

5. Chapter 3: Application Modernization Using Google Cloud

6. Chapter 4: Using Cloud Functions and Google App Engine

7. Chapter 5: Virtual Machines and Container Applications on Google Cloud Platform

8. Chapter 6: Managing APIs on Google Cloud Platform

9. Section 3: Storage Foundations

10. Chapter 7: Handling Unstructured Data

11. Chapter 8: Databases and Event Messages in Google Cloud

12. Chapter 9: Data Management and Database Strategies

13. Chapter 10: Optimizing Applications with Caching Strategies on Google Cloud Platform

14. Section 4: SRE for Developers

15. Chapter 11: Logging on Google Cloud Platform

16. Chapter 12: Cloud Monitoring, Tracing, and Debugging

17. Section 5: Analyzing a Sample Case Study

18. Chapter 13: HipLocal Sample Case Study Preparation

19. Chapter 14: Questions and Answers

20. Other Books You May Enjoy

Database and application management best practices

In this section, we will review a compilation of good practices for designing and developing in the cloud on our databases.

Keep your Cloud SQL small

It is recommended when possible to keep Cloud SQL instances as small as possible. Instead of having a large instance of Cloud SQL, with lots of resources, it is better and simpler to manage smaller instances, with resources distributed among those instances:

Figure 9.3 – Keeping your instance small

In addition, within these instances, it is not recommended to have more than 10,000 tables, since this can affect both the response times of the instance and the SLA coverage delivered by the cloud provider. The latter is because if the instance does not respond, it is not possible to carry out maintenance operations that directly affect the availability of the service.

If it is necessary to perform a large transaction on the instance, it is recommended...