Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
6.2.0
-
None
-
AWS compute instance, slaved DR cluster
Description
I have 2 clusters
3 dbs behind 2 maxscale nodes behind a NLB
DR is slaved to the other cluster
The DR cluster is able to be used if a write is sent. I would request a flag to allow RO enforcement on the below setup. Based off "Slave of External Server".
This should be a variable in the service like "external_slave_read_only"
[bryan.bancroft@AUSW2RESIGNMS01 ~]$ maxctrl list servers
┌─────────────────┬──────────────┬──────┬─────────────┬───────────────────────────────────────────┬──────────────┐
│ Server │ Address │ Port │ Connections │ State │ GTID │
├─────────────────┼──────────────┼──────┼─────────────┼───────────────────────────────────────────┼──────────────┤
│ AUSW2RESIGNDB01 │ 10.135.20.39 │ 3306 │ 120 │ Master, Running, Slave of External Server │ 0-101-112016 │
├─────────────────┼──────────────┼──────┼─────────────┼───────────────────────────────────────────┼──────────────┤
│ AUSW2RESIGNDB02 │ 10.135.21.25 │ 3306 │ 120 │ Slave, Running │ 0-101-112016 │
├─────────────────┼──────────────┼──────┼─────────────┼───────────────────────────────────────────┼──────────────┤
│ AUSW2RESIGNDB03 │ 10.135.20.15 │ 3306 │ 120 │ Slave, Running │ 0-101-112016 │
└─────────────────┴──────────────┴──────┴─────────────┴───────────────────────────────────────────┴──────────────┘