Re:Safely Dropping MySQL Tables
by grogers on Monday July 25, 2022 @03:33PM
(#32229793)
If you happen to still be using it then you'd get a lot of errors right away though. If you are extremely paranoid you can do better by migrating to a new user that doesn't have access to the table. Switching to the new user would be a normal rolling deploy, so you'd only start with 1/N errors, and your normal rollback process gets automatically triggered.
Re:Safely Dropping MySQL Tables
by jjeaff on Monday July 25, 2022 @04:04PM
(#32230190)
Oh, that's clever. I have so rarely utilized the user management system in MySQL beyond just creating a user with the necessary permissions for each application. I hadn't ever thought of using new users to do canary deployments.
Probably not worth the hassle though.