[MXS-4454] Schemarouter should prefer targets which have databases in them for session commands Created: 2022-12-15  Updated: 2023-06-16  Resolved: 2022-12-19

Status: Closed
Project: MariaDB MaxScale
Component/s: schemarouter
Affects Version/s: 6.4.4
Fix Version/s: 6.4.5, 22.08.4

Type: Bug Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 Description   

A backend can end up being chosen as the replier of a session command even before authentication to it has completed. For readwritesplit this is not a problem as the state of the server implies which server to choose but for the schemarouter there is nothing that tells which server to prefer.

An improvement to the situation can be achieved by looking into the shard map and seeing if any of the backends is known to have been successfully mapped. This should avoid most problems that could occur when a user exists on a subset of the servers.


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