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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.5.13
    • N/A
    • galeramon
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ponsuresh.pandians Pon Suresh Pandian (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.