…: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL…_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…-bin.000002′, position 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the logs to the backup: # innobackupex –apply-log… status: slave1 > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the… dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied… when copying logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…sql_log_binblogpercona.commanual sql_log_offblogpercona.commanual sql_log_updateblogpercona.commanual sql_low_priority_updatesblogpercona.commanual sql_max_join_sizeblogpercona.commanual sql_modeblogpercona.commanual sql_notesblogpercona.commanual sql…
Comment: Managing Slave Lag with MySQL Replication
December 16, 2010 By 15 Comments
IYTM SQL_LOG_BIN, not SQL_BIN_LOG: http://dev.mysql.com/doc/refman/5.1/en/set-sql-log-bin.html
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘infile… ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘/tmp… the same guess independently.) Unfortunately I didn’t think to log the “cool-down period” after the load ended. It would…
Comment: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…, Regarding this statement: “…using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege… know what that sql statement does, I’m pretty much aware that every DML I’m issuing AFTER sql_log_bin = 0 is happening…
Comment: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
If you’re just doing an ALTER, a simple way to do it is run: SET SQL_LOG_BIN=0; ALTER TABLE … SET SQL_LOG_BIN=1; First on one server then on the other, switching masters each time.
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… binary log – even for backup recovery, for example dealing with temporary tables (unless they are used to populate normal tables using SQL… course manual filtering – using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege… advanced cases allowing replication to control what will be logged to binary log and so replicated. On the Slave you have more…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… standby MySQL server or at least synchronously replicated master binary logs. If you can’t loose any single transaction you’ve… the same point in time and load data locally with SQL_LOG_BIN=0 set for session. If the large portion of data… shortcut) – for example you may have master or relay binary log corruption. Master or Slave running out of space, Slave crashing…
