|
CMAPI status shows node1 as master, but maxcale shows node 3 as master. Restarting CMAPI/maxsclae didn't help.
- CMAPI status;
$ curl -k -s https://mcs01:8640/cmapi/0.4.0/cluster/status \
|
> --header 'Content-Type:application/json' \
|
> --header 'x-api-key:xxxxxxxxxxxxxxxxxxxxxxx' \
|
> | jq .
|
{
|
"timestamp": "2021-06-16 13:21:45.236436",
|
"xxx.xxx.xxx.235": {
|
"timestamp": "2021-06-16 13:21:45.256826",
|
"uptime": 101322,
|
"dbrm_mode": "master",
|
"cluster_mode": "readwrite",
|
"dbroots": [],
|
"module_id": 1,
|
"services": [
|
{
|
"name": "workernode",
|
"pid": 27105
|
},
|
{
|
"name": "controllernode",
|
"pid": 27115
|
},
|
{
|
"name": "PrimProc",
|
"pid": 27132
|
}
|
]
|
},
|
"xxx.xxx.xxx.91": {
|
"timestamp": "2021-06-16 13:21:46.309152",
|
"uptime": 101255,
|
"dbrm_mode": "slave",
|
"cluster_mode": "readonly",
|
"dbroots": [],
|
"module_id": 2,
|
"services": [
|
{
|
"name": "workernode",
|
"pid": 26382
|
}
|
]
|
},
|
"xxx.xxx.xxx.42": {
|
"timestamp": "2021-06-16 13:21:46.740908",
|
"uptime": 88802,
|
"dbrm_mode": "slave",
|
"cluster_mode": "readonly",
|
"dbroots": [],
|
"module_id": 3,
|
"services": [
|
{
|
"name": "workernode",
|
"pid": 16217
|
},
|
{
|
"name": "PrimProc",
|
"pid": 16238
|
},
|
{
|
"name": "ExeMgr",
|
"pid": 16271
|
},
|
{
|
"name": "WriteEngine",
|
"pid": 16289
|
}
|
]
|
},
|
"num_nodes": 3
|
}
|
- maxscale show monitors
{
|
"master": "mcs01",
|
"master_gtid_domain_id": 0,
|
"primary": null,
|
"server_info": [
|
{
|
"gtid_binlog_pos": "0-1-21893",
|
"gtid_current_pos": "0-1-21893",
|
"lock_held": null,
|
"master_group": null,
|
"name": "mcs01",
|
"read_only": false,
|
"server_id": 1,
|
"slave_connections": []
|
},
|
{
|
"gtid_binlog_pos": "0-1-21893",
|
"gtid_current_pos": "0-1-21893",
|
"lock_held": null,
|
"master_group": null,
|
"name": "mcs02",
|
"read_only": true,
|
"server_id": 2,
|
"slave_connections": [
|
{
|
"connection_name": "",
|
"gtid_io_pos": "0-1-21893",
|
"last_io_error": "",
|
"last_sql_error": "",
|
"master_host": "xxx.xxx.xxx.42",
|
"master_port": 3306,
|
"master_server_id": 1,
|
"seconds_behind_master": 0,
|
"slave_io_running": "Yes",
|
"slave_sql_running": "Yes"
|
}
|
]
|
},
|
|
screenshot-1.png