- \n
- A DigitalOcean account with managed databases (except MongoDB).<\/li>\n
- Basic understanding of bash programming.<\/li>\n
- The Prometheus droplet is deployed from the DigitalOcean Marketplace.<\/li>\n
- A Grafana droplet deployed from the DigitalOcean Marketplace<\/li>\n
- Installed dependencies: jq<\/li>\n
- A personal access token created with database read access.<\/li>\n<\/ul>\n
Preparation of Prometheus Drops<\/h5>\n
Step 1: SSH into the Prometheus droplet.<\/h5>\n
Step 2: Download the scrape.sh script using the wget command:<\/h5>\n
\nwget https:\/\/solutions-files.ams3.cdn.digitaloceanspaces.com\/DBaaS-Scrape-Metrics\/scrape.sh\r\n<\/code><\/pre>\n<\/div>\nStep 3: After downloading the script, make sure it has executable permissions by running the following:<\/h5>\n
\nchmod +x scrape.sh\r\n<\/code><\/pre>\n<\/div>\nStep 4: Run the scrape.sh script by running:<\/h5>\n
\n.\/scrape.sh\r\n<\/code><\/pre>\n<\/div>\nNote: If jq is not installed on the Droplet, you will encounter this error:<\/p>\n
\nroot@prometheus:~# .\/scrape.sh\r\nChecking dependencies...\r\nError: jq is not installed. Please install it before running this script.<\/code><\/pre>\n<\/div>\nIn this case, you can install jq on the Droplet by running the following commands:<\/p>\n
\nsudo apt-get update && sudo apt-get install jq\r\n\r\n<\/code><\/pre>\n<\/div>\nIf you encounter the following error while installing jq, remove the lock file by running the command sudo rm \/var\/lib\/dpkg\/lock*.<\/p>\n
\nroot@prometheus:~# sudo apt-get install jq\r\nE: Could not get lock \/var\/lib\/dpkg\/lock-frontend - open (11: Resource temporarily unavailable)\r\nE: Unable to acquire the dpkg frontend lock (\/var\/lib\/dpkg\/lock-frontend), is another process using it?\r\nroot@prometheus:~# sudo dpkg --configure -a\r\ndpkg: error: dpkg frontend is locked by another process\r\nroot@prometheus:~# sudo rm \/var\/lib\/dpkg\/lock*\r\nroot@prometheus:~# sudo apt-get install jq\r\nReading package lists... Done\r\nBuilding dependency tree \r\nReading state information... Done<\/code><\/pre>\n<\/div>\nAfter installing jq, run the script again.<\/p>\n
Step 5: Select the managed database you want to manage by entering its number.<\/h5>\n
Step 6: Enter your DigitalOcean password.<\/h5>\n
Step 7: In the main menu, select the required option and select the database.<\/h5>\n
Step 8: The script adds or removes databases for monitoring.<\/h5>\n
Step 9: After adding or removing, check if the targets on prometheus_hostname:9090 are updated.<\/h5>\n
Adding databases to monitoring<\/h2>\n
Removing databases from monitoring<\/h2>\n
Preparing Grafana Droplet<\/h2>\n
Step 1: Log in to the Grafana dashboard by visiting the URL Grafana_IP:3000 in your browser.<\/p>\n
Step 2: Go to Configuration > Data Sources.<\/p>\n
Step 3: Click Add Data Source.<\/p>\n
Step 4: Search and select Prometheus.<\/p>\n
Step 5: Enter the name as Prometheus, URL (Prometheushostname:9090) and click \u201cSave and Test\u201d. If you see \u201cData source is working\u201d, you have successfully added the data source. Once done, go to Create > Import.<\/p>\n
Step 6: You can configure the dashboard manually or import the dashboard by uploading a JSON file. Below are some examples of dashboard JSON files:<\/p>\n
Step 7: Fill in the fields and submit.<\/p>\n
Step 8: Grafana dashboard is ready. Select the host and check if the metrics are visible or not. You can modify and edit the dashboard if needed.<\/p>\n
Result<\/h2>\n
Setting up monitoring for DigitalOcean managed databases using Prometheus and Grafana increases your ability to ensure the performance, stability, and security of your database clusters.<\/p>\n
By using Prometheus to scrape metrics and Grafana to visualize them, you gain comprehensive insight into database health and performance metrics.<\/p>\n
This proactive approach enables efficient management and timely troubleshooting, which is crucial for maintaining optimal database operations. With the steps outlined in this documentation, you can easily implement robust monitoring tailored to your specific database needs and ensure the smooth operation of your DigitalOcean managed databases.<\/p>","protected":false},"excerpt":{"rendered":"Introduction Monitoring your DigitalOcean managed databases is essential to ensure their performance, stability, and security. With\u2026","protected":false},"author":1,"featured_media":15886,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","_yoast_wpseo_canonical":"","_yoast_wpseo_opengraph-description":"","_yoast_wpseo_opengraph-image":"","_yoast_wpseo_twitter-description":"","_yoast_wpseo_twitter-image":"","_yoast_wpseo_focuskeywords":"","_yoast_wpseo_primary_category":"","footnotes":""},"categories":[193],"tags":[403,401,438],"class_list":{"0":"post-15874","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tutorials","8":"tag-data-base","9":"tag-digitalocean","10":"tag-monitoring"},"yoast_head":"\n
\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana - \u0628\u0644\u0627\u06af ITPiran<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itpiran.net\/blog\/en\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana - \u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"og:description\" content=\"\u0645\u0642\u062f\u0645\u0647 \u0646\u0638\u0627\u0631\u062a \u0628\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a\u200c\u0634\u062f\u0647 DigitalOcean \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f\u060c \u062b\u0628\u0627\u062a \u0648 \u0627\u0645\u0646\u06cc\u062a \u0622\u0646\u200c\u0647\u0627 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a. \u0628\u0627…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.itpiran.net\/blog\/en\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-15T12:55:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.itpiran.net\/2024\/07\/15162337\/dd.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1793\" \/>\n\t<meta property=\"og:image:height\" content=\"1110\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\"},\"headline\":\"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana\",\"datePublished\":\"2024-07-15T12:55:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/\"},\"wordCount\":68,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/15162337\\\/dd.jpg\",\"keywords\":[\"data base\",\"Digitalocean\",\"Monitoring\"],\"articleSection\":[\"\u0622\u0645\u0648\u0632\u0634\u06cc\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/\",\"name\":\"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana - \u0628\u0644\u0627\u06af ITPiran\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/15162337\\\/dd.jpg\",\"datePublished\":\"2024-07-15T12:55:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/15162337\\\/dd.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/07\\\/15162337\\\/dd.jpg\",\"width\":1793,\"height\":1110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/category\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"name\":\"\u0628\u0644\u0627\u06af ITPiran\",\"description\":\"\u0627\u062e\u0628\u0627\u0631 \u0648 \u0645\u0642\u0627\u0644\u0627\u062a \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\",\"name\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"alternateName\":\"ITPIran Blog\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"width\":512,\"height\":512,\"caption\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\",\"name\":\"admin\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/en\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting up monitoring for DigitalOcean managed databases with Prometheus and Grafana - ITPiran Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itpiran.net\/blog\/en\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/","og_locale":"en_US","og_type":"article","og_title":"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana - \u0628\u0644\u0627\u06af ITPiran","og_description":"\u0645\u0642\u062f\u0645\u0647 \u0646\u0638\u0627\u0631\u062a \u0628\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a\u200c\u0634\u062f\u0647 DigitalOcean \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f\u060c \u062b\u0628\u0627\u062a \u0648 \u0627\u0645\u0646\u06cc\u062a \u0622\u0646\u200c\u0647\u0627 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a. \u0628\u0627…","og_url":"https:\/\/www.itpiran.net\/blog\/en\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/","og_site_name":"\u0628\u0644\u0627\u06af ITPiran","article_published_time":"2024-07-15T12:55:50+00:00","og_image":[{"width":1793,"height":1110,"url":"https:\/\/cdn.itpiran.net\/2024\/07\/15162337\/dd.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#article","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/"},"author":{"name":"admin","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81"},"headline":"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana","datePublished":"2024-07-15T12:55:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/"},"wordCount":68,"commentCount":0,"publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/15162337\/dd.jpg","keywords":["data base","Digitalocean","Monitoring"],"articleSection":["\u0622\u0645\u0648\u0632\u0634\u06cc"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/","url":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/","name":"Setting up monitoring for DigitalOcean managed databases with Prometheus and Grafana - ITPiran Blog","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#primaryimage"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/15162337\/dd.jpg","datePublished":"2024-07-15T12:55:50+00:00","breadcrumb":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#primaryimage","url":"https:\/\/cdn.itpiran.net\/2024\/07\/15162337\/dd.jpg","contentUrl":"https:\/\/cdn.itpiran.net\/2024\/07\/15162337\/dd.jpg","width":1793,"height":1110},{"@type":"BreadcrumbList","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/developer-center-setting-up-monitoring-for-digitalocean-managed-databases-with-prometheus-and-grafana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itpiran.net\/blog\/"},{"@type":"ListItem","position":2,"name":"\u0622\u0645\u0648\u0632\u0634\u06cc","item":"https:\/\/www.itpiran.net\/blog\/category\/tutorials\/"},{"@type":"ListItem","position":3,"name":"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u0627\u0646\u06cc\u062a\u0648\u0631\u06cc\u0646\u06af \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 DigitalOcean \u0628\u0627 Prometheus \u0648 Grafana"}]},{"@type":"WebSite","@id":"https:\/\/www.itpiran.net\/blog\/#website","url":"https:\/\/www.itpiran.net\/blog\/","name":"ITPiran Blog","description":"Iranian Sustainable Trade News and Articles","publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itpiran.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.itpiran.net\/blog\/#organization","name":"Sustainable Iranian Business Blog","alternateName":"ITPIran Blog","url":"https:\/\/www.itpiran.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","contentUrl":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","width":512,"height":512,"caption":"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81","name":"admin","url":"https:\/\/www.itpiran.net\/blog\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/15874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/comments?post=15874"}],"version-history":[{"count":1,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/15874\/revisions"}],"predecessor-version":[{"id":15885,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/15874\/revisions\/15885"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/media\/15886"}],"wp:attachment":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/media?parent=15874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/categories?post=15874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/tags?post=15874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15160334\/1-5.png\")
If you encounter the following error while installing jq, remove the lock file by running the command sudo rm \/var\/lib\/dpkg\/lock*.<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15160631\/2-2.png\")
<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15160822\/3-1.png\")
<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15160937\/4-1.png\")
<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15161051\/5-1.png\")
<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15161138\/6-1.png\")
<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15161252\/7-1.png\")
<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15161421\/8-1.png\")
<\/p>\n![\"\"](\"https:\/\/cdn.itpiran.net\/2024\/07\/15161524\/9-1.png\")
<\/p>\n