7 ms·
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. H
by mathnode 4y 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.