Hacker News new | ask | show | jobs
by mathnode 1425 days ago
You are spot on. And more importantly, a roll back procedure.

In this case, RENAME TABLE x TO y, and watch or wait for a process to fail in test/QA/UAT/etc.

Have a DROP ready, but also a RENAME back.

A production quality MySQL or MariaDB installation should have enabled binary logging and maybe delayed replication to handle any issues.