…’s the instance type with highest memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and used the version available…
Post: High Availability Deep Dive tutorial at PLMCE
April 6, 2012 By Leave a Comment
… of Florian’s post) If you are interested by High availability solution with MySQL, Florian Haas from and myself myself will be co… will find useful. As our tutorial is going to be highly interactive, every attendee will have the opportunity to follow along… as we walk you through several deployment scenarios for Pacemaker MySQL high availability. We’re coming with pre-installed virtual machine images for…
Post: PLMCE High Availability Deep Dive slides and Document
April 19, 2012 By Leave a Comment
The slides and accompanying document of the High availability deep dive tutorial have all been uploaded and can be … works somewhat OK with pptx. Also, the VMs will stay available from a at least few months from here: Virtualbox: http…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… availability of the GA release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL… Previous posts on this topic: Percona XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… new High Performance MySQL, 3rd Edition (worth $55 each), the recently released update to the popular second edition! This year’s MySQL Conference… retweet us when we mention this contest Tweet “My favorite #MySQL conference session” with a link to your favorite “Like” your… a free copy of the new book “High Performance MySQL, 3rd Edition” which will be available for pickup at the conference or mailed…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication. Corosync allows any number of servers…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s… MRR optimization available in MySQL 5.6 here: http://dev.mysql.com/doc/refman/5.6/en/mrr-optimization.html and as available in… interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb_rows_read, which is completely…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… related optimizations introduced in the optimizer. These optimizations are available in both MySQL 5.6 and MariaDB 5.5, and MariaDB 5…. BKA is available in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here… known as probe step. This join algorithm works best for highly selective queries, and obviously when the first operand used in…
Post: Percona XtraBackup 1.9.2 released (Beta)
March 29, 2012 By 2 Comments
… XtraBackup 1.9.2 on 28th March 2012. Downloads are available from our download site here. This is a late BETA… is not inteded for production. If you want a high quality, Generally Available release, you should use the current Stable version – currently… pre-release versions of PerconaXtraBackup 2.0 and the Generally Available final release. If you wish to run pre-release Percona…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… learning more is the MySQL versus MariaDB wiki page. Note that a lot of these features are also available either in Percona Server or in the upcoming MySQL 5.6 in the same or…
