[CONC-529] Loadbalancing capabilities Created: 2021-03-08  Updated: 2023-12-05

Status: Open
Project: MariaDB Connector/C
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Ralf Gebhardt Assignee: Ralf Gebhardt
Resolution: Unresolved Votes: 3
Labels: None

Issue Links:
Blocks
blocks CONPY-265 Loadbalancing capabilities Open
blocks ODBC-393 Loadbalancing capabilities Open
Relates
relates to CONC-365 Failover capabilities Closed

 Description   

The MariaDB Connector/J provides load balancing and failover capabilities to provide some HA at the client end, see https://mariadb.com/kb/en/library/failover-and-high-availability-with-mariadb-connector-j/

MariaDB Connector/C should provide that same load balancing capabilities.

There can be different principles:

  • selector like 'RR' (round-robin), 'RANDOM' or 'ORDER' multiple hosts of the same type (main or replica)
  • have a counter to know the number of connection for each connection.

The first implementation is easier to do.
The second implementation has the advantage that when a node failover is ready again, to directly report the load to this new node until the distribution is similar on all nodes.


Generated at Thu Feb 08 03:05:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.