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

Maxscale doesn't detect master and do failover if master is down before maxscale restart.

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.15
    • Fix Version/s: 2.4.0
    • Component/s: mariadbmon
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-70

      Description

      It seems Maxscale doesn't detect master and do failover if master is down before maxscale restart.

      [nil@centos68 rsandbox_mariadb-10_2_14]$ maxadmin list servers
      Servers.
      -------------------+-----------------+-------+-------------+--------------------
      Server             | Address         | Port  | Connections | Status              
      -------------------+-----------------+-------+-------------+--------------------
      master             | 127.0.0.1       | 24044 |           0 | Master, Running
      slave1             | 127.0.0.1       | 24045 |           0 | Running
      slave2             | 127.0.0.1       | 24046 |           0 | Running
      -------------------+-----------------+-------+-------------+--------------------
      [nil@centos68 rsandbox_mariadb-10_2_14]$ 
      [nil@centos68 rsandbox_mariadb-10_2_14]$ sudo /etc/init.d/maxscale stop
      Stopping MaxScale:                                         [  OK  ]
      [nil@centos68 rsandbox_mariadb-10_2_14]$ master/stop
      [nil@centos68 rsandbox_mariadb-10_2_14]$ 
      [nil@centos68 rsandbox_mariadb-10_2_14]$ sudo /etc/init.d/maxscale start
      Starting MaxScale: maxscale (pid 26334) is running...      [  OK  ]
      [nil@centos68 rsandbox_mariadb-10_2_14]$ 
      [nil@centos68 rsandbox_mariadb-10_2_14]$ maxadmin list servers
      Servers.
      -------------------+-----------------+-------+-------------+--------------------
      Server             | Address         | Port  | Connections | Status              
      -------------------+-----------------+-------+-------------+--------------------
      master             | 127.0.0.1       | 24044 |           0 | Down
      slave1             | 127.0.0.1       | 24045 |           0 | Running
      slave2             | 127.0.0.1       | 24046 |           0 | Running
      -------------------+-----------------+-------+-------------+--------------------
      [nil@centos68 rsandbox_mariadb-10_2_14]$
      

      So if master is down and we start maxscale, it should do the failover, select any of the slave and make it to master.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              esa.korhonen Esa Korhonen
              Reporter:
              niljoshi Nilnandan Joshi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: