… 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… only if all servers have gtid_mode set to ON. Could it be interesting to run file-based replication when gtid_mode…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… virtual machines. First is the disk IO performance hit that comes with DRBD. When you run a virtual machine, in most cases… to slave, and if so, how? A: Yes. There are a few of ways to do it. One way is to set up replication filters on the slave, as…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
… replication status: slave1 > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:5 Executed_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:1-5 We can see that the slave…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… | | +—————+——-+ slave1 > set global GTID_PURGED=”9a511b7b-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…> 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 to…
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…_Log_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_Table…). When you’re using CHANGE MASTER TO to set start position for the slave you’re specifying position for SQL thread and…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… turn on replication checksums on the slave: slave1 [localhost] {msandbox} ((none)) > set global slave_sql_verify_checksum=ON; Query … error message: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] Last_Errno: 1594 Last_Error: Relay…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_…yes_txblogpercona.commanual rpl_semi_sync_slave_enabledblogpercona.commanual Rpl_semi_sync_slave_statusblogpercona.commanual rpl_semi_sync_slave…commanual show_slave_auth_infoblogpercona.commanual skip_character_set_…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…yes this could cause problems with replication lag (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting…IO subsystem Could there be any side load on IO subsystem ? This can take many forms. It can be you running…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…new parameter –log-slow-slave-statements. THE DETAILED INFORMATION…Tmp_table: Yes Disk_tmp_table: No # Filesort: Yes Disk_filesort:…IO_r_wait: 0.382176 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.067538 # InnoDB_pages_distinct: 20 SET… the patch was tested and run successfully under stress …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…on the types of queries your application runs. Q: Hello, was there any …Yes, if you layer an ORM on top of the DAL, this makes it inconvenient to choose the degree of slave…queries (select etc.)? A: You can set up a pair of MySQL … up and the IO thread is waiting. A: Yes, the “seconds behind master”…
