… One thing that worths to mention is that if you want GTID support log_slave_updates will need to be enabled in slave server and… using GTID. How to set up a new slave The first thing that we need to know is that now Binary Logs and Position are not needed anymore with GTID enabled. Instead we need to know in…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
… offender at once. In many cases however log_slave_updates is enabled which makes slave to write all updates to binary logs – the ones executed directly on the host as well as coming through replication thread. There is however a way to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… no updates to our msl patch, however recently I managed some time to …you can learn how to run configure command, which needs to be done prior to compiling the…to the database configuration, specifically you need to enable slow logging (see Configuration section for details). Then rename the binary…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… I enable replication – connect the slave to this box the throughput on the Master drops to about 2800 updates sec…. which is very close to the magic number how many… moved the Binary logs to the local storage I got very similar performance but there have been no degradation when replication is enabled. I…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…to get you an idea bout number. How to spot you’re affected This one is interesting. If you have update…Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
…binary log filenames and byte offsets. We had to look in A’s binary logs, find some distinctive pattern of updates, and look in C’s binary logs to…to find the right location. That saves me a huge amount of time in emergency situations. To enable… look in the documentation to see how to do it yourself…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…to update the snapshot to reflect the changes that have happened in the database, instead of replaying binary logs …posts. Enable the view to use it The SQL_API call flexviews.enable() is used to actually … how you can combine both types of views together. The complete method examples show how to …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… with an overview of how to install and run FlexCDC,…to set up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to…binary logging not being enabled) it will exit with an error. It will exit with a message “setup completed” otherwise. Verify installation The binary log…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to… with slaves or if you want to backup one master, you need log_slave_updates[3] to be enabled. This is for example the case…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… to give it real stress tests to see how well it performs 
One more thing to keep…to trigger relaxed locks. You have to set innodb_locks_unsafe_for_binlog=1 as well. This is done so enabling binary log…undo log entries 1 MySQL thread id 1794760, query id 6994946 localhost root Updating update sample…
