0

I have set up an InnoDB cluster with one primary(R/W) and two secondaries (R/O) and bootstrapped a MySQL Router. The router has 2 port 6646(R/W port) and 6647(R/O) port. My application is currently connected to the cluster through the R/W port. Now I am looking for a way to implement load balancing in the cluster. Suppose there are 2 reading requests, how can I route the traffic to a different available database?

l.lijith
  • 918
  • 4
  • 9
  • 27
Wong Chung sze
  • 1

1 Answers1

0

By default, the Router will load-balance the R/O request in a round-robin fashion.

You can configure the routing strategy to meet your needs, see [basic routing] and [routing_strategy].

Miguel Araújo
  • 310
  • 1
  • 7