Loadbalancing capabilities

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.