… Available) stable release in the 2.0 series. New Features: This version of… from abstract mysql to real /usr/bin/mysql file, because rpm packages from…logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
….cnf [...] master-user=rsandbox master-password=rsandbox master-host=127.0.0.1 master-port=35301 [...] Let’s disconnect the slave: mysql… 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…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…0.7 has been published with support for …bin.000002′, position 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the logs to the backup: # innobackupex –apply-log… Slave_SQL_Running: Yes [...] Retrieved_Gtid_Set: c777888a-b6df-11e2-a604-080027635ef5:5 Executed_Gtid_Set: c777888a…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘infile.txt’ into… /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘/tmp/my-fifo’ into…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… of course manual filtering – using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege and… math of dealing with binary log positions. For example cloning Master (and dropping not replicated tables) to set up replication becomes more…
Comment: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… Peter, Regarding this statement: “…using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege and… know what that sql statement does, I’m pretty much aware that every DML I’m issuing AFTER sql_log_bin = 0 is happening at…
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: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
… when running on node4000: node5000> SET SQL_LOG_BIN=0; Query OK, 0 rows affected (0.00 sec) node5000> UPDATE test.t SET val=val+1 WHERE id=30; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0…
Comment: Hacking to make ALTER TABLE online for certain changes
November 3, 2009 By 26 Comments
@sk – no impact really. Well all SQL statements will be executed if you don’t SET SQL_LOG_BIN=0 but physical rename of .frm files won’t be replicated of course, so I’d recommend doing that separately on master and slaves.
Comment: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…_id; And then delete the signal rows with the following: set sql_log_bin=0; delete from flexviews.mview_signal; Don’t do the following…
