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

Replica in RDS not detected as slave

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 2.3.3
    • N/A
    • mariadbmon
    • 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

            esa.korhonen Esa Korhonen
            kucyk Lukasz
            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.