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

remove server does not drain node

    XMLWordPrintable

    Details

      Description

      MaxScale> list services
      Services.
      --------------------------------------------------------------------------------
      Service Name | Router Module | #Users | Total Sessions | Backend databases
      --------------------------------------------------------------------------------
      MarGal101 | readconnroute | 2 | 35 | nodeA, nodeB, nodeC
      MaxAdmin Service | cli | 2 | 2 |
      --------------------------------------------------------------------------------

      MaxScale> remove server nodeA MarGal101
      Removed server 'nodeA' from 'MarGal101'
      MaxScale> list services
      Services.
      --------------------------------------------------------------------------------
      Service Name | Router Module | #Users | Total Sessions | Backend databases
      --------------------------------------------------------------------------------
      MarGal101 | readconnroute | 2 | 35 | nodeB, nodeC
      MaxAdmin Service | cli | 2 | 2 |
      --------------------------------------------------------------------------------

      root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
      -----------------------------+

      @@hostname @@wsrep_node_name

      -----------------------------+

      chef Node A

      -----------------------------+
      1 row in set (0.00 sec)

      root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
      ERROR 2003 (HY000): Routing failed. Session is closed.
      root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
      ERROR 2006 (HY000): MySQL server has gone away
      No connection. Trying to reconnect...
      Connection id: 24163
      Current database: *** NONE ***

      -----------------------------+

      @@hostname @@wsrep_node_name

      -----------------------------+

      chef Node B

      -----------------------------+
      1 row in set (0.00 sec)

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            oli Oli Sennhauser
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: