… and preventions. You can read more about that research …mysql-replication-running checks that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure, replication… error appropriately. The pmp-check-mysql-status plugin can be configured…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 10 Comments
…MySQL Error Messages which are confusing, here is one more: 080603 20:53:10 [Note] Slave: connected to master ‘repl@host.com:3306′,replication…configuration error) two slave servers got the same server-id. Seriously in this case Master…
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
…for most of the reads, and this is…error which deletes/trashes all the data and gets replicated to all the slaves ? When you compare master-master…master-N-slave configuration will be saturated much faster because it has to handle much more write load. Especially keeping into account MySQL replication…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…replication instead of MySQL replication. Problem: you end up with an idle standby server, which can’t be used for serving reads…order. If any error occurred, such as… to multiple masters, which is currently…replication currently does, and only enable the multi-threaded behavior if the user configures…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL… master-master pair as well as other configurations such as master-master…error ? Well you’ll break replication often without knowing about it. You can kind of solve it with using read…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…read from and/or write to remote servers, but this example uses the local machine which is the usual configuration…mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
…query execution time including execution errors and warnings. So … and let it replicate until such time you… is consistent across the master and the slave with…testing – one that has read (i.e. SELECT) …MySQL version, you should also consider running these tests on similar hardware and OS configuration…
