Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
2.5.13
-
None
-
CentOS Linux release 7.7.1908 (Core)
MariaDB server - 10.5.10 (ES)
Description
I have installed 2 node galera cluster along with maxscale. If i run "maxctrl list servers" command It's showing only server1 GTID not other server.
[root@ip-172-31-12-219 centos]# maxctrl list servers
┌─────────┬──────────────┬──────┬─────────────┬─────────────────────────┬────────┐
│ Server │ Address │ Port │ Connections │ State │ GTID │
├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼────────┤
│ server1 │ 18.207.3.40 │ 3333 │ 0 │ Master, Synced, Running │ 1-1-15 │
├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼────────┤
│ server2 │ 54.237.3.158 │ 3333 │ 0 │ Slave, Synced, Running │ │
└─────────┴──────────────┴──────┴─────────────┴─────────────────────────┴────────┘
If I stopped the mariadb service on server1. Now server2 is promoted as a master and performed some writes on server2.
MariaDB [test]> create table t1 (id int,name varchar(20));
Query OK, 0 rows affected (0.010 sec)
MariaDB [test]> insert into t1 values(1,'kjsdlad');
Query OK, 1 row affected (0.002 sec)
MariaDB [test]> insert into t1 values(2,'mmznb');
Query OK, 1 row affected (0.001 sec)
MariaDB [test]> insert into t1 values(3,'rock');
Query OK, 1 row affected (0.002 sec)
MariaDB [test]> insert into t1 values(4,'khlcsk');
Query OK, 1 row affected (0.002 sec)
MariaDB [test]> insert into t1 values(5,'lcsk');
Query OK, 1 row affected (0.004 sec)
In maxscale it's not showing any GTID on server2. Why this behaviour ?
[root@ip-172-31-12-219 centos]# maxctrl list servers
┌─────────┬──────────────┬──────┬─────────────┬─────────────────────────┬──────┐
│ Server │ Address │ Port │ Connections │ State │ GTID │
├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼──────┤
│ server1 │ 18.207.3.40 │ 3333 │ 0 │ Down │ │
├─────────┼──────────────┼──────┼─────────────┼─────────────────────────┼──────┤
│ server2 │ 54.237.3.158 │ 3333 │ 0 │ Master, Synced, Running │ │
└─────────┴──────────────┴──────┴─────────────┴─────────────────────────┴──────┘
Here I have attached my maxscale config for your reference please check it.