Re:Zero-downtime Postgres migrations – the hard parts
by Thaxll on Wednesday May 27, 2015 @04:48PM
(#9614227)
For those using MySQL: https://www.percona.com/doc/percona-toolkit/2.2/pt-online-sc...
[ Parent
| on HN ]
Re:Zero-downtime Postgres migrations – the hard parts
by brlewis on Wednesday May 27, 2015 @10:37PM
(#9615783)
"The technique of atomically renaming the original and new tables does not work when foreign keys refer to the table."
I think generally mysql shops that use pt-online-schema-change don't create foreign key constraints in production, sidestepping the whole problem this article is about.
Re:Zero-downtime Postgres migrations – the hard parts
by spotman on Thursday May 28, 2015 @12:54AM
(#9616121)
Which is most of them that have enough traffic/data to need this tool in the first place. MySQL generally tends to perform badly at massive scale with foreign keys. (i.e., when your doing 30k queries/second)