… 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 has not started: 2013-05-17…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… is the disk IO performance hit that comes with DRBD. When you run a virtual machine,…down to the lower-level slaves. You can also use the slave_compressed_protocol option in …starting to swap, that might indicate that something is up. FWIW, solutions like MHA and PRM simply attempt to connect and run…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… and 192GB of RAM. These servers will run a few slave instances each of production database servers and …. You can easily run a server with hundreds of snapshots. With LVM, your IO performance drops to 33%… with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… run START SLAVE (or if it’s done automatically, for instance when restarting the server without the skip-slave-start option), replication may start … Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] Connection settings are automatically restored, which makes …
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…remember to change the permissions to mysql:mysql. 4- Start the new slave from that GTID position: slave1 > SET GLOBAL gtid_…= 1; 5- Check the replication status: slave1 > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df-11e2-a604-…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool … 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 lot …. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool … 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 lot …. 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
…-7059-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…> reset master; slave1> source test.sql; slave1> start slave; slave1> show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Conclusion With the new GTID we need…
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… you’re using CHANGE MASTER TO to set start position for the slave you’re specifying position for SQL thread and so…
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…
