… consider “MySQL replication” and “Master-Master with MMM manager” otherwise, you can only consider the other three solutions. Data 100% safe MySQL replication no Master-Master with MMM… the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL DBA + good Sysadmin skills…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
Post: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
…criticizes Master-Master approach, finding Master with many slaves more optimal. There is surely room for master-N-slaves systems but I find Master-Master replication much…to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before it…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… Dual-Master Setup - I’m kind of obligated to attend this one, this covers a bit of a 101 about replication conflicts… a single-mastered data store and why it’s a hard problem to solve. State of the Art for MySQL Multi-Master Replication - (Robert Hodges, Continuent) – Robert is the master in discussing the pros and cons of…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…master replication, the other master should also replicate events : Closer look: Infinite Replication Loop flow: If you have master-master…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… the preferred master If replication on a slave breaks or lags beyond a defined threshold, the reader VIP(s) is removed. MySQL is… be located on the master During a master switch, connections are killed on the demoted master to avoid replication conflicts All slaves are in… MySQL unix socket file replication_user: The user to use when setting up replication. It is also currently used for the ‘CHANGE MASTER TO…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… a Slave to Master we will need to do some steps to enable all the events replicated from the master because as we…. So all used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t VALUES(@this…://bugs.launchpad.net/percona-server/+bug/860910. In a master-master setup a master can show a wrong ‘SHOW SLAVE STATUS’ output when…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… active and passive masters in Master-Master setup is often cause of the problem for similar reason as MySQL Restart – the traffic … content. Replication Traffic Changes Changing in the replication traffic (what updates are being replicated) are frequent cause of concern. Remember replication runs …
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… master. Finally as you have your slave running on new MySQL version you want to promote it to the master and upgrade Master too… run into some serious issues with Master. In many cases you can leave the ex-Master as a slave so you can… possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication stream correctly…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…_behind_master or the delay indicated by the pt-heartbeat tool, if you choose), and actual failure. The pmp-check-mysql-replication-delay…-check-mysql-replication-running checks that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure, replication can…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…’s see one example. We’re running a typical master-slave replication with ROW based binary log file. The application connects to… you run a big UPDATE, INSERT or LOAD DATA INFILE MySQL send the rows to the Binary Log Cache before writing… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are…
