MaxScale tries to authenticate users in all servers

Question

I'm trying to test if we could use MaxScale 2.4 to add multiple MySQL servers to an existing application and route the queries to the appropriate server using the schema name.

I have set skip_authentication=true to let the MySQL servers handle authentication.

We use vault to create temporary users. When I add a user to one of the servers using vault, I can connect to MaxScale using the mysql cli; but when I try to run a query, it fails because MaxScale is trying to authenticate the users in all servers and it only exists on one of them.

Is this the expected behaviour?

score 0 · Accepted Answer · answered Jul 22 '20 at 07:07

0

This is expected behavior in MaxScale 2.4 but was changed in 2.5 to allow authentication on only a subset of servers (MXS-760).

answered Jul 22 '20 at 07:07

markusjm

2,358
1
11
23

Thank you! I didn't test with version 2.5 because there are still no containers available on dockerhub. – Krychek Jul 22 '20 at 10:33
The 2.5 docker images should be out shortly. – markusjm Jul 23 '20 at 11:12

MaxScale tries to authenticate users in all servers

1 Answers1