Developing Replication Plugins for Drizzle

Average rating: ****.
(4.00, 1 rating)

The Drizzle Project is a fork of the MySQL 6.0 server and aimed at serving large cloud computing environments. One of the many goals of Drizzle is to enable a large plugin ecosystem by improving, simplifying, and modernizing the application programming interfaces between the kernel and the modules providing services for Drizzle.

Drizzle’s replication system is entirely new and different from MySQL. It uses Google Protobuffer messaging in its application programming interface to communicate changes to the state of one server to another server. Plugins are easy to implement which enable a developer to entirely customize their replication system. This tutorial describes the APIs used in Drizzle’s replication system in depth and walks through the construction of several example plugins demonstrating the flexibility and power of the replication API.

Topics covered include:

  • Overview of Google Protobuffers message API
  • Overview of the flow of messages through Drizzle’s replication system
  • Understanding the Transaction and Statement messages
  • Understanding the TransactionReplicator and TransactionApplier APIs
  • Overview of Drizzle’s Transaction Log module, which demonstrates an example TransactionApplier plugin
  • Walkthrough of the FilteredReplicator plugin
  • Walkthrough of the MemcachedApplier plugin
Photo of Jay Pipes

Jay Pipes

Rackspace Cloud

Jay is a Drizzle code monkey.

Padraig O'Sullivan

Akiban Technologies Inc.

Padraig O’Sullivan is a software engineer at Akiban Technologies Inc. He is working on the core Akiban Orthogonal Architecture as well as contributing to the open source community in projects such as Drizzle. He has an M.S. in Computer Engineering from the University of Maryland. Originally from Killarney in Ireland, he now lives and works in Boston.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Newsletter

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

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.