Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Migrating to PostgreSQL, the new story

Migrating to PostgreSQL, the new story

 4 October 12:20 PM - 1:10 PM @ Winterthur
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
PostgreSQL
MySQL
Topics:
MySQL
Devops
Tools and Techniques

Description

Database migration projects are always articulated around the same steps, methodology and costs. At least when properly done. pgloader is meant to be disruptive in that market and offers to completely automate the “boring” parts. In this talk, we will explain what pgloader is and how it can change the database migration market. We will see in details the difficulties one has to solve when migrating from MySQL to PostgreSQL and how pgloader knows or helps to deal with them, from zero dates (the year zero does not actually exists in our calendar) to the lack of booleans. pgloader is an Open Source project released under The PostgreSQL License and free to use by anyone.

Speakers

Dimitri Fontaine's picture

Dimitri Fontaine

Software Architect, Leboncoin

Biography:

Dimitri is a PostgreSQL Major Contributor (Extensions, Event Triggers, Bi Directional Replication). Dimitri also develops pgloader and other PostgreSQL related software, most of them are available at https://github.com/dimitri.

Share this talk


Slides