mirror of
https://github.com/MariaDB/server.git
synced 2025-12-02 18:36:30 +01:00
The main purpose of this allow one to use the --read-only option to ensure that no one can issue a query that can block replication. The --read-only option can now take 4 different values: 0 No read only (as before). 1 Blocks changes for users without the 'READ ONLY ADMIN' privilege (as before). 2 Blocks in addition LOCK TABLES and SELECT IN SHARE MODE for not 'READ ONLY ADMIN' users. 3 Blocks in addition 'READ_ONLY_ADMIN' users for all the previous statements. read_only is changed to an enum and one can use the following names for the lock levels: OFF, ON, NO_LOCK, NO_LOCK_NO_ADMIN Too keep things compatible with older versions config files, one can still use values FALSE and TRUE, which are mapped to OFF and ON. The main visible changes are: - 'show variables like "read_only"' now returns a string instead of a number. - Error messages related to read_only violations now contains the current value off readonly. Other things: - is_read_only_ctx() renamed to check_read_only_with_error() - Moved TL_READ_SKIP_LOCKED to it's logical place Reviewed by: Sergei Golubchik <serg@mariadb.org> |
||
|---|---|---|
| .. | ||
| disabled.def | ||
| events_1.result | ||
| events_1.test | ||
| events_2.result | ||
| events_2.test | ||
| events_bugs-master.opt | ||
| events_bugs.result | ||
| events_bugs.test | ||
| events_embedded.result | ||
| events_embedded.test | ||
| events_grant.result | ||
| events_grant.test | ||
| events_logs_tests-master.opt | ||
| events_logs_tests.result | ||
| events_logs_tests.test | ||
| events_microsec.result | ||
| events_microsec.test | ||
| events_restart-master.opt | ||
| events_restart.result | ||
| events_restart.test | ||
| events_scheduling.result | ||
| events_scheduling.test | ||
| events_skip_grant_tables.opt | ||
| events_skip_grant_tables.result | ||
| events_skip_grant_tables.test | ||
| events_slowlog.result | ||
| events_slowlog.test | ||
| events_stress.result | ||
| events_stress.test | ||
| events_time_zone.result | ||
| events_time_zone.test | ||
| events_trans.result | ||
| events_trans.test | ||
| events_trans_notembedded.result | ||
| events_trans_notembedded.test | ||