… more the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each, so… async replication you have the luxury of not blocking the master from taking writes if bandwidth is constrained and the slaves lag…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication… all writes (and therefore s3 and s4 are also lagging behind). s2> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ # s1 …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… moving from async to synchronous replication is right for their application or not. Facts about Galera replication There’s a lot of… has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse… RTT, it could get slower if apply times start to lag. So what about my application? Think about your workload. How…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump …. This is because before Galera can create writesets for the replicated events, binlog events must be generated for the transactions first… jobs and getting them through the replication stream expect some replication lag. This is because because synchronous replication inside PXC has an additional overhead…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… to Galera is existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that… allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql…’s reasonable to increase the fc_limit because the only lagging nodes will be the slaves with no writes coming from…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby server which… mysqld is running on the standby server and that replication is not lagging. Unfortunately, that’s often not sufficient for failover during…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines everything is… to catch up. MySQL or OS version changesMySQL version changes (even minor upgrade) may introduce issues which causes replication lag. Same may happen… taken at the wrong time may be responsible for unexpected MySQL replication lag.
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… quite common in MySQL world and in fact I already wrote about it. There are many aspects of managing mysql replication lag such as… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means if…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… load spikes as load spikes will frequently cause replication lag spikes as well. Locks – MySQL Replication SQL Thread executes queries same as any other… manage replication lag and to understand what is loading your replication it is also helpful to examine execution time of queries being replicated. Unfortunately MySQL…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its communication layer…=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-options… set this to false otherwise Pacemaker will stop MySQL on a slave that lags behind. This will absolutely not help its recovery…
