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

Replica in RDS not detected as slave

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.3
    • Fix Version/s: Icebox
    • Component/s: mariadbmon
    • Labels:
    • Environment:
      Ubuntu 18.04.1 LTS
      AWS RDS

      Description

      Hi all,

      Since I've upgraded from maxscale-2.2.19-1.ubuntu.bionic.x86_64.deb to maxscale-2.3.3-1.ubuntu.xenial.x86_64.deb and the MaxScale stopped routing queries to replica running in RDS. The read replicas are now being detected as Slave of External Server and in result all queries including basic SELECT statements are now executed on Master.

       Server          │ Address                                                 │ Port │ Connections │ State         
      ├────────────────┼─────────────────────────────────────────────────────────┼──────┼─────────────┼───────────────
      │ genericprod01  │ XXX.us-east-1.rds.amazonaws.com  │ 3306 │ 0             │ Master, Running                      
      ├────────────────┼─────────────────────────────────────────────────────────┼──────┼─────────────┼───────────────
      │ genericslave01 │ YYY.eu-west-1.rds.amazonaws.com │ 3306  │ 0             │ Slave of External Server, Running 
      

      Here is the result of the simple query:

      2019-01-29 19:55:30   info   : (814) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 29, type: QUERY_TYPE_READ, stmt: select * from wp_options
      2019-01-29 19:55:30   info   : (814) Route query to master: genericprod01       [XXX.us-east-1.rds.amazonaws.com]:3306 <
      

        Attachments

          Activity

            People

            Assignee:
            esa.korhonen Esa Korhonen
            Reporter:
            kucyk Lukasz
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: