… stop slave #2, change configuration and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the IO thread… time, replication on slave #1 will stop: 2013-05-17 13:32:08 2563 [ERROR] Slave I/O: The slave IO thread stops because…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…. First is the disk IO performance hit that comes with DRBD. When you run a virtual machine, in … the cost of having binary logs which are no longer complete or useful for point-in-time recovery…being sent down to the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… raid controllers and 192GB of RAM. These servers will run a few slave instances each of production database servers and will perform… snapshots are free, no performance penalty. You can easily run a server with hundreds of snapshots. With LVM, your IO performance drops to 33% after the first snapshot so keeping a large number of snapshots running is simply not…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] This is not expected: instead of removing all settings…-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] Connection settings are automatically restored, which makes disconnecting the…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…be used to create/restore a slave can be found in this blogpost….there are thousands of tables and slow IO then XtraBackup can spend a … file, because rpm packages from Oracle no longer satisfied mysql dependency which … Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… get: Slave_IO_Running: No Slave_SQL_Running: Yes Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘The slave is connecting…-11e2-9a24-08002762b8af:1-14″; slave1> start slave io_thread; slave1> show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Now, if you don’t get…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… on 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_SQL_Running: Yes [...] Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… Slave to make another one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave_IO…_Pos: 744615788 Relay_Master_Log_File: db01-bin.003814 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do… Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… the slave will have problems trying to replay any further statements that refer to these tables. Thus, I claimed, there’s no…-bin.000006 Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave until master_log_file=’mysql-bin.000007′, master_log_pos=207; slave1 > show slave status\G…
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
… slave running 672 seconds behind 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 [...] With “–delay=10m” I’m asking the tool to lag the slave 10 minutes…
