Install the Google Cloud SQL App and View the Dashboards
Install the Sumo Logic App
Now that you have set up collection for Google Cloud SQL, install the Sumo Logic App Google Cloud SQL to use the pre-configured searches and dashboards that provide visibility into your environment for real-time analysis of overall usage.
To install the app:
Dashboards
Google Cloud SQL - Overview
See an overview of database activities—such as create, delete, update, and so on—in Google Cloud SQL, including activity locations, created and deleted resources, operations by resources, authorization failures, and messages over time by severity.
Location of Activity. A geolocation map that shows the locations from which database activities were initiated, and the activity count for each location over the last 24 hours.
Created Resources. A donut chart that shows a breakdown of resources created by resource type over the last 24 hours.
Deleted Resources. A donut chart that shows a breakdown of resources deleted by resource type over the last 24 hours.
Messages by Region. A table that shows the count of messages by region over the last 24 hours.
Authorization Failures. The count of authorizations failures over the last 24 hours.
Top 10 Users by Messages. A column chart the shows the count of messages by associated user, for the 10 users with the most associated messages, over the last 24 hours.
Operations by Resources. A stacked column chart that shows the count of database operations, for example connect, create, delete, and so on, by resource type.
Messages Over Time by Severity. A line chart that shows the count of messages by message severity, per one hour timeslice over the last 24 hours.
Google Cloud SQL - Activity
See information about actions, messages, operations, created and deleted resources in Google Cloud SQL.
Actions. A donut chart that shows the breakdown, by count and percentage, of invocations by action type over the last 24 hours.
Actions Over Time. A line chart that shows the count of executions per one hour timeslice for methods called over the last 24 hours.
Messages by Instance. A line chart that shows the count of messages per one hour timeslice by database instance over the last 24 hours.
Operations by Instance. A stacked bar chart that shows the count of operations—such as connect, create, delete, and so on—by database instance over the last 24 hours.
Created Resources Over Time. A column chart that shows the count of Cloud SQL resources created per one hour timeslice over the last 24 hours.
Deleted Resources Over Time. A column chart that shows the count of Cloud SQL resources created per one hour timeslice over the last 24 hours.
Google Cloud SQL - Users
See information about your Google Cloud SQL users, including user locations; user activities over time and user activity outliers; top 10 users by messages; and resource creations and deletions by user.
Location of Users. A geolocation map that shows the location and count of users over the last 24 hours.
User Activities Over Time. A stacked bar chart that shows the count of activities by user per one hour timeslice over the last 24 hours.
User Activity - Outliers. A stacked bar chart that shows when the count of activities per user varies by a statistically significant amount, three or more standard deviations, from the running average, over the last 24 hours.
Top 10 Users by Messages. A column chart that shows the top 10 users, in terms of messages, over the last 24 hours.
Creations and Deletions by User. A stacked column chart that shows the number of resource creations and deletions by user, over the last 24 hours.
Top 10 Activities by Users. A bar chart that shows the top 10 activities run by users over the last 24 hours.
Recent User Activity. A table that shows user activity over the last three hours, including severity, user, instance, method, and number of operations performed.
Google Cloud SQL - Failures
See information about failures in Google Cloud SQL, including authorization failures, by location and over time; problematic instances;and error logs.
Location of Authorization Failures. A geolocation map that shows the locations and counts of authorization failures over the last 24 hours.
Problematic Instances Over Time. A line chart that shows, for problematic database instances (instances for which messages of severity Warning, Error, Critical, Alert, or Emergency have been logged) the count of problem messages were logged per on hour timeslice over the last 24 hours.
Authorization Failures Over Time. A column chart that shows the count of authorization failures per one hour timeslice over the last 24 hours.
Authorization Failures by User - Outliers. A column chart that shows users that have had a statistically significant number of authorization failures, more than three standard deviations from the running average, over the last 24 hours.
Common Error Log Messages. A table that presents the results of a LogReduce analysis of error messages logged over the last 24 hours. Sumo’s LogReduce algorithm uses fuzzy logic and soft matching to group messages with similar structures and common repeated text strings into signatures. Note that messages that Sumo cannot readily group are separated into a distinct signature called Others.
Recent Authorization Failures. A table of information about authorization failures that occurred within the last three hours, including the associated user, action, and instance.
Recent Error Logs. A table of information about messages of severity Warning, Error, Critical, Alert, or Emergency that were logged over the last three hours.
Common Error Logs by Instance. A bar chart that shows the results of a LogReduce analysis of messages messages of severity Warning, Error, Critical, Alert, or Emergency, by instance, that were logged over the last 24 hours.