… those graphs: You can see the CPU usage and the replication lag… once again cacti is very helpful ! How to fix then….1/en/replication-options-slave.html#option_mysqld_replicate-same-server-id [3] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… any technical considerations or best practice tips to have a replicated slave in the cloud, for example on Amazon AWS? Hardware resources… may cause replication lag and try to make them as efficient as possible have a look at indexes: the workload on slaves is… nature. Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made are valid…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… to keep Slave load under control and avoid load spikes as load spikes will frequently cause replication lag spikes as well. Locks – MySQL Replication SQL… 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: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… need to setup MySQL replication between a master and one or more slaves. Upon failure of the master, one of the slaves is manually…, is the asynchronous design of MySQL replication which does not allow the master to be sure the slave has been updated before returning… replication on one of the MySQL servers lags behind too much, its read VIP will be moved to another server. As a conclusion, replication…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…replication slave will be reading later. Whenever a replication slave…Replication lag Now I want to briefly touch the subject of replication lag in this context. When you are dealing with replication lag…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… lagging, broken, stopped etc which makes failover process tricky. Not only Failover process for MySQL replication is tricky it can be long – consider slaves lagging… note semi-synchronous replication available in MySQL 5.5 does not solves these problems. It helps to ensure the slave can be cought…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
… with slave lag is that you often can’t see it coming. Especially if the slave‘s load is pretty uniform, a slave that…: One: watch for spikes of lag. If you have Cacti (and these Cacti templates for MySQL) you can see this in the… two replication threads on the slave) to see how much of the time the slave thread was actively processing statements. If the slave threads…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… bulk query on the master, even on completely unrelated table, replication lag may increase dramatically. Besides monitoring which Brian mentioned three other…’re accessing to be cached in memory by MySQL cache or OS cache. As slaves replicate the same data and often queried in…. So in which case I would go using simple master slave replication ? – Small database size. Small meaning working set fits in memory…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
… master and slave can be different in a lot of circumstances. One more thing to consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the slave and your replication is well loaded, this means at some point in time your replication lag was at least…
