Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Won't Fix
-
1.4.5
-
None
-
Ubuntu 16.04 LTS 64 Bit
MaxScale from MariaDB repositories
MariaDB 10.1.22 from MariaDB repositories
PHP 7.1 / PDO_MYSQL from Ubuntu PPA (ondrej)
Description
We are plannign to use a cascaded setup of MaxScales where our Application (Symfony/Doctrine) only knows one central MaxScale instance (maxscale0).
- We have multiple Galera clusters
- Each Galera cluster has its own MaxScale in front
- maxscale0 has access to all other maxscale instances
- We are using the schemarouter on maxscale0
Application -> maxscale0 -> maxscale(1-10)
|
Everything works very well and fast for 10 minutes. After 10 minutes doctrine is starting to throw errors.
"exception":{"class":"Doctrine\\ORM\\Internal\\Hydration\\HydrationException","message":"The discriminator column \"type\" is missing for \"WM\\UtilsBundle\\Entity\\ConfigTrackingAccount\" using the DQL alias \"r\"."}
|
With a message from MaxScale
SQLSTATE[HY000]: General error: 2003 Lost connection to backend server.
|
Even MaxScale in Debug mode does not show where the problem may come from.
It seems like, even on long running queries, the database gets lost.
Configurations
maxscale0
|
|
[MaxScale]
|
threads = 4
|
auth_connect_timeout = 5
|
auth_read_timeout = 10
|
auth_write_timeout = 5
|
...
|
|
|
...
|
[ShardAllDatabases]
|
type=service
|
router=schemarouter
|
servers=maxscale1,maxscale2,maxscale3
|
user=
|
passwd=
|
filters=FilterCreateDatabase|FilterDropDatabase
|
auth_all_servers=1
|
router_options=refresh_interval=5,refresh_databases=1
|
...
|
|
|
...
|
[maxscale1]
|
type=server
|
address=123.123.123.123
|
port=3306
|
protocol=MySQLBackend
|
...
|
maxscaleN
[MaxScale]
|
threads = 2
|
auth_connect_timeout = 5
|
auth_read_timeout = 10
|
auth_write_timeout = 5
|
...
|
|
|
[MySQL]
|
type=service
|
router=readconnroute
|
servers=mariadb1,mariadb2,mariadb3
|
enable_root_user=0
|
localhost_match_wildcard_host=1
|
version_string='MaxScale'
|
auth_all_servers=1
|
log_auth_warnings=1
|
router_options=synced
|
user=
|
passwd=
|
|
|
[mariadb1]
|
type=server
|
address=111.111.111.111
|
port=3306
|
protocol=MySQLBackend
|
...
|