Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3677

The GTID of Galera Nodes is not displayed by maxctrl server list | maxscale 2.5.13

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 2.5.13
    • Fix Version/s: N/A
    • Component/s: galeramon
    • Labels:
      None
    • Environment:
      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.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            ponsuresh.pandians Pon Suresh Pandian
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration