… having binary logs which are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log filtering… you add binary log filters; this ensures that the top-level master and its binary logs are fully intact, and then the binary log filters are executed on the intermediate server, thus resulting in less binary log data…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… 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…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…: The master has crashed before sending all writes If the binary logs of the master are no longer readable, you will probably… above. So we will suppose that we can read the binary logs of the crashed master. The first thing to do after…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…, and isn’t flexible at all. The specific problem of logging failed connection attempts has been discussed on a previous post…, which seems to be on par with having the general log enabled. The flexibility comes from the three variables that can… to this Percona Server version not being included in the binary. And here’s a few sample output lines generated by…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… by copying the dirty tablespace files while streaming the redo-logs to ensure that all transactions are also captured. The –apply… recovery and applies the redo-logs to the dirty tablespace and voila, you have a consistent binary backup at a point in time. When running Percona Server, you can utilize the –export flag during the –apply-logs…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… node is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; This could… you hit a bug. It is also possible that this binary or one of the libraries it was linked against is…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…, replication will restart at the beginning of the first available binary log, which is very likely to corrupt your data by reexecuting… restart replication, it will read events from the first available binary log file on the master, which is probably not what you…, replication will start at the beginning of the first available binary log file, with all the nasty consequences we can imagine. Even…
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…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream bug… the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… ways to find the failed transaction. You can examine the binary logs or you can also check Retrieved_Gtid_Set and Executed… slave checks that transaction 5 is already in its own binary log and that means that it has been executed. This is…
