This post is a step-by-step guide to set up Percona XtraDB Cluster (PXC) in a virtualized test sandbox. I used Amazon EC2 micro instances, but the content here is applicable for any kind of virtualization technology (for example VirtualBox). The goal is to give step by step instructions, so the setup process is understandable and it could serve as a reference architecture.
You will need 4 virtual machines. 3 for PXC and 1 for the client, which will have HaProxy. I used CentOS 6 as the operating system, the instructions are similar for any Linux distribution.
Come join the Los Angeles MySQL Users group on August 1st for a look at MySQL 5.6 and help make some pizza disappear. The presentation will start at 7PM and all are welcome. I will be speaking earlier in the day at the LA Moodle Moot and then heading down Highway 5 the next day for the San Diego Users Group.
200 N. Sepulveda Blvd.
El Segundo, CA 90245
Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them through insertion, especially for tables much larger than memory and large uncorrelated indexes you might be looking at 10x difference or more. Yet for some reason Innodb team has chosen to use very small (just 1MB) and hard coded buffer for this operation, which means almost any such index build operation has to use excessive sort merge passes significantly slowing down index built process.
Upgrading MySQL is boring topic, upgrading MySQL is something we would rather to be done with and get benefits from new cool features or be done with bugs and limitations which haunted us for years. Yet if you’re not careful performing MySQL upgrade you can get advantage of multiple opportunities of downtime and data loss, which come as just some of the risks. There is also one special thing about upgrades – unlike many other tasks DBA has to do, major version upgrade is done only once, at least once for every environment and every major version upgrade has its own issues.
Come join the San Diego MySQL Users group on August 2nd for a look at MySQL 5.6 and help make some pizza disappear. The presentation will start at 7PM and all are welcome.
9515 Towne Center Drive
San Diego, CA 92121
I was playing with Percona Server today and found fast_index_creation does not work quite exactly like described in the manual. The point I’m looking to make though it would be very hard to catch this problem without additional
information_schema tables we added in Percona Server.