…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… the tool does NOT have any features to disable the binary log; my experience has been that this is a very…, so there is no code in the tool that disables binary logging at all. Are you using the 2.0 version…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated… a new node, it will connect to the first available Binaries are available from downloads area or from our repositories. For… bug tracking system. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
…’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication… probably a good idea to turn off the session’s binary log in general. But if it’s left on, the…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through speedier… more choice than ever — there are three great versions of MySQL that suit different needs and personalities, with different characteristics, and…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… to prevent problems with the replication you should change the binary log format to “row”. Depending on the statement, the behavior…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…. If your application can deal with phantom reads and your binary log is in row format, changing the ISOLATION to READ…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New…: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application… bug tracking system. Links: We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… innobackupex script but incremental backups were done by the xtrabackup binary which calculated deltas by scanning data files. Which meant those… be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the following…
Post: Announcing Percona XtraBackup 1.6.6
April 4, 2012 By 3 Comments
….6. This is a minor release and source code and binaries can be downloaded from our downloads site. Our main APT…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… once. tar4ibd functionality is replaced by functionality in the xtrabackup binary itself. The xbstream utility is added This utility has a…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
… your Perl script, and it seems it doesn’t handle binary data correctly, you need to add these lines: if (length… have (160GB , varchar columns). Also, rather then time’ing the mysql commands in the loop (second shell), I added –show-warnings… unnoticed (that’s how I discovered the mistake with the binary data). Keep posting the good stuff 
Stefan
