In on-host monitoring, the agent runs on the server it will monitor and uses packet sniffing to capture query data. Use this installation method if:
- You are monitoring a MySQL or PostgreSQL database you manage (whether on your own hardware or on EC2)
- You are monitoring MongoDB or Redis
If you have multiple database servers running on one server and only wish to monitor some of them, please see the Advanced Installation instructions where you will find details how to specify which database to monitor.
This currently supports unencrypted TCP traffic only; if you are using an encrypted connection (or any connection other than TCP), you will need to use the off-host installation method.
On the Inventory page, begin by opening the wizard, either by clicking “Setup your first host” (if this is the first time you are adding a host), or “Add New Host” if it is not.
Once the wizard has opened, select “On-Host.” Run the commands to download and install the agent, which will then detect the databases that can be monitored. Select the database you wish to monitor from the list which appears below and click “Set Credentials.”
On the Set Credentials screen, enter the address and login information for the service you wish to monitor. This page will look slightly different depending on the kind of service (MySQL, PostgreSQL, etc.).
This will be the login that DPM uses to connect. You can use either the environment’s default credentials, or set custom credentials if necessary. For more information about setting and configuring credentials, see here. Then select “Create User.”
For MySQL, PostgreSQL, and MongoDB, if you have not already created a user with the correct permissions for allowing DPM to monitor the database, you can do that now. For more information on the privileges required for monitoring and the purpose each privilege serves, refer to our Privileges documentation.
Then select “Check Agents.”
After ensuring that the plugins have correctly checked-in, you can proceed to the last step and create additional users within your organization so that they will have access to DPM.