New answers tagged mysql-replication
It looks like you don't fully understand how NRPE works. You do not have the check_nrpe plugin installed on your Nagios server, or the path to it is wrong. It's difficult to say for sure, without seeing your check_nrpe commad definition. Also, you don't seem to fully understand how to pass macros to check_nrpe... ...
MySQL Multi-Source Replication enables a replication slave to receive transactions from multiple sources simultaneously. It is supported by Mysql 5.7.6 or later. Here there is the documentation http://dev.mysql.com/doc/refman/5.7/en/replication-multi-source.html https://www.percona.com/blog/2013/10/02/mysql-5-7-multi-source-replication/
Have you tried using Triggers? DELIMITER $$ CREATE TRIGGER sync_table1_insert AFTER INSERT ON `table1` FOR EACH ROW BEGIN INSERT INTO table2 (id, value) VALUES (NEW.id, NEW.value); END; $$ DELIMITER ; DELIMITER $$ CREATE TRIGGER sync_table1_update AFTER UPDATE ON `table1` FOR EACH ROW BEGIN UPDATE table2 SET value = NEW.value WHERE id = NEW.id; ...
Top 50 recent answers are included