Page History
...
If you want to collect data from the server, you need to select "Enable Data Collection", so that SQL DM for MySQL collect and store various MySQL and OS metrics.
...
This feature of SQL DM for MySQL saves you time from registering each slave individually. In order to ask for SQL DM for MySQL to auto-register all slaves, you need to 'check' the option select the toggle switch to enable "Auto-Register slaves" in the 'Advanced settings' tab while registering a slave. If a master is already registered, click 'Edit Server' and check the 'Auto-Register slaves' in the 'Advanced settings' tab. The MySQL and the SSH details of the slaves are assumed to be the same as that of the 'master'. In case the slave details are different from that of the master, you have to manually edit that server and change details.
The auto-registering of slaves is extended to multiple levels of replication. For instance, lets say Server A is a Master that has Server B as the slave. And Server B has Server C as its slave. In such case, while registering Server A, if you check 'Auto-Register Slaves', then it registers A, B and C provided the MySQL and the SSH details of the A is same as that of B.
...
Use this option to Auto register all the Galera nodes of your cluster with SQL DM for MySQL. The MySQL and the SSH details of the nodes are assumed to be the same as that of the node on which you are enabling this option. In case the other node details are different from that of the node on which you are enabling this option, you need to manually edit that server and change details. You can do a “Test” “Test” to check if SQL DM for MySQL is able to connect to the other nodes. If the “Test” “Test” gives a successful message then you can go ahead and click “Save”“Save”. SQL DM for MySQL will then register the detected nodes and redirect you to the Servers page where you can see all the registered nodes.
...
The MySQL error log is quintessential in determining the health of the server. You can enable Enable error log monitoring to allow SQL DM for MySQL to keep an eye on your MySQL Error Log, and notify you of important information that may save you many sleepless night.
...
Enable error log monitoring:
Select "Yes" if you want to enable the toggle switch to Enable error log monitoring.
Read file from:
There are 3 ways of accessing the log files: Select "Local path"if the logs are in the machine where SQL DM for MySQL is running, or if they can be accessed by SQL DM for MySQL on a shared network drive. Choose "Via SFTP"if you have configured SQL DM for MySQL to use SSH. Select "RDS/Aurora (Using API)"if your server is a RDS/Aurora instance. In case of RDS/Aurora (Using API) for file based logging, four additional fields have to be filled, which are:
...