Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.4.18
-
None
-
centos8
Description
In galera cluster, set read-only and wait a moment, then user can write data in read-only mode .
MariaDB [nova]> set global read_only=1;
|
Query OK, 0 rows affected (0.061 sec)
|
|
|
MariaDB [nova]> select @@read_only;
|
+-------------+
|
| @@read_only |
|
+-------------+
|
| 1 |
|
+-------------+
|
1 row in set (0.001 sec)
|
|
|
MariaDB [nova]> delete from tags;
|
ERROR 1290 (HY000): The MariaDB server is running with the --read-only option so it cannot execute this statement
|
MariaDB [nova]> insert into tags values ('11','aa');
|
ERROR 1290 (HY000): The MariaDB server is running with the --read-only option so it cannot execute this statement
|
MariaDB [nova]>
|
MariaDB [nova]>
|
MariaDB [nova]>
|
MariaDB [nova]> insert into tags values ('11','aa');
|
Query OK, 1 row affected (0.002 sec)
|