… also for internal XA coordination between the InnoDB transaction logs and the MySQL binary logs, to ensure that they are consistent. Consistent is an… isn’t that helpful in this instance — it doesn’t clear things up very well: When the variable is enabled (the… 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: Upgrading MySQL
January 5, 2010 By 23 Comments
… MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL… another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even if it is not clearly visible. mysqlcheck… the final backup before upgrading and make sure to keep binary logs for some time, in case you run into some serious…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… check it based on slow query log, happily the server was running MySQL with slow query log with microsecond resolution so I could… kinds of MySQL Logs. Too bad MySQL Binary log is the only one which it does not support natively. Happily it supports “raw” query log file… -v -i -P “^(SET|use|#)” > q1.log I’m not sure if this would clear everything but in my case it did…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… file. This gives us compression speed of about 21MB/sec – clearly much less than even single SATA hard drive can read… in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events, which could… which makes it easy drop in replacement. I got LZOP binary which was built against LZO 1.0, more resent version…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…. Binary log based CDC The CDC tool included with Flexviews is called FlexCDC. It seemed like an appropriate name. The Binary Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log to determine what rows… confusing it should be clear in a moment. Lets create a table, insert some rows, add a change log, delete rows and…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…see what’s in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql-bin.000011 Pos: … the statements went into the binlog individually, there’s clearly an opportunity to break replication here. It looks like …
Comment: MySQL Master-Master replication manager released
April 9, 2007 By 27 Comments
… master and the slave. You can’t get it with MySQL replication by design because slave only fetches statement after it… mean this by “all they use same binary log offsets”. The offsets in the slave binary log can be different if if you have… more clear way. How do you guarantee it ? Any server restart will change binary log positions on the slave not to mention flush logs…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30…, I explain the meaning of the output, so it’s clear what I’m showing them. Then, I go through it… a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log gives us…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) … is the data so the next step is clear, extract the rows from it. To accomplish this … from an ibd file if you have a binary backup. Just use constraint_parser without the -D option…
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…MySQL Enterprise it is customers who got the bleeding edge code and for community the binary…
