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

existing connection don't change routing, even if master switched

    XMLWordPrintable

Details

    Description

      Config:
      router = readconroute
      router_option=master

      It seems, that the type check will ony be done on connection time,
      it should be done also at runtime.

       info: [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
      : Server changed state: DB3[192.168.0.3:3306]: new_slave. [Master, Running] -> [Slave, Running]
       error : [mysqlmon] No Master can be determined. Last known was 192.168.0.3:3306
       
      info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
       info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
       info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
       info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
       notice : Server changed state: DB1[192.168.0.3:3306]: new_master. [Master, Slave, Running] -> [Master, Running]
       notice : [mysqlmon] A Master Server is now available: 192.168.0.3:3306
       info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
       info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
       info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
      

      Attachments

        Activity

          People

            markus makela markus makela
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.