Forum Discussion
jksingh_44237
Nimbostratus
Nimbostratusmysql 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 ..
nitassEmployee
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_5Cirrus
jksingh,
have you configured persistency (source addr)? That's required for balancing sql servers (due to the authentication).
Regards
Kurt Knochner
AjitAltostratus
Hello jksingh,
Removing the http profile from your VIP config will help resolve your issue.
Regards,
Ajit
- jaikumar_f5
MVP
Guys,,, this is 8 years old post... Com'n
- Ajit_128420
Hello jksingh,
Removing the http profile from your VIP config will help resolve your issue.
Regards,
Ajit
- jaikumar_f5
Guys,,, this is 8 years old post... Com'n
RaghavendraSYCan you please verify below configurations.
- SNAT
- HTTP profile