… to ensure queries work same way with different MySQL version, unless you have very detailed… easy and inexpensive to temporary get extra boxes for time of upgrade. Swapping master. …MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… rather easy to avoid, but it is still remains a way how one can break filtered replication by executing some statements on the master…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the… LVM based sync is also implemented so restoring broken replication safe way becomes very easy. Besides simple “cloning” of the nodes you can…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.10.171 Master_User: replicant Master…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… a level where we started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is… remove master role from a node Pacemaker stonith devices are supported No logical limits in term of number of nodes Easy to… 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: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…masters in Master-Master setup is often cause of the problem for similar reason as MySQL…easy to filter out events) so you can see whenever there are any suspicious events in the replication…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores and … replication capacity I call replication capacity the ability to replicate the master load. If replication is able to replicate 3 times the write load from the master… load similar as loadavg metrics. Here are some of the ways to measure it: 1) Use “UserStats” functionality from Google patches…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
Sometimes MySQL Replication may run out of sync – because of its own buts … writing to the master. In any case you need slave to be synced with Master. To discover the difference between Master and Slave… be easy to do it other way: Assuming your table schema does not change you can do something like this on the master…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…a valid approach here!). This is an easy way to bypass the hard-to-scale database …ALTER TABLE — a typical reason to think about master-master with failover and failback for maintenance. As with … replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… applications in an easy way. Customers are constantly asking me if there is something which would help them to scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or…
