Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5… 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: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release…. XtraDB changed page tracking used to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive… #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation…
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… for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures that…/audit.sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… 5.6.11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is… from latest Percona Server 5.5 release (currently Percona Server 5.5.31-30.3). New Features: Percona Server has implemented Log Archiving for XtraDB…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the… master has crashed before sending all writes If the binary logs of the master are no longer readable, you will probably…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make… replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of… and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… executed on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the… always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… the dirty tablespace files while streaming the redo-logs to ensure that all transactions are also captured. The… sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: … was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use …
