Re: Backups and Recovery
AFAIK MySQL doesn't have this level of engineering.
If you follow the rule that only root has direct ie non-app access, then if all login logic has been implemented to include gracefully rejecting non-root access in emergencies like disaster recovery, you should need only to set a switch in that mechanism to hold logins at bay, otherwise restarting the server with skip-networking should work,
Yes you could backup up the priv tables and substitute in a set of reject-everyone or everybody-is-read-only rules, but Rube Goldberg solutions like that usually come to grief, don't they?
Edited 1 time(s). Last edit at 08/29/2018 09:12PM by Peter Brawley.
Subject
Written By
Posted
Re: Backups and Recovery
August 29, 2018 09:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.