… he 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 …example if we have 6 boxes we can use 1 master and 5 slaves or 3 master-master pairs. In this case each of the master-master…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…Master-Master replication (often in active-passive mode) is popular …master-master pair as well as other configurations such as master-master and bunch of slaves. Typically you would define “roles” for example… time for master-master pair. Each of the roles will have pair of IPs associated with it …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…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…example, “setting up replication” can be as simple as CHANGE MASTER…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master with LOAD DATA INFILE, which kind of emulates row-based replication in… day at a time, for example. There are a lot of other ways you can make replication faster. I wrote a…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… before the statement itself. So all used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert… with this described on https://bugs.launchpad.net/percona-server/+bug/860910. In a master-master setup a master can show a wrong ‘SHOW SLAVE…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…to know about partial replication – you can do filtering on the Master or on the Slave. Filtering on the Slave is normally preferred …complicated math of dealing with binary log positions. For example cloning Master (and dropping not replicated tables) to set up replication becomes more tricky …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… can we estimate replication capacity, so we can deal with replication load before slave is unable to catch up. Need to replication capacity is not… the master without falling behind I will call it replication capacity of 3. When used with context of applying binary logs (for example point…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
…example below) This brings us to yet another rule for smart replication – do not make Slave…replication lagging when batch jobs are running. These can load master significantly during their run time and make it impossible for slave…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 1 Comment
… MySQL Master-Master replication pairs in Active-Passive mode …master) or if you had slave lag during the switch you can have replication stopped with…replication will not detect all conflicts – it is for example possible for the same row to get different updates on master and slave and replication…
Post: How expensive is MySQL Replication for the Master
January 16, 2010 By 13 Comments
…replication as being quite low overhead on Master, depending on number of Slaves. What kind of load extra Slave…replication threads to be woken up in the batches. For example we could tune the system to wake up the thread feeding slave…
