News for hackers. Stuff that matters.

A comment on How Lanyrd moved from AWS to SoftLayer and MySQL to PostgreSQL with no downtime.

Re:How Lanyrd moved from AWS to SoftLayer and MySQL to Postg... by nigma on Tuesday November 13, 2012 @12:02PM (#4779008)
Have you considered using PostgreSQL foreign data wrapper (mysql_fdw) to pull data directly out of MySQL instead of the dump/load process?

It would be great to know more about your new setup, i.e. do you use streaming replication and some resource manager like Pacemaker?

[ Parent | on HN ]
Re:How Lanyrd moved from AWS to SoftLayer and MySQL to Postg... by simonw on Tuesday November 13, 2012 @12:32PM (#4779234)
No, we didn't look at mysql_fdw. We're using standard PostgreSQL 9 streaming replication.
[ Parent | on HN ]