Oracle VM Site Review - Oracle VM Health Check
view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

Percona XtraDB Cluster reference architecture with HaProxy

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.

Techweek Chicago & Lonestar PHP

If you are attending Chicago Tech Week Chicago Tech Weekthis weekend, be sure to drop by the MySQL Hands On Lab Saturday (3:00pm – 4:45pm @ 4 – 7 A/B (222 Merchandise Mart Plaza, Chicago, IL)) as I have some promotional items that I need to give away.

Clarification on MySQL security vulnerability

Contrary to initial reports here and here, further investigation has revealed that under some specific and limited circumstances, Percona Server and Percona XtraDB Cluster binaries, similar to other MySQL variants, are susceptible to the security vulnerability in MySQL/M

Los Angeles MySQL Users Group

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. Los Angeles Users Group

200 N. Sepulveda Blvd.
Suite 400
El Segundo, CA 90245

Building Indexes by Sorting In Innodb (AKA Fast Index Creation)

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: Best Practices webinar, June 27th

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.

San Diego Users Group

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. San Diego USers Group will meet August 2nd

Oracle Office
9515 Towne Center Drive
San Diego, CA 92121

On stored routines and dynamic statements

I very much enjoyed reading Overloading Procedures by Michael McLaughlin: good stuff!

Using innodb_sys_tables and innodb_sys_indexes

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.

view counter