… observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down…’s binary log in general. But if it’s left on, the replication logic only replicates that “command” across the slaves, not… data. If the INFILE data file is missing from the slave boxes, then the LOAD DATA command will fail silently, allowing…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… batch of log records to the database… … InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 15906301, file name ../log/binlog.000290 … This is a slave, it has no binlog of its own. SHOW SLAVE STATUS says Master_Log_File: binlog.000062 Relay_Log…
Comment: Online MySQL Configuration Wizard from Percona
March 15, 2012 By 23 Comments
… a slave dedicated one?): “Make the server read-only” and “Log replication updates” (the second one especially if binlogging is enabled on slave). Then I don’t like the idea of putting socket and pid files in mysql data directory. My…/mysqld/. The same goes for all the log files. IMHO especially having relay logs and bin logs in the same directory, or even…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… for current binary log (especially if it is disable) and not print the position of slave thread in master logs at all. Here is some old post of mine about it: http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql… TABLES WITH READ LOCK anyway you can consider doing SHOW SLAVE STATUS/SHOW MASTER STATUS to get proper position instead of…
Comment: How Does Semisynchronous MySQL Replication Work?
March 17, 2012 By 23 Comments
… MySQL documentation says the following : “If semisynchronous replication is enabled on the master side and there is at least one semisynchronous slave… commit is done and waits until at least one semisynchronous slave acknowledges that it has received all events for the transaction…. ” .. “The slave acknowledges receipt of a transaction’s events only after the events have been written to its relay log and flushed…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
… i hear the talk about failover from intermediate slaves to master and knowing that mysql does not have a way match the transactions as ‘global transactions id’.I agree that matching logs is very… captured information is telling that B ( relay_master_log_file: test_file , exec_master_log_pos: 2399 ) was replicating from these positions…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… graphs count. You see galera faster than MySQL 5.5.21 semisync (blue line). MySQL was getting out of semisync after a… you don’t have the data in the relay log only. And don’t forgett you can write to the ‘slave‘ also 
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
… turning logs into benchmarks so you use real user input (real queries) and not “made up” queries 2) with a master, slave…. We have applied it to MS SQL Server, not to MySQL yet, but it is the same idea and only a…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 1 Comment
…the connection time or latency, not the time without binary log events. We’re actively checking the communication. How can …easy to setup with negligible overhead: mysql_slave > STOP SLAVE; mysql_slave > CHANGE MASTER TO MASTER_HEARTBEAT_PERIOD=1; mysql_slave > START SLAVE; MASTER_HEATBEAT_PERIOD is …
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… a Percona Consultant speak on Replication. “Replication is one of MySQL’s most widely-used features, and despite significant improvements over… to your MySQL database. For those who do not have a thorough understanding of the MySQL binary log format or the slave’s two… how to interpret SHOW SLAVE STATUS, how to read MySQL’s binary logs, and how to recover a replication slave from many types of…
