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 ..
  • 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
  • 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

    Hello jksingh,

     

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

     

    Regards,

     

    Ajit

     

  • Hello jksingh,

     

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

     

    Regards,

     

    Ajit