Forum Discussion

JoshP_187840's avatar
JoshP_187840
Icon for Nimbostratus rankNimbostratus
Aug 27, 2015

Load Balancing Method Recommendations for MySQL?

I have a pool of 3 Maria MySQL nodes, replicated through Percona xtrabackup. I have them in the F5, but we've noticed that sometimes the replication isn't sufficient to keep up with our actual applic...
application delivery
design
LTM
performance
Stanislas_Piro2's avatar
Stanislas_Piro2
Icon for Cumulonimbus rankCumulonimbus
Aug 27, 2015

Hi,

 

I think you must configure Priority group activation with minimum of 1 member

 

  • Priority member 1 : 5
  • Priority member 2 : 3

  • Priority member 3 : 1

     

  • if member 1 is up, all connections will be sent to it

     

  • if member 1 is down and member 2 is up, all connections will be sent to member 2
  • if member 1 is down, member 2 is down and member 3 is up, all connections will be sent to member 3