{"id":63322,"date":"2022-04-01T09:02:03","date_gmt":"2022-04-01T09:02:03","guid":{"rendered":"https:\/\/www.cryptocabaret.com\/?p=63322"},"modified":"2022-04-01T09:02:03","modified_gmt":"2022-04-01T09:02:03","slug":"monitor-your-databases-with-this-open-source-tool","status":"publish","type":"post","link":"https:\/\/www.cryptocabaret.com\/?p=63322","title":{"rendered":"Monitor your databases with this open source tool"},"content":{"rendered":"

Monitor your databases with this open source tool<\/span>
\nDave Stokes – \u2026<\/a><\/span>
\nFri, 04\/01\/2022 – 03:00<\/span><\/p>\n

\n
Up<\/div>\n
Register<\/a> or Login<\/a> to like.<\/div>\n<\/div>\n
\n

I have been using databases for a lot longer than I care to admit, and a lot of that time has been spent looking at the entrails of servers, trying to determine exactly what they were doing. Thank goodness for the engineers behind the MySQL Performance Schema and Information Schema and their efforts to provide solid information. And then came the Sys schema with handy prepackaged peeks at the server. Before the advent of those schemas, there was no easy way to get granular information about a database instance.<\/p>\n

But peering at tabulated displays at the information of one point in time does not allow for trend-spotting or a quick glance to ascertain a server’s status. Being able to spot a trend on a graph or have alerts sent when a threshold is reached is vital. My friends in the PostgreSQL and MongoDB worlds had the same problem. The good news is that there is an open source solution for all three databases that is easy to install and use.<\/p>\n<\/p>\n

\n
More great content<\/div>\n
\n
Free online course: RHEL technical overview<\/a><\/div>\n
Learn advanced Linux commands<\/a><\/div>\n
Download cheat sheets<\/a><\/div>\n
Find an open source alternative<\/a><\/div>\n
Explore open source resources<\/a><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

I am a fairly new employee at Percona but have been around MySQL<\/a> for a long<\/em> time. One of my first goals was to learn how to set up and use Percona Monitoring and Measurement (PMM). I know a whole slew of folks who use it happily, but I had only worked with it for a few moments at a trade show. My natural trepidation at installing anything that provided graphical information linked to a database was established well before open source databases were around. This hesitation is rooted in attempts to configure other monitoring software for proprietary databases.<\/p>\n

The TL;DR is that PMM is simple to install and use. The documentation is well written, detailed, and handy. The software itself is easy to obtain and install. The overall experience is a ten out of ten.<\/p>\n

Test case<\/h2>\n

I like to try new stuff on old laptops, so I installed a fresh copy of Ubuntu 20.04 LTS. Next, I read the PMM documentation<\/a>.<\/p>\n

I should say I read the documentation twice while muttering it can’t be that simple<\/em>. At the end of this article you will find the commands I entered to install the PMM server and the agents (MySQL, PostgreSQL, and Mongo). It’s a cookbook showing how to recreate this test case.<\/p>\n

Here are the Percona Database Distributions:<\/p>\n