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

readwritesplit router doesn't allow connect when the only remaining server is master and slave

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.0
    • Component/s: readwritesplit
    • Labels:
      None

      Description

      Hi, using MXS 1.2.1 on Centos 6 64 bits.

      I have set-up a simple Master/Slave replication with 3 routers on Maxscale:
      1) Master Route
      2) Slave Route
      3) RW Split

      My replication breaks, and I restart maxscale, it doesn't allow anymore connections.

      To fix it, I disable the monitor, and set manually the flags on the "healthy" server.

      If I give only the "master" flag, all 3 routers works well.
      If I also give the "slave" flag, then the readwritesplit doesn't connect anymore.

      I think this is a bug, but I leave the last word to you.

      Cheers,
      Joffrey

      Scenario 1 (manually setting the server to "master" only

      MaxScale> list servers
      Servers.
      -------------------+-----------------+-------+-------------+--------------------
      Server             | Address         | Port  | Connections | Status
      -------------------+-----------------+-------+-------------+--------------------
      vm-xxx-xxx-db-1    | 10.0.51.81      |  3306 |           0 | Running
      vm-xxx-xxx-db-2    | 10.0.51.82      |  3306 |           0 | Running
      -------------------+-----------------+-------+-------------+--------------------
       
      MaxScale> shutdown monitor "MySQL Monitor"
      MaxScale> set server vm-xxx-xxx-db-1 master
      MaxScale> list servers
      Servers.
      -------------------+-----------------+-------+-------------+--------------------
      Server             | Address         | Port  | Connections | Status
      -------------------+-----------------+-------+-------------+--------------------
      vm-xxx-xxx-db-1    | 10.0.51.81      |  3306 |           0 | Master, Running
      vm-xxx-xxx-db-2    | 10.0.51.82      |  3306 |           0 | Running
      -------------------+-----------------+-------+-------------+--------------------
       
      Test connectivity (all OK):
       
      # mysql -BN -h10.0.51.83 -udba_user  -P33306 -e "select @@hostname,'mastercon'"
      vm-xxx-xxx-db-1 mastercon
       
      # mysql -BN -h10.0.51.83 -udba_user  -P33307 -e "select @@hostname,'slavecon'"
      vm-xxx-xxx-db-1 slavecon
       
      # mysql -BN -h10.0.51.83 -udba_user  -P33308 -e "select @@hostname,'rwsplit'"
      vm-xxx-xxx-db-1 rwsplit
       

      Scenario 2 (manually setting the server to "master" only

       
      MaxScale> set server vm-xxx-xxx-db-1 slave
      MaxScale> list servers
      Servers.
      -------------------+-----------------+-------+-------------+--------------------
      Server             | Address         | Port  | Connections | Status
      -------------------+-----------------+-------+-------------+--------------------
      vm-xxx-xxx-db-1    | 10.0.51.81      |  3306 |           0 | Master, Slave, Running
      vm-xxx-xxx-db-2    | 10.0.51.82      |  3306 |           0 | Running
      -------------------+-----------------+-------+-------------+--------------------
       
      Test connectivity (NOT ALL OK):
       
      # mysql -BN -h10.0.51.83 -udba_user  -P33306 -e "select @@hostname,'mastercon'"
      vm-xxx-xxx-db-1 mastercon
       
      # mysql -BN -h10.0.51.83 -udba_user  -P33307 -e "select @@hostname,'slavecon'"
      vm-xxx-xxx-db-1 slavecon
       
      # mysql -BN -h10.0.51.83 -udba_user  -P33308 -e "select @@hostname,'rwsplit'"
      (timeout ...)
       
       
       
      Nothing in the logs....
       

        Attachments

          Activity

            People

            Assignee:
            markus makela markus makela
            Reporter:
            joffrey Joffrey MICHAIE (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: