Sql Replication Monitoring
-
Hello
Below is a functional implementation of SQL Replication Monitoring. I understand that there will be a cleaner solution in future: https://www.netxms.org/forum/general-support/using-netxms-to-monitor-mysql-replication-status-and-progress/msg11314/#msg11314
However in the mean time;
agent config needs the following line;
ExternalParametersProvider=mysql -uuser --host=ipaddress -ppassword --execute "SHOW slave status\G" | sed 's/ //g;s/:/=/g;s/^/SqlSlave./':60DCI Collection will be avaliable for all the slave status commands prefixed with SqlSlave. IE SqlSlave.Slave_IO_Running and SqlSlave.Slave_SQL_Running.
Hopefully will save some time for someone else trying to achieve the same
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login