MySQL and PostgreSQL agent for Google Cloud Platform (GCP) CloudSQL and AlloyDB
说明
Do the MySQL and PostgreSQL agents support Google Cloud Platform (GCP) CloudSQL and AlloyDB?
解决办法
CloudSQL for MySQL The performance_schema database flag is not enabled by default and needs to be enabled for monitoring relying on those tables. GCP requires that the database instance is allocated at least 16GB RAM in order to do this.
CloudSQL for PostgreSQL and AlloyDB for PostgreSQL Enabling pg_stat_statements does not require setting shared_preload_libraries or restarting the server as required for a standalone instance, only executing “CREATE EXTENSION pg_stat_statements”. Also, like the equivalent reserved system databases used by other cloud providers, “cloudsqladmin” and “alloydbadmin” cannot be connected to in order to monitor their objects.
Database-level stats can be collected however this may have limited usefulness. To avoid generating errors on connection attempts, these will be added to the default excluded databases list in the agent properties of the PostgreSQL cartridge.
Note: AlloyDB cluster currently cannot be given an external IP, so it can only be accessed from inside its VPC or setting up a proxy or other GCP network application to allow external connections. This is limitation of AlloyDB and not Foglight.
