… be making MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert binary log events, as… multiple instances of different MySQL versions on the same box typically means you will install them from binary distribution instead of packages… database binary incompatible with MySQL. Our focus on compatibility is indeed so high there are number of great features which are disabled by…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… on Master-Master setup do not forget to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE query. Replication… being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow… table as it would be in the production over time: mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name… available in MySQL 5.5 (different version is added back in MySQL 5.6) so I tried that as well as disabling read…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… VALUES(YEAR(CURDATE())); END;// mysql> CALL this_pyear(); Binary Log: #111213 23:33:41 server id 1 end_log_pos 2055 Query thread_id… alter every event adding DISABLE ON SLAVE. ALTER EVENT even_name DISABLE ON SLAVE. LOCAL VARIABLES Local Variables are logged as an extra…: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into t VALUES(@this_year) Binary Log: #111213 23:58:11 server id 1 end_log…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… binary log is also disabled.) The prepare-then-commit process does two important things: it ensures that the binary log and the engine’s transaction log… a replication master—or on any MySQL server where binary logging is in use—ensures that the binary log does not get out of sync…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… by the slave_sql_verify_checksum variable. Let’s first disable them: slave1 [localhost] {msandbox} ((none)) > set global slave_sql_verify…’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be… when reading data from binary log: ‘event read from binlog did not pass crc check; the first event ‘mysql-bin.000001′ at 2793…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to… serialization. MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL‘s…, then InnoDB’s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is often not…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… also result to compare binary logs enabled and disabled. All results are for binaries with group commit fix. Results with disabled write cache thread trx….85 2004.13 1669.11 As you can see, enabling binary logs with system without writeback cache impacts performance significantly. And the…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… interleave such funny way Group commit is broken in MySQL 5.0 if binary loging is enabled (as it enables XA) Certain…, together with binary log. XA is enabled if binary log is enabled this is why this issue is trigered by enabled binary log. if binary log is disabled, so… with large transactions. So how you can solve the problem ? Disable binary log. This could be option for slaves for example which do…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify…. check the mmm mode and put it to passive to disable any automatic failover during the process because high availability tools… in the binary-log of mysql 4 and the master position is increased… Step 6: the slave position on the active master (mysql 1…
