PGCon2012 - Final Release
PGCon 2012
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Dimitri Fontaine |
| Schedule | |
|---|---|
| Day | Talks - 1 - Thursday - 2012-05-17 |
| Room | MRT 218 |
| Start time | 13:00 |
| Duration | 01:00 |
| Info | |
| ID | 431 |
| Track | Case Studies |
| Language used for presentation | English |
Large Scale MySQL Migration
to PostgreSQL!
Once a Top-10 internet audience site. 32 million users. Billions of photos and comments, more than 6TB of them. Migrating away from MySQL to PostgreSQL!
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).