… and restart it: slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: mysql-bin.000006 Read_Master_Log_Pos: 98 Relay_…logged inside the transaction. And when it comes to a replication slave, what’s logged — not what executes on the master — is…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
…: split read and writes run data mining or reporting processes on them disaster recovery Is important to mention that a replication server… without a WHERE clause will be replicated nearly instantly to all slave servers and just having a slave is not going to be… using delayed replication slave. Is useful not only for disaster recovery but also to test how our application deal with lagged replication. With…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… statement based replication slave can get out of sync with the master fairly easily, especially if data is changed on the slave. It… row-based logs only contain information about changed rows, a replication slave which does not find a row referenced in a row… during a transaction. You should always set read_only = true on your MySQL slaves to prevent accidental changes in data from happening…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… in master log files up to which replication was done: InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position… way this functionality was usable is cloning Slave->Slave by use of LVM without pausing replication (so you can get consistent master position… or to clone slave from the master) and can’t do traditional and recommended way with FLUSH TABLES WITH READ LOCK for…
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… the MySQL binary log format or the slave’s two-phase replication architecture, safely restoring replication while maintaining data integrity can be a… how to interpret SHOW SLAVE STATUS, how to read MySQL’s binary logs, and how to recover a replication slave from many types of real-world failures.” Not interested in Replication…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… is not easy to find which. I’m surprised to read enabling binary log drops update performance. I guess Jeremy speaks… only Master overhead of Replication. Slave is where you can expect more problems, especially on high end systems. Slave serializes all operations to…. You still will practically have only One CPU to handle replication load. Furthermore if you have multiple disks they will not…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
…:57) Replication Is a slave, has 2 slaves connected, is read_only Filters Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode…:15) Replication Is a slave, has 0 slaves connected, is read_only Filters Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… replication. All writes are going to the master while reads are spread between the master and the slave. Upon failure of the master, replication is stopped on the slave and all traffic is redirected to the slave which now handles reads…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…none)) > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] Last_Errno: 1594 Last_Error: Relay log read…slaves, the corruption will be obvious as replication will stop with an error: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: No Slave…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… you can have assurance that reads from a slave node will return results as current as reads from the original node where the… tables from replication in master side vs slave side? A: You can configure filtering either on the master or the slave. Master-side…. As these timestamp values replicate to a slave, you can compare the latest value inserted to the slave‘s system clock and get…
