MySQL

Pre-requisites

Check the supported versions

DBmarlin supports most versions of MySQL from 5.6 and above. Please check the list of supported platforms before continuing and contact us if you are not sure.

Create a monitoring user with the correct permissions

Before adding a target MySQL instance in the UI you should first create a dbmarlin user in the target database instance.

CREATE USER dbmarlin IDENTIFIED BY 'securepassword';
GRANT SELECT,PROCESS,SHOW DATABASES on *.* to 'dbmarlin'@'dbmarlinserver';
GRANT REPLICATION CLIENT ON *.* to 'dbmarlin'@'dbmarlinserver';
FLUSH privileges;

Replace dbmarlinserver above with the IP or hostname of the server where you installed DBmarlin.

Adding the Database Target

This is done through the User Interface using the Add Database screen