Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
2.4.8
-
Debian 10 (Buster)
MariaDB 10.4.12
Description
When accessing a database which only resides on srv02 with
mariadb -h srv02.addr.tld -u dbuser02 -p -D srv02_db02
|
... and executing the 'status' command. The Output of the command shows the status of srv01 instead of srv02.
/var/log/maxscale/maxscale.log
2020-04-12 20:55:38 notice : Server changed state: srv01[10.0.0.1:3306]: new_master. [Running] -> [Master, Running] |
-
maxctrl list servers
|
|
|
┌─────────┬───────────────┬──────┬─────────────┬─────────────────┬─────────────────┐
|
│ Server │ Address │ Port │ Connections │ State │ GTID │
|
├─────────┼───────────────┼──────┼─────────────┼─────────────────┼─────────────────┤
|
│ srv01 │ 10.0.0.1 │ 3306 │ 0 │ Master, Running │ 0-1-200 │ |
├─────────┼───────────────┼──────┼─────────────┼─────────────────┼─────────────────┤
|
│ srv02 │ 10.0.0.2 │ 3306 │ 0 │ Master, Running │ 0-2-450 │ |
└─────────┴───────────────┴──────┴─────────────┴─────────────────┴─────────────────┘
|
maxscale.cnf
[maxscale]
|
threads=auto
|
|
|
[srv01]
|
type=server
|
address=10.0.0.1 |
port=3306 |
protocol=MariaDBBackend
|
|
|
[srv02]
|
type=server
|
address=10.0.0.2 |
port=3306 |
protocol=MariaDBBackend
|
|
|
[srv01-monitor]
|
type=monitor
|
module=mariadbmon
|
servers=srv01
|
user=maxscale_monitor
|
password=password
|
monitor_interval=2000ms
|
|
|
[srv02-monitor]
|
type=monitor
|
module=mariadbmon
|
servers=srv02
|
user=maxscale_monitor
|
password=password
|
monitor_interval=2000ms
|
|
|
[schema-service]
|
type=service
|
router=schemarouter
|
servers=srv01,srv02
|
user=maxscale
|
password=password
|
auth_all_servers=1 |
|
|
[schema-listener]
|
type=listener
|
service=schema-service
|
protocol=MariaDBClient
|
port=3306 |