… at master position mysql-bin.000001/233713063 slave1 [localhost] {msandbox} ((none)) > show slave status\G *************************** 1. row *************************** [...] Slave_IO_Running: Yes Slave_SQL_Running: No… replication slave. Is useful not only for disaster recovery but also to test how our application deal with lagged replication. With MySQL 5…
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 contain stale data. It is… take time to replicate to the slave replication lag can be significant. Also even very small lag can cause the problems – for example… idea to exclude slaves from the reads if lag is high or adjust behavior to make sure you only read slaves if you…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… to setup MySQL replication between a master and one or more slaves. Upon failure of the master, one of the slaves is manually… MySQL servers configured in a Master to Master topology. Additional slaves can also be added. A MMM agent runs on all the MySQL… read operations are sent. If replication on one of the MySQL servers lags behind too much, its read VIP will be moved…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… tricky. Not only Failover process for MySQL replication is tricky it can be long – consider slaves lagging and need few minutes to catch…-synchronous replication available in MySQL 5.5 does not solves these problems. It helps to ensure the slave can be cought up… failover process is still complicated and you still can have slaves lagging as semi synchronous replication does not wait for execution only…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option…Slave_open_temp_tablesblogpercona.commanual Slave_received_heartbeatsblogpercona.commanual Slave_retried_transactionsblogpercona.commanual Slave_runningblogpercona.commanual slave_skip_errorsblogpercona.commanual slave_transaction_retriesblogpercona.commanual slave…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3… application that use MySQL versions prior to 5.5: I remember a customer case where there is a reporting slave that daily… would cause the slave to lag for hours waiting for the transaction to be completed, as you know that the slave is single…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… technical considerations or best practice tips to have a replicated slave in the cloud, for example on Amazon AWS? Hardware resources… 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: Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 7 Comments
… fire up MySQL. This works wonderfully unless EBS is the component experiencing the issue. In this case, having a hot slave in… be to use native replication from a master to a slave across regions. This will allow you to keep a relatively… resides. Being asynchronous, there is always a potential for some slave lag, but 1-2 seconds of lost transactions (which may or…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… well. This especially applies to reads issued to Slaves – because these are potentially lagging we can’t expect to get absolutely up… make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…-query-digest now handles this correctly. Fixed bug 1015590: pt-mysql-summary doesn’t handle renamed variables in Percona Server 5…, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very high lag) with slaves running in different time zones. Now pt-heartbeat uses UTC regardless of the server or MySQL time zone…
