…1, 2013 , 9am – 5pm In August we have: Moving to MySQL 5.6 – Miami, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5…for use when ordering, register early and save even more as the 10% discount can be…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… the available instructions. The only extra step I had to take was to extract the offsets for the …was using for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL … that would generate a write to the general log will be sent to the plugin, and you can control …
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team, will talk about MHA for MySQL High Availability in the Cloud… finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The daylong event will be held at Portland…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5… #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online documentation. Bugs can be reported on the launchpad…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… in each flight (Q1.1 for example) is tested with…for the cold test. All tests were done with no concurrency. The hardware for this test was provided by Adotomi. I will be…when the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL version used: 5…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you can choose … when a restore is needed. As the application evolves, additional requirements will appear like hot backups, online schema changes, replication based high availability…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each, so your bandwidth requirements will be… add more nodes when we are using …
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… cluster. In this post I will explain you how to fix …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql… as expected and you should be ready for the next distro upgrade! INFO…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
…. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a data type of VARCHAR or one of the TEXT types, CONVERT TO CHARACTER SET will change…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
You can replicate from MySQL 5.6 to MariaDB 10.0 or vice versa. You just won’t be able to use the… pick the correct binlog position when switching to a new master. Old-style replication will work. That being said, I agree that compatibility… MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction ID, I would very much like to…
