[MXS-1139] High load Created: 2017-02-15  Updated: 2017-12-04  Resolved: 2017-02-15

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: 1.2.1
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Mejar Singh Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

galera-cluster

Attachments: File maxscale.conf    

 Description   

Hi

We have done a loadtest of 40.000 users logging in over 15 mins in our site, and have seen this in our maxscale log:

1 Warning: Duplicate MySQL user found for service [RW Split Router]: newrelic@127.0.0.1
for database: (null)
2017-02-14 21:55:22 Warning: Duplicate MySQL user found for service [RW Split Router]: newrelic@127.0.0.1
for database: (null)

RW Split Router: Refresh rate limit exceeded for load of users' table.
Error : Couldn't find suitable Master from 3 candidates.
Error : Failed to create RW Split Router session.
Error : Failed to create RW Split Router session.
Error : Couldn't find suitable Master from 3 candidates.
Error : Failed to create RW Split Router session.
Error : Monitor was unable to connect to server galera2:3306 : "Can't connect to MySQL server on 'galera2' (4)"
Error : Couldn't find suitable Master from 3 candidates.

we saw that maxscale detected all 3 galera nodes as down during the test.

 Comments   
Comment by Johan Wikman [ 2017-02-15 ]

Please upgrade to 1.4.5 or 2.0.4.

We will not do any bug-fixes to 1.2.1.

Comment by Johan Wikman [ 2017-02-15 ]

1.2.1 is an old version and should be upgraded to 1.4.5 or 2.0.4.

If the problem persists after the upgrade, please reopen this issue or create a new one.

Comment by Mejar Singh [ 2017-02-17 ]

Hi Johan

Maxscale was stabilized after upgrade to 1.4.5 !

A question I have is if maxscale with galera setup as in our conf file, is supported when using persisten connections ?
As we consider to use this if performance improvement

regards
Mejar

Generated at Thu Feb 08 04:04:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.