As most of you have noticed all StackExchange sites have been under maintenance/recovery a few days ago so they switched on READ-only mode. From their blog I know they used to use MS SQL Server 2008, and recently have moved on to SQL 2012.
The question is how do you switch READ-only mode in a specific RDBMS, thus keep the service up during maintenance?
Since I use CUBRID RDBMS most of the time, I know they provide an ACCESS_MODE switch in CUBRID Broker middleware (
cubrid_broker.conf) which allows DBAs to dynamically turn a READ/WRITE-enabled service to READ-only (+ ...) and vice versa. This is especially useful in an HA environment.
In MySQL as I know, even if you turn
my.cnf/my.ini, users with
SUPER and replication privileges still can write to a read only server.
I wonder how this is done in other relational databases. How does SO do this?