Configuring MariaDB monitoring

Edit online

You must configure the MariaDB agent so that the agent can collect data to monitor the availability and performance of MariaDB server resources. Refer the following prerequisites to configure the MariaDB agent for both remote and local monitoring.

Before you begin

Ensure that the system requirements for the MariaDB agent are met in your environment. For the up-to-date system requirement information, see the Software Product Compatibility Reports (SPCR) for the MariaDB agent.
  • Ensure the performance_schema variable value is set to ON in my.cnf file for non-Windows platform and my.ini file for Windows platform.
  • Grant the minimum permissions like SELECT, PROCESS and EVENT to the user.
  • If user wants to monitor MariaDB 10.4 or later version database server, reset root user password and provide correct user password for configuration of MariaDB agent.

About this task

The MariaDB agent is a single instance agent. You must configure the agent manually after it is installed. You can configure the agent on Windows and Linux® operating systems. The agent requires an instance name and the MariaDB server user credentials to configure it. The managed system name includes the instance name that you specify, for example, instance_name:host_name:pc, where pc is your two character product code. The managed system name can contain up to 32 characters. The instance name that you specify can contain up to 28 characters, excluding the length of your hostname. For example, if you specify MariaDB as your instance name, your managed system name is MariaDB:hostname:MJ.
Important: If you specify a long instance name, the managed system name is truncated and the agent code is not displayed.