…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 …#1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack …
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this involves…/audit.sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit… to this Percona Server version not being included in the binary. And here’s a few sample output lines generated by…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… 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… Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…: 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…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… 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…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE…
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 …you hit a bug. It is also possible that this binary or one of the libraries it was linked against is…53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave…, replication will restart at the beginning of the first available binary log, which is very likely to corrupt your data by reexecuting…, 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 for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… in Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug… contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262…
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… is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.68-14.6[/caption] Percona is glad…-14.2 which could cause a server to hang when binary log is enabled. Bug fixed #1162085. Percona Server would re-create… fixed #1032139. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
