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

            Assignee:
            markus makela markus makela
            Reporter:
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: