… running with its binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… either output option, or between using the plugin or enabling the general log. Bear in mind these were basic tests (just a…, which seems to be on par with having the general log enabled. The flexibility comes from the three variables that can be… to this Percona Server version not being included in the binary. And here’s a few sample output lines generated by…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… this re-release only affects RPM so our dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by… the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227 and #1128848 (Laurynas…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream bug #49169…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227 and #1128848 (Laurynas…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream bug #49169… the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
…-14.2 which could cause a server to hang when binary log is enabled. Bug fixed #1162085. Percona Server would re-create the…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…failures that are caused by the log records in the transactional log being overwritten before they are …Percona Server 5.6 with the GTID mode enabled. Example of how this information can be … fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the revision…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… to go through these basics. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the cluster node acting… will not be written to the slave’s binary unless log_slave_updates is enabled, this is similar to Percona XtraDB Cluster in… if there is basic support when wsrep_certify_nonPK is enabled, you can still hit issues like when automatic creation of…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…failures that are caused by the log records in the transactional log being overwritten before they are …Percona Server 5.6 with the GTID mode enabled. Example of how this information can be … fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the revision…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… primary, which enables replication by writing a so-called “binary log” of events that modify data in the server. The binary log is a real… replay the binary log and roll forward the state of your server to a desired point in time. But enabling the binary log reduces MySQL’s performance dramatically. It is not the logging itself that’s the problem — writing the log is usually…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… binary log enabled. If you think about it, this makes sense and is correct behavior. The statements have to be serialized for the binary log; otherwise replaying the binary log can result in a different order of execution. The… no solution to this, if you need the binary log enabled. (It needs to be enabled for replication.) There are workarounds, though. You can…
