Sean Handley
1 min readJan 29, 2019

--

You have an additional issue if the table is large because the whole table is locked when you add/modify a column!

We use percona tools to mitigate this. It clones the table, makes the change to the cloned table, synchronises both tables, then renames the clone to be the current table and deletes the old one.

We use a replica set up with our DB and this process saves us from replication lag.

--

--

Sean Handley
Sean Handley

Written by Sean Handley

Engineer, leader, open-source fan.

No responses yet