Configuring MariaDB monitoring
You must configure the MariaDB agent so that the agent can collect data to monitor the availability and performance of MariaDB server resources.
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 that a user is created in MariaDB database to run the agent. The user does not require any specific privileges on the MariaDB database that is being monitored locally.
- Ensure that the performance_schema variable value is set to
ONin the my.ini file for Windows platform and my.cnf file for non-Windows platform.
- Grant the minimum permissions like SELECT, PROCESS, and EVENT to the user.
- If the user needs to monitor MariaDB 10.4 or its later versions, then you must reset root user password and provide the correct user password for configuring 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 instance name that you specify can contain up to 28 characters.