To balance connections to reader instances more evenly, different selection strategies can be used. The following table describes the currently available selection strategies and any relevant configuration parameters for each strategy.
| Reader Selection Strategy | Configuration Parameter | Description | Default Value |
|---|---|---|---|
random |
This strategy does not have configuration parameters. | The random strategy is the default selection strategy. When switching to a reader connection, the reader instance will be chosen randomly from the available database instances. | N/A |
least_connections |
This strategy does not have configuration parameters. | The least connections strategy will select reader instances based on which database instance has the least number of currently active connections. Note that this strategy is only available when internal connection pools are enabled - if you set the connection property without enabling internal pools, an exception will be thrown. | N/A |
round_robin |
See the following rows for configuration parameters. | The round robin strategy will select a reader instance by taking turns with all available database instances in a cycle. A slight addition to the round robin strategy is the weighted round robin strategy, where more connections will be passed to reader instances based on user specified connection properties. | N/A |
round_robin_host_weight_pairs |
This parameter value must be a string type comma separated list of database host-weight pairs in the format <host>:<weight>. The host represents the database instance name, and the weight represents how many connections should be directed to the host in one cycle through all available hosts. For example, the value instance-1:1,instance-2:4 means that for every connection to instance-1, there will be four connections to instance-2. Note: The <weight> value in the string must be an integer greater than or equal to 1. |
null |
|
round_robin_default_weight |
This parameter value must be an integer value in the form of a string. This parameter represents the default weight for any hosts that have not been configured with the round_robin_host_weight_pairs parameter. For example, if a connection were already established and host weights were set with round_robin_host_weight_pairs but a new reader host was added to the database, the new reader host would use the default weight. Note: This value must be an integer greater than or equal to 1. |
1 |