search cancel

Logging of failure in DB replication


Article ID: 104026


Updated On:


STARTER PACK-7 CA Rapid App Security CA API Gateway


The ssg logs dont really have any trace of replication since that is from the mysql <-> mysql directly. The mysql commands to look for replication error are :
> show slaves;
> show slave status;

will show the last replication error. And the file /var/log/mysqld.log will also have errors if there is issue with replication.

But is there any way that mysql errors can be logged to syslog.


APIM Gateway 9.2 
APIM Gateway 9.3


Gateway 9.2 
The version of mysql is 5.5 : so there are some methods that can be used : 

Gateway 9.3: 

Now comes with mysql 5.7 which has better syslog support : 

Some of those options look like what you want.