Large Scale MySQL Migration to PostgreSQL

Dimitri Fontaine (2ndQuadrant)
Data
Location: Portland 256
Average rating: **...
(2.40, 5 ratings)

This talk will share hindsights about the why and the how of that migration, what problems couldn’t be solved without moving away and how the solution now looks. The tools used for migrating away the data, the methods and will detail the new architecture. And the new home, in the cloud!

On the technical side of things, we will be talking about MySQL, mysqltocsv, pgloader, pljava, Google Protocol Buffers, pgbouncer, plproxy, PostgreSQL, pghashlib, walmgr, streaming replication. And Amazon hosting facilities too (EBS for starters).

Dimitri Fontaine

2ndQuadrant

Dimitri Fontaine is a PostgreSQL Major Contributor (design, review, Extensions, Event Triggers, Bi Directional Replication). He contributes to Skytools (PGQ, Londiste) and develops pgloader, prefix and other software. Dimitri works at 2ndQuadrant.

Sponsors

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at (707) 827-7065 or scordesse@oreilly.com.

Contact Us

View a complete list of OSCON contacts