Ep 35: Monitoring SQL databases with Checkmk
Read Video Transcript
|[0:00:00]||Welcome to the Checkmk channel. Today, we are taking a closer look at our SQL databases.|
|[0:00:16]||Databases run insane amounts of applications. They store data for businesses all over the world as well as open-source projects and organizations, and you really can't think a lot of applications without an SQL database.|
|[0:00:31]||In this video, we are taking a closer look at how to monitor two of the best known SQL databases on Linux. But the process is the same, for example, for MS SQL on Windows or similar databases.|
|[0:00:43]||So, let's take a closer look at how this is configured. So, let's start with MySQL.|
|[0:00:51]||It's probably still the best known SQL database on Linux systems, quickly followed by PostgreSQL, which will be the second database that we are going to take a look at.|
|[0:01:02]||But the process in Checkmk how to monitor these databases is quite simple. To get started, we head for the Setup menu and just start searching, in this case, MySQL.|
|[0:01:14]||We want to use that rule set here, create a new rule. And there really is no configuration that we need in a default installation of MySQL and the same goes for MariaDB.|
|[0:01:26]||So, if you're confused there, it works the same, it's called MySQL in Checkmk, but it's really the same database.|
|[0:01:34]||In the default installation, the root user can log into the database without credentials, which means we don't have to configure anything here.|
|[0:01:42]||If you have some special setup, you might need to use one of these options here to provide credentials to define the socket which to connect to.|
|[0:01:51]||Maybe to connect to a remote host, that is also possible, depending on where you run the plugin. And there's some more configuration options.|
|[0:01:59]||But in the default, it really suffices here to configure deploy the MySQL plugin, and that's that.|
|[0:02:07]||I'm going to bind this to the localhost, which is our demo system here. In a production environment, of course, you would probably use a host tag or a label to find out which hosts are hosting MySQL databases to deploy the plug-in to.|
|[0:02:25]||So, I'm going to save this. And because it's the easiest, we are also directly creating the Postgres rule. Again, we just search for the term here. we see in the section of the agent rules the PostgreSQL database plug-in, which we're going to select. Again, we create a rule.|
|[0:02:47]||Here we have only some specific settings, but we don't need them either. It's good enough for default installations to deploy Postgres plug-in.|
|[0:02:56]||And again, I'm pinning that to localhost here because that's the only server we have running this. So, now I'm going to activate changes. Then we are baking and signing the agents.|
|[0:03:12]||That's done over here. And as I already enabled automatic agent updates in this site, after the baking process has finished, the agents will quite quickly fetch the new agent package, install it, and then we will be able to discover the services.|
|[0:03:27]||So, now we saw the agent baking was successful. We can take a look at the configuration and we can see that the MySQL and the PostgreSQL plug-ins have been baked into the configuration, which means when we now go to the discovery, we will find those new services.|
|[0:03:49]||So, let's go to our localhost here again. Service configuration. And after a rescan, we will find the new services and there's our services.|
|[0:04:05]||So, let's first take a quick look at the MySQL services. We have the connections to the MySQL database, we can see the IO of the storage engine, we see the overall instance state, we see the sessions to the database, and we get some version information what's running here.|
|[0:04:25]||We can actually see it's a MariaDB in this case. But you see the MySQL plug-in still works, as I said.|
|[0:04:34]||Then we see all the Postgre services. There's quite some more, but we can see there's similar information there. We also see connections here, we see the state of the daemon, we see database sizes here.|
|[0:04:47]||So, quite some information relevant to make sure your database is healthy. So, let's accept those services into monitoring here.|
|[0:04:57]||Then we can activate our changes and that's how you enable proper monitoring of MySQL and PostgreSQL databases.|
|[0:05:08]||That concludes our video for today. Thank you so much for watching. Make sure to subscribe and I will see you around.|
More Checkmk Videos
Ep. 1: Installing Checkmk 2.0 and monitoring your first host
In this video, Baris explains how to take get started with Checkmk and start monitoring your first host within a few minutes.
Ep. 2: The Checkmk 2.0 user interface
In this video, Baris take you through the new user interface in Checkmk 2.0. He explains the various components of the User interface such as the new navigation menus, the Sidebar, main dashboard, tactical overview, how to switch between the Checkmk interface themes and much more
Ep. 3: Using SNMP to monitor network devices in Checkmk 2.0
In this episode, Baris explains how to monitor network devices with Checkmk. SNMP is a protocol that many switches, routers, printers, UPSs, hardware sensors and other devices have implemented with the purpose of being able to monitor them easily.
Ep. 4: Monitoring Windows in Checkmk
In this video of our Getting started with Checkmk series, Baris explains how to install a Checkmk agent on a Windows host system and add that into your monitoring environment.
Ep. 5: Using metrics and graphs in Checkmk 2.0
In the 5th episode of the Getting started with Checkmk series, Baris explains using various metrics that you can monitor in Checkmk such as CPU utilization, CPU load etc. You can also see graph visualizations for these metrics or create and customize your own as per your requirements.
Ep. 6: Updating Checkmk 2.0 and using multiple instances
In this video, Baris explains how to update your Checkmk instance. It is very easy and can be done within minutes. You can run multiple Checkmk instances with different versions on the same system. This gives you the flexibility to test the new version before using it in production.
Ep. 7 (part 1): Working with rules and setting thresholds in Checkmk
In the following three-part videos series, Baris explains rule-based monitoring with Checkmk. In the first part, he shows you how you can work with rules and set threshold values. Rule-based configuration is one of the key features for Checkmk which helps you to scale your monitoring easily within minutes.
Ep. 7 (part 2): Smart rules with Host Tags in Checkmk
In the second part of this video, Baris explains using Smart rules with host tags in Checkmk. In the first part, he shows you how you can work with rules and set threshold values. These are features that you can use to build your rules even more intelligently and to better organize your monitoring.
Ep. 7 (part 3): Managing Hosts in Folder in Checkmk
In this final part of our episode on Rule-based monitoring in Checkmk, Baris demonstrates how to manage hosts in folders in Checkmk. This helps you to apply your monitoring configurations at scale and organize your hosts according to your needs.
Ep. 8: Working with Host and Service Groups in Checkmk
In this Baris demonstrates how to create host and service groups in Checkmk, so you can perform actions on an entire group instead of configuring each of them individually.
Ep. 9: Using the Quicksearch function in Checkmk
In this episode of the Checkmk tutorials, Baris shows how you can use the Quicksearch function in Checkmk. You can use it to easily find and manage certain hosts or services. He also explains some examples of filters to you. In Checkmk 2.0 you can use the same syntax in the Seach function found in the monitor menu to get identical results.
Ep. 10: Detecting configuration errors with the Analyze Configuration feature
With the Analyze Configuration feature, you can check if there are any configuration errors in your installation. Checkmk controls a number of possible security risks or potential performance restrictions and indicates if there are any problems.
Ep. 11: View creation and customization in Checkmk
In this video, Baris demonstrates how to customize headers, columns, and more in Views in Checkmk for yourself or other users. He also explains how to create custom views and add desired information to these views.
Ep. 12: Acknowledging problems in Checkmk
In this video, Baris explains how you can acknowledge problems in Checkmk. This function helps you to qualify the states of hosts and services. This allows you to keep track of messages in the main dashboard and, for example, you can add comments to problems.
Ep. 13: Scheduling downtimes in Checkmk
In the episode of our Getting started with Checkmk series, Baris explains how you can manage the maintenance times of your systems in Checkmk. Such scheduled downtimes prevent your monitoring from sending false alarms when a host or service goes to WARN or CRIT during maintenance work. You can also inform the users concerned about the maintenance via Checkmk.
Ep. 14: Distributed monitoring with Checkmk
In this video, Baris explains how you can connect several Checkmk instances to a monitoring system and then manage it.
Ep. 15: MKPs and Plugins in Checkmk
In the 15th episode of our Getting started with Checkmk tutorial series, Baris explains what are Checkmk Extension Packages (MKPs) and how easy it is to integrate them into your Checkmk monitoring environment. MKPs are the preferred format when you make your own extensions as it makes it easy to share with other users or deploy in distributed environments.
Ep. 16: Working with 'Bulk Actions' in Checkmk
In this episode of our Checkmk tutorials series, Baris explains how you can save a lot of time with bulk actions. With this feature you can perform various tasks such as deleting, renaming, service discovery etc. on a large number of hosts simultaneously.
Ep. 17: Working with network topologies in Checkmk
In this video of our gettign startted with Checkmk series, Baris explains how to map network topologies in Checkmk. This feature is quite helpful to manage your network and prevent any unnecessary notifications from the devices in your network.
Ep. 18: Creating and customizing dashboards in Checkmk
In this video of our Getting started with Checkmk series, Mathias explains how you can create and customize dashboards in Checkmk 2.0, so you can get insights into your monitoring according to your requirements. Find out more in this video.
Ep. 19: Monitoring websites and their certificates with Checkmk
In this episode, Bastian demonstrates how to monitor a website and its certificate with Checkmk. You can also monitor specific web pages with Checkmk by using the several options that will suit your use case. Learn more in this video.
Ep. 20: Configuring dashboard elements in Checkmk
Learn how to add data visualization elements of the various metrics into your Checkmk Dashboard. In this video, Mathias explains how you can configure these elements and create a dashboard as per your requirements.
Ep. 21: Setting up notifications in Checkmk
Learn how to set up notifications in Checkmk and assign relevant contacts and contact groups to be notified for various events. Later in this video, our presenter Bastian also demonstrates how you can set up rule-based notifications according to different conditions for hosts and services.
Ep. 22: Monitoring logfiles with Checkmk
Monitor your logfiles with Checkmk using its Logwatch plugin. It is very useful when you want to monitor your logfiles regardless of whether you are using a UNIX/Linux or a windows based system. Learn more in this video.
Ep. 24: 3 Rules for efficient network monitoring
In this video, Bastian demonstrates 3 rules that will help you to efficiently monitor your network interfaces. With Checkmk 2.0, with just three rules, you can set up an efficient network monitoring that will not only monitor all of your network interfaces but also simultaneously provide a detailed overview of all of your ports.
Ep. 25: New UX and security improvements in Checkmk 2.1
Checkmk 2.1 come with many UX improvements such as pre-built dashboards for Linux and Windows, faster core performance and much more. Security features such as two-factor authentication etc. were also added in this new version. Watch this video to learn how to use these new features and enhancements in Checkmk.
Ep. 28: Working with InfluxDB integration in Checkmk
Learn how to send data to InfluxDB from Checkmk. As InfluxDB introduced a new protocol to send data to it, a new connector was developed with Checkmk to talk natively with it. Learn more about it in this video.
Ep. 29: New agent architecture in Checkmk 2.1
With Checkmk 2.1, the agent architecture was modified to enable performance improvements and add new features such as TLS encryption, data compression, and the reversal of direction of communication from the agent. This will enable push mode and pull mode.
Ep. 30: Clustering the Checkmk appliance
In this video, Robin demonstrates how you can cluster your Checkmk appliance to make it resilient against hardware failures. If you are using the Checkmk hardware appliance, it may be helpful to cluster your appliance to maintain high availability.
Ep. 32: Working with the Agent bakery in Checkmk
In this video, Robin demonstrates how to roll out agent packages with the required configuration for different monitored systems using the agent bakery in Checkmk. The "Automatic agent update" is quite a helpful feature as it pulls the latest configurations for an agent automatically and you don't need to manually update all of your agents deployed on different systems.
Ep 33: Monitoring Docker containers with Checkmk
Learn how to monitor Docker containers with Checkmk.In this video, Robin demonstrates the process of setting up a rule to configure the docker plugin and bake an agent with the desired settings for the Docker host.
Ep 34: Introduction to Checkmk Ansible collection
Last year the Checkmk Ansible collection was created to interact with the Checkmk REST API. In this video, Robin demonstrates how you can use this Ansible collection to automate your monitoring with Checkmk.