Cloud Monitoring Should Monitor Database Up Check
More Info:
Ensure Cloud Monitoring monitors database up check.Risk Level
MediumAddress
Operational Maturity, Performance EfficiencyCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the misconfiguration of not monitoring the database up check in GCP using GCP console, follow the below steps:
- Login to your GCP console.
- Navigate to the Monitoring page by clicking on the hamburger menu on the top left corner of the console and selecting “Monitoring” under the “Operations” section.
- Click on the “Uptime Checks” tab on the left-hand side of the Monitoring page.
- Click on the “Create Uptime Check” button on the top right corner of the Uptime Checks page.
- In the “Create Uptime Check” page, fill in the required details such as the name of the check, the resource type, and the resource name.
- In the “Check Type” section, select the “TCP” option.
- In the “TCP” section, enter the IP address of your database instance and the port number on which the database is running.
- In the “Advanced Settings” section, you can configure additional settings such as the check frequency, the notification settings, and the authentication settings.
- Once you have configured all the required settings, click on the “Create” button to create the uptime check.
Using CLI
Using CLI
To remediate the misconfiguration of not monitoring database up check in GCP using GCP CLI, you can follow these steps:
- 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.
- Scroll down to the “Monitoring” section and click on the “Configure monitoring” button.
- In the “Metrics” tab, select the “Database” category and check the “Database uptime” metric.
- In the “Alerting” tab, click on the “Add condition” button.
- Set the “Condition name”, “Condition trigger”, and “Condition threshold” according to your requirements.
- In the “Notification channels” section, add the email addresses or phone numbers of the people who should be notified in case of an alert.
- Click on the “Save” button to save the changes.
Using Python
Using Python
To remediate the misconfiguration “Cloud Monitoring should monitor database up check” for GCP using Python, follow these steps:
-
First, ensure that you have the necessary permissions to create a Cloud Monitoring uptime check. You will need the
monitoring.editorormonitoring.adminrole. - Import the necessary libraries and authenticate to the GCP project:
- Next, create a new uptime check using the
create_uptime_check_configmethod. In this example, we will create an HTTP check for a database running on port 3306:
- The
create_uptime_check_configmethod returns the name of the newly created uptime check. You can use this name to update or delete the check later.