…’s 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 … replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate … the cost of having binary logs which are no longer complete or useful for point-in-time …
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 …, no performance penalty. You can easily run a server with hundreds of snapshots. With LVM, your IO … on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] This is not…: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: No [...] Connection settings are…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL…tables and slow IO then …mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql… innobackupex would still run with FLUSH…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… which GTID is the master and set it on the slave. MySQL keeps two global variables with GTID numbers on it: gtid… 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
… the master’s or slave‘s MySQL code. If you want to check the master’s binary log or slave‘s relay log… 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: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…_File: mysql_sandbox20551-relay-bin.000028 Relay_Log_Pos: 235 Relay_Master_Log_File: mysql-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
…:31 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…
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…-bin.003814 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_… Master_SSL_Allowed: No Master_SSL_CA…
