Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.26, 23.02.2
-
ec2
Description
The fact that readconnroute will happily route writes to replicas with router_options=slave is not documented. This should be clearly stated in the documentation since one might assume that writes would be blocked.
Original description:
Issue; If I define a read-only service As a super user I can still write to a replica. This allows certain users to break an async cluster thru the RO service
Expectation; If connecting to a RO service, regardless of user, writes should be blocked
├──────────┼──────────────┼──────┼─────────────┼──────────────────────┼──────────────┼─────────────────┤
|
│ foo1 │ 131.21.1.185 │ 3306 │ 0 │ Master, Running │ 0-1-45301601 │ MariaDB-Monitor │
|
├──────────┼──────────────┼──────┼─────────────┼──────────────────────┼──────────────┼─────────────────┤
|
│ foo2 │ 131.21.1.248 │ 3306 │ 1 │ Slave, Running │ 0-2-45301602 │ MariaDB-Monitor │
|
└──────────┴──────────────┴──────┴─────────────┴──────────────────────┴──────────────┴─────────────────┘
|
|
|
MariaDB [test]> select @@hostname;
|
+------------+
|
| @@hostname |
|
+------------+
|
| fooshop-2 |
|
+------------+
|
1 row in set (0.001 sec)
|
|
|
MariaDB [test]> select @@read_only;
|
+-------------+
|
| @@read_only |
|
+-------------+
|
| 1 |
|
+-------------+
|
1 row in set (0.001 sec)
|
|
|
MariaDB [test]> drop table Phone_Transact;
|
Query OK, 0 rows affected (0.006 sec)
|
Attachments
Issue Links
- blocks
-
DOCS-3767 Loading...