… TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only is very short, just few seconds, yet the impact of FLUSH TABLES WITH READ LOCK can be… backing up data from the slave with –safe-slave-backup option, as preventing writes to the slave can be done by simply pausing replication.
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… even if writes only consume 10% of resources as almost only one core and only one disk will be working on slave side. Now… else. So your “read” performance will drop 4 times if write load growth by only 50%. – Delays in replication MySQL replication is fast which means… database is small and load is virtually read only. you may however want to structure replication with median servers to avoid master overload…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…replication capacity, so we can deal with replication load before slave is unable to catch up. Need to replication capacity is not only…read only…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…mysql-bin.000001′ at 2793, the last byte read from ‘./mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…applies to logical level replication. MySQL 5.1 can use row level replication which alleviates some …lot of people stop reading documentation, specify databases they want to replicate (or ignore) and …only what you need replicated and pass it to the group of slaves. If you have several group of slaves…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…read-only while others can be read-write. read-only snapshots may sound good enough as you’re only going to read data anyway, but in reality read…SLAVE START to restart replication. With slightly modified process you can clone slaves from the slaves…
Post: How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
… the read replica to stop replicating. Here’s one way to do it: WARNING! Resuming replication gracefully only works if you run RDS with MySQL…_error procedure, you can try removing the conflicting record from replication slave and replication should resume shortly. That worked for me.
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… use MyISAM for anything but read-only tables when things get big. And even if it’s read-only, there’s still another… use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave, then piping…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… makes failover process tricky. Not only Failover process for MySQL replication is tricky it can be long – consider slaves lagging and need few minutes… note semi-synchronous replication available in MySQL 5.5 does not solves these problems. It helps to ensure the slave can be cought… with “guarantees” cluster provides – such as it is safe to read and write from any node and application will work properly…
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… you’ll break replication often without knowing about it. You can kind of solve it with using read-only user for slave connection but… Manager makes sure only one of the nodes is writable at all times and other is set to –read-only, so unless you…
