Load Balance Algorithm

    Moreover, considering the complexity of the business scenario, the built-in algorithm also provides an extension mode. Users can implement the load balancer algorithm they need based on SPI interface.

    Type: ROUND_ROBIN

    Description: Within the transaction, read query are routed to the primary, and outside the transaction, the round-robin strategy is used to route to the replica.

    Attributes: None

    Random Load Balance Algorithm

    Type: RANDOM

    Description: Within the transaction, read query are routed to the primary, and outside the transaction, the random strategy is used to route to the replica.

    Attributes: None

    Weight Load Balance Algorithm

    Type: WEIGHT

    Description: Within the transaction, read query are routed to the primary, and outside the transaction, the weight strategy is used to route to the replica.

    Type: TRANSACTION_RANDOM

    Description: Display/non-display open transaction, read query are routed to multiple replicas using random strategy.

    Attributes: None

    Transaction Round-robin Load Balance Algorithm

    Type: TRANSACTION_ROUND_ROBIN

    Description: Display/non-display open transaction, read query are routed to multiple replicas using round-robin strategy.

    Attributes: None

    Transaction Weight Load Balance Algorithm

    Type: TRANSACTION_WEIGHT

    Description: Display/non-display open transaction, read query are routed to multiple replicas using weight strategy.

    Attributes:

    Description: Open transaction displayed, and the read query is routed to a fixed replica using random strategy; otherwise, each read traffic is routed to a different replica using random strategy.

    Attributes: None

    Fixed Replica Round-robin Load Balance Algorithm

    Type: FIXED_REPLICA_ROUND_ROBIN

    Description: Open transaction displayed, and the read query is routed to a fixed replica using round-robin strategy; otherwise, each read traffic is routed to a different replica using round-robin strategy.

    Attributes: None

    Fixed Replica Weight Load Balance Algorithm

    Type: FIXED_REPLICA_WEIGHT

    Description: Open transaction displayed, and the read query is routed to a fixed replica using weight strategy; otherwise, each read traffic is routed to a different replica using weight strategy.

    Attributes:

    Type: FIXED_PRIMARY

    Attributes: None

    1. Configure a load balancer algorithm for the loadBalancers attribute to use read/write splitting.