March 2019
Beginner to intermediate
778 pages
34h 20m
English
There are a number of mechanisms in place for scaling databases as they increase in size and load. A single second generation MySQL instance is capable of handling up to 10 TB of data and 4,000 simultaneous connections, assuming it is running on a machine with non-shared cores (db-f1-micro and db-g1-small). For compute resources, a single instance running on db-n1-standard-64 may boast up to 64 vCPUs and 240 GB of RAM.
For most applications, starting with a db-n1-standard-64 instance and 10 TB of storage doesn't make any sense. Instead, teams will likely wish to perform some capacity planning to determine what machine type and storage they need, and increase resources as demand grows.
Read now
Unlock full access