News for hackers. Stuff that matters.

A comment on Why Uber Engineering Switched from Postgres to MySQL. Parent comment

Re:Why Uber Engineering Switched from Postgres to MySQL by chucky_z on Tuesday July 26, 2016 @02:37PM (#12167826)
online schema change is absolutely riddled with crippling bugs if you use foreign keys. Just a heads up, we've had to basically take everything it does and make an in-house version. The idea and execution are great, when it actually works.
[ Parent | on HN ]
Re:Why Uber Engineering Switched from Postgres to MySQL by barrkel on Tuesday July 26, 2016 @05:50PM (#12168978)
Foreign keys are a major problem in MySQL if you do lots of writes, especially bulk writes. As is auto-increment (table-lock for load data infile, yay!).

We allocate our own IDs, and disable foreign keys for bulk loading.

[ Parent | on HN ]