aecefb1b87
Some queries (e.g. SET AUTOCOMMIT, ROLLBACK) may be executed before schema is selected, causing them to be routed to hostgroup 0, which does not exist if user using different `mariadb_default_shard_id`. This change sets default_hostgroup (shard_id) for users to ensure correct routing even when schema is not specified. Also adjusts nova-cell user generation logic to include shard assignment, so queries from nova_<cell> users are properly routed, even if schema is not used directly. This avoids silent misrouting and improves reliability in multi-shard deployments. Note: These errors are not visible in CI because mariadb_default_shard_group_id = 0 and ProxySQL routes to hostgroup 0 by default when no routing rule matches. Depends-On: https://review.opendev.org/c/openstack/kolla/+/951741 Closes-Bug: #2112339 Change-Id: I4f3380a83fa992c3413e82a4692c26a07b25d57f
11 lines
469 B
YAML
11 lines
469 B
YAML
---
|
|
fixes:
|
|
- |
|
|
Improves query routing in ProxySQL by setting ``default_hostgroup``
|
|
for all database users and by adding user-based routing rules in
|
|
addition to schema-based rules. This enhancement also fixes incorrect
|
|
routing of queries that are executed before a schema is selected,
|
|
such as ``SET AUTOCOMMIT`` or ``ROLLBACK``, which could otherwise be sent
|
|
to a non-existent hostgroup.
|
|
`LP#2112339 <https://launchpad.net/bugs/2112339>`__
|