2 ms·
I didn't think replication was one of the issues Uber noted, but then I looked back at the blog posts: https://eng.uber.com/mysql-migration/ https://eng.uber.c
by djsumdog 10y ago
I didn't think replication was one of the issues Uber noted, but then I looked back at the blog posts:
https://eng.uber.com/mysql-migration/ https://eng.uber.com/mysql-migration/
..and yep, it's listed.
In my own experience, I'd still take PostgreSQL over MySQL. MySQL doesn't allow for DDL modifications within a transaction, which makes database migration with tools like Flyway a little less resilient. On the other hand, you can use one connection for multiple databases with MySQL, MSSQL and others, which you can't with Postgres.
I mean really, they all have trade-offs. It really just depends on your specific use case.