Forum Discussion

Joe_Proietti's avatar
Joe_Proietti
13 years ago

Replication Monitoring

I do not have a clear understanding how to set up Logic Monitor to do MYSQL replication monitoring. Is there some that could assist me in setting up my Logic Monitor to do that?

  • Mike_Aracic's avatar
    Mike_Aracic
    Icon for Employee rankEmployee
    13 years ago

    There are two kinds of MySQL Slave monitoring. (Both described here) The first, basic kind, is slave status, which is an indication of how effectively the slave database is applying the replication information to itself. The second is replication lag, which uses a pair of datasources, along with a dedicated LogicMonitor database on the servers, to measure the actual amount of time between inserting a record in the master and being able to retrieve that record on the monitored slave instance. For that youll need to configure the credentials and add the database as described here.