ODBC should provide that some load balancing capabilities.

There can be different principles:

• round-robin through 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.