One common theme in the questions our MySQL Support customers ask is Replication Lag. The story is typically along the lines everything is… has changed to the replication traffic, changes to concurrent traffic on the slave can affect replication capacity a lot. Checking traffic for changes…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… 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… room for replication thread. You can also have controlled execution of batch job – this is when they will check slave lag every so…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… those graphs: You can see the CPU usage and the replication lag… once again cacti is very helpful ! How to fix then… been executed) and slave is restarted on mysql 1 Note: you can also check all the statements that were in the loop….1/en/replication-implementation-details.html [2] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replicate-same…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket=”/var/run/mysqld/mysqld.sock” replication_user=”root” \ replication_passwd=”rootpass” max_slave_lag… interval=”5s” role=”Master” OCF_CHECK_LEVEL=”1″ \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1″ primitive reader_vip_1…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can …take time to replicate to the slave replication lag can be significant. Also even very small lag can cause the … on blog level or on post level – checking when post was last modified/commented and …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…load growth by only 50%. – Delays in replication MySQL replication is fast which means in average delay…the master, even on completely unrelated table, replication lag may increase dramatically. Besides monitoring which …object version information so you can quickly check if version you read from the …
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 14 Comments
…a while to write about using MySQL Partitioning for Performance Optimization and I just … buffer pool size. The first problem was replication lag, which are mainly due to modifying the …replication became CPU bound (single thread) instead of IO bound. You could celebrate but hey…. you need to check…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 17 Comments
… more here – ALTER TABLEs, MySQL Upgrades, Storage Engine changes etc….replication lag may be allowed to appear. 5) Yves: Yes… Replication is a risk here. The monitoring for replication of course must be in place as well as regular checks…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 94 Comments
…/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” socket=”/var/run/mysqld/mysqld.sock” replication_user=”repl” replication_passwd=”7la4epa99″ max_slave_lag…_passwd=”r00tp877″ \n op monitor interval=”20s” role=”Master” OCF_CHECK_LEVEL=”1″ \n op monitor interval=”30s” role=”Slave” OCF…-resource-stickiness=”1000″ \n last-lrm-refresh=”1328620089″ property $id=”mysql_replication” \n replication_info=”10.20.0.21|mysql-bin.000056|106″
