I want to lock everything--completely. Very simple. Just prevent things from changing!! Will this work?
use mydatabase;
flush tables with read lock;
...
unlock tables;
Edit: But, it has to be available for replication.
views:
61answers:
2
+1
A:
This closes all open tables and locks all tables for all databases with a read lock until you execute UNLOCK TABLES.
NTulip
2009-12-11 21:46:41
What does that mean...does it accomplish what I want?
TIMEX
2009-12-11 21:47:23
maybe. clients that want to write will stall until the table is unlocked or they time out. in addition, any clients that want to read after a writer stalls will also stall. if you want all writes to error, you need to change the user permissions.
longneck
2009-12-11 21:52:26
i agree = you should go with read only permissions for the username accessing the data. my suggestion works within the same transaction.
NTulip
2009-12-11 21:54:58
+2
A:
Wouldn't it be simpler to adjust the security for the user account accessing the database so that it only has read access?
David Lively
2009-12-11 21:48:45