Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
2.3.3
-
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 <
|