Following up and improving on Solving the Facebook-OSC non-atomic table swap problem, we present a better, safe solution.
Quick, quickest recap:
We are working on a triggerless online schema migration solution. It is based on an asynchronous approach, similarly to the FB osc and as opposed to the synchronous solution as used by pt-online-schema-change.
We asynchronously synchronize (is that even a valid statement?) between some table tbl and a ghost table ghost, and at some time we want to cut-over: swap the two; kick …[Read more]