July 2018
Intermediate to advanced
506 pages
16h 2m
English
Both MySQL and PostgreSQL are highly configurable. With self-hosted databases, teams would likely maintain a configuration file to be used by the database in order to customize behavior as needed. With Cloud SQL, teams simply set database flags as needed through a managed interface. Cloud SQL takes ownership of managing and applying these flags. Flags vary by database type and version. To see the full list of flags for all versions of MySQL and PostgreSQL, run the following command:
gcloud sql flags list
As shown in this command's output, flags have specific value types, including STRING, BOOLEAN, and FLOAT. An instance's flags can be managed from the Cloud Console or via gcloud. Several flags are useful when diagnosing performance ...