… to display information) Exec_Master_Log_Pos – which position from master binary log is being executed by SQL thread. Replication lag Now I want to briefly touch the subject of replication lag… very rare, one thing you may want to try to get that fixed is enabling slave compressed protocol. Otherwise, if you…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 11 Comments
…, log ‘master-bin.003676′ position 444292333 080603 20:53:10 [Note] Slave: connected to master ‘repl@host.com:3306′,replication resumed in log ‘master-bin… to master ‘repl@host.com:3306′,replication resumed in log ‘master-bin.003676′ at position 444298239 After setting up new slave Server I’m getting…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… my master-and-two-slaves replication sandbox, flushed all the logs, and set out to get to…’s look at the binary logs: master > show master status; +——————+———-+————–+——————+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… visit the webinar registration page and get access to the recording and slides. Q…the master. It’s not necessary to check the “seconds behind master” or the binlog execution position…replication in master side vs slave side? A: You can configure filtering either on the master or the slave. Master…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…master to master_host=”master“, master_user=”user”, master_password=”password”, master_log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to restart replication…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… used in DML statements. A statement based replication slave can get out of sync with the master fairly easily, especially if data is… row-based logs only contain information about changed rows, a replication slave which does not find a row referenced in a…. Column names are not included in the binary log, only positions. mysqlbinlog mysql_sandbox25162-relay-bin.000005 –base64-output=decode-rows…
Post: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
…master position mysql-bin.000001/83915317 2012-09-10T12:41:31 Reconnected to slave 2012-09-10T12:41:31 slave stopped at master position…mysql.com/doc/refman/5.6/en/replication-delayed.html CHANGE MASTER TO MASTER_DELAY = N; That command will do the…as GA pt-slave-delay can help us to get the same …
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
…replication state are not synchronized. If we speak about backup and you can execute SHOW SLAVE STATUS command you can get… is that files with replication state (relay-log.info, master.info) are not … repoint your slave to correct position by executing CHANGE MASTER command. Currently patch …
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…Master-Master replication (often in active-passive mode) is popular pattern used… role from the server if it gets too delayed with replication (or if replication breaks) so you do not … be sure about data consistency because replication may be restarted with wrong position. Sometimes this shows up as …
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… print wrong position for current binary log (especially if it is disable) and not print the position of slave thread in master logs….mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server. Also… LOCK anyway you can consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of relying on that info.
