…, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create… master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows… by inspecting the output of SHOW SLAVE STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…; # For s0 s0> change master to master_host=’127.0.0.1′,master_user=’rsandbox’,master_password=’rsandbox’,master_port=10001,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master… s1 as the new master. We need to know the coordinates of the last event executed: s1> show slave status\G [...] Executed_Gtid…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…topology. On the top-level master, you leave all filters disabled; on the relay master you add binary log filters… there are plenty of other MySQL and OS-level status variables that you might want to keep an … of long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger a… if the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… have been made FATAL. Bug fixed #1116177. innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger a… if the server being backed up was standalone server (neither master nor slave in replication) and binlog information wasn’t available…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry: 60 Master_Log…> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 18675 Connect_Retry: 60 Master_Log…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… receive queue (visible via the wsrep_local_recv_queue global status variable). Donor/Desynced nodes do not apply flow control, though… as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options… of time (out of 1.0) since the last SHOW GLOBAL STATUS that flow control is effect, regardless of which node caused…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…- Take a backup from any server on the replication environment, master or slave: # innobackupex /destination/ In the destination folder there will… > CHANGE MASTER TO MASTER_HOST=”10.0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… for download from our repositories. Benchmark showing the impact of memory allocators on …1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang…execution loop, which does not honor wsrep status codes correctly. Bug fixed #1144911 (Seppo Jaakola…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… position SHOW MASTER STATUS – this shows position as master writes its own binary and is helpful when you for example take backup on the Master to… help SHOW MASTER STATUS has Master_Log_File value and CHANGE MASTER TO accepts Master_Log_File parameter, while you actually want to use Relay_Master_Log…
