…replication in MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL…clearly an opportunity to break replication…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… in MySQL 5.0 MySQL generally supports legacy storage format for a while, even if it is not clearly visible… to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with … before upgrading and make sure to keep binary logs for some time, in case you run into …
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 10 Comments
… connected to master ‘repl@host.com:3306′,replication resumed in log ‘master-bin.003676′ at position …clearly sees the problem in this case as there are 2 servers with same server-id connected and replicating…possible reason for this error message which MySQL already does in many other cases. I…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with slow query log… -v -i -P “^(SET|use|#)” > q1.log I’m not sure if this would clear everything but in my case it did…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… your data is coming from some Apache log or similar source. Write a …replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL…clearly better for some workloads out-of-the-box than MySQL is, especially for more complex queries. Percona is not tied to MySQL…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… also for internal XA coordination between the InnoDB transaction logs and the MySQL binary logs, to ensure that they are consistent. Consistent is… isn’t that helpful in this instance — it doesn’t clear things up very well: When the variable is enabled (the… enabled on a replication master—or on any MySQL server where binary logging is in use—ensures that the binary log does not get…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…only the rows that change. Feed third party replication systems. Provide data to “external triggers” such … Binary Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log …should be clear in a moment. Lets create a table, insert some rows, add a change log, …
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…MySQL Development is done by different team working on the different components, while MySQL was not designed to be very modular with clear…replication or events. I think less than 5% are using both features. MySQL…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… hopes to clear confusions with the problem Im getting w/ our servers: Here is a snippet from our error.log: ************ 080625 23…-log‘ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Edition (GPL) 080625 23:53:28 [Note] Slave SQL thread initialized, starting replication in log…
Comment: MySQL Master-Master replication manager released
April 9, 2007 By 27 Comments
… functionality for some applications.” How ? You can implement semi-synchronous replication which is barrier based, what I’ve told but not… master and the slave. You can’t get it with MySQL replication by design because slave only fetches statement after it was… clear way. How do you guarantee it ? Any server restart will change binary log positions on the slave not to mention flush logs…
