Cloud Monitoring Should Monitor Database Uptime Check
More Info:
Ensure Cloud Monitoring monitors database uptime check.Risk Level
MediumAddress
Operational Maturity, Performance EfficiencyCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the misconfiguration of not monitoring database uptime check in GCP using the GCP console, follow these steps:
- Go to the Cloud Console and navigate to the Cloud SQL instances page.
- Select the instance that you want to monitor and click on the “Edit” button.
- Scroll down to the “Alerting” section and click on the “Add alerting policy” button.
- In the “Add alerting policy” dialog box, select “Metric” as the “Condition type”.
- From the “Metric” drop-down list, select “Cloud SQL Database”.
- From the “Metric type” drop-down list, select “Uptime Check”.
- In the “Filter” section, select the specific database that you want to monitor.
- In the “Condition” section, set the threshold for the uptime check that you want to monitor.
- Click on the “Add” button to create the alerting policy.
- Finally, click on the “Save” button to save the changes.
Using CLI
Using CLI
To remediate the misconfiguration of not monitoring the database uptime check in GCP using GCP CLI, you can follow these step-by-step instructions:
- Open the Google Cloud Console and navigate to the Cloud SQL instances page.
- Select the instance that you want to monitor and click on the “Edit” button.
- In the “Settings” section, click on the “Monitoring” tab.
- Scroll down to the “Uptime check” section and click on the “Add uptime check” button.
- In the “Add uptime check” dialog box, enter the following information:
- Check name: A descriptive name for the uptime check.
- Resource type: Select “Cloud SQL instance” from the dropdown menu.
- Resource name: Select the name of the instance that you want to monitor.
- Protocol: Select “HTTP” or “HTTPS” depending on your needs.
- Request path: Enter ”/”. This will check if the server is responding to requests.
- Port: Enter the port number that the database is running on (default is 3306).
- Monitoring interval: Select how often you want to check the uptime (e.g. every 1 minute).
- Timeout: Select the maximum amount of time that the check should wait for a response (e.g. 5 seconds).
- Click on the “Save” button to add the uptime check to the instance.
- Verify that the uptime check is working by checking the “Uptime checks” tab in the Cloud SQL instance details page.
Using Python
Using Python
To remediate the misconfiguration of not monitoring database uptime check on GCP, you can follow the below steps using Python:This code creates an uptime check for a Cloud SQL database, which checks the database’s root URL every minute and looks for the string “Database is up” in the response.This code creates an email notification channel for the email address “[email protected]” and sets the severity label to “high”.This code creates an alerting policy that triggers when the uptime ratio of the Cloud SQL database drops below 99% for 5 minutes. The policy sends an email notification to the “[email protected]” address when triggered.By following these steps, you can remediate the misconfiguration of not monitoring database uptime check on GCP using Python.
- First, you need to create a Cloud Monitoring uptime check for your database. You can do this using the Google Cloud Console or the Cloud Monitoring API. Here is an example Python code to create an uptime check using the Cloud Monitoring API:
- Once you have created the uptime check, you need to create a notification channel to receive alerts if the check fails. You can do this using the Cloud Monitoring API or the Google Cloud Console. Here is an example Python code to create a notification channel using the Cloud Monitoring API:
- Finally, you need to create an alerting policy that uses the uptime check and notification channel to send alerts if the database goes down. You can do this using the Cloud Monitoring API or the Google Cloud Console. Here is an example Python code to create an alerting policy using the Cloud Monitoring API: