Forum Discussion

jksingh_44237's avatar
jksingh_44237
Icon for Nimbostratus rankNimbostratus
Nov 04, 2011

mysql db pool configuration in F5

I have to put two mysql servers behind the F5 to balance the mysql db traffic for web servers... I have created the pool for two node & added for virtual also.... But facing the issue to establish the mysql connection with these node.. Is there any experience like this, Please share to fix my issue... For mysql node as well as Virtual server ia m using internel IP only Mysql nodes 1. 10.10.90.45 2. 10.10.90.46 Virtual IP for mysql pool 10.10.91.55 Is there any iRule to pass the mysql connection to node ..
application delivery
dev
devops
iRules

7 Replies

Sort By
  • nitass's avatar
    nitass
    Icon for Employee rankEmployee
    Nov 04, 2011
    can you post your configuration i.e. virtual server, pool here?

     

     

    for cli, you may run command below to show configuration.

     

    b virtual virtual_server_name list

     

    b pool pool_name list
  • Kurt_Knochner_5's avatar
    Kurt_Knochner_5
    Icon for Cirrus rankCirrus
    Nov 04, 2011
    jksingh,

     

     

    have you configured persistency (source addr)? That's required for balancing sql servers (due to the authentication).

     

     

    Regards

     

    Kurt Knochner
  • Ajit's avatar
    Ajit
    Icon for Altostratus rankAltostratus
    Feb 22, 2019

    Hello jksingh,

     

    Removing the http profile from your VIP config will help resolve your issue.

     

    Regards,

     

    Ajit

     

  • Ajit_128420's avatar
    Ajit_128420
    Icon for Nimbostratus rankNimbostratus
    Feb 22, 2019

    Hello jksingh,

     

    Removing the http profile from your VIP config will help resolve your issue.

     

    Regards,

     

    Ajit