MySQL to Drizzle, stress free migration

Andrew Hutchings (Hewlett-Packard)
Drizzle
Location: Ballroom A
Average rating: ****.
(4.00, 2 ratings)

One of Drizzle’s greatest strengths is that it is not afraid to deviate from its MySQL origins, but for people who already use MySQL and wish to use Drizzle this can be quite a large weakness.

Just trying to take a mysqldump and insert it into Drizzle will very likely fail. The good news is the migration isn’t hard and there are tools to help you, but there are things to watch out for. So this talk will start with taking about why we made certain incompatible decisions in Drizzle, such as the data types and character set changes. Then it will cover how to migrate your schemas and data from MySQL to Drizzle both using drizzledump and manually editing them. After this there are some tweaks that may need to be made to the SQL queries, such as some functions which do not exist in Drizzle. Finally there is the application’s connection to the Drizzle server. The good news here is that Drizzle talks the MySQL API on port 3306 by default, so there are not a lot of changes needed at this layer.

During this talk there will be examples of real world applications, such as WordPress, that can be converted to Drizzle and how it can be done.

Photo of Andrew Hutchings

Andrew Hutchings

Hewlett-Packard

Andrew Hutchings is a Software Developer on the Drizzle project at Rackspace and co-author of the book MySQL 5.1 Plugins Development. Before joining Rackspace he was a Senior MySQL Support Engineer for Oracle Corporation specialising in MySQL Cluster and C/C++ APIs.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts