MySQL Virtual Server Sends RST packets

[TheodorosPortwo]

Hello All,

I am experiencing the following issue. I have a MYSQL Virtual Server listening on 3306 default port and my nodes on the corresponding pool are listening on 6033. The thing is that from within the BIG-IP i can access the Virtual Server on the 3306 through mysql cli but from a host that resides on the same subnet as the Virtual Server i receive the following error:

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104

[Lidev]

Hi Theodoros,

What is the gateway of your backend pool member ? If it's not your F5 BIG-IP you need to enable SNAT (automap) on your Virtual Server to avoid asymmetric routing issue.

Regards

[TheodorosPortwo]

Hello Lidev,

It resides on the F5 BIG-IP. There is a SELF-IP on the specific subnet that both the Gateway and Pool IP are assigned to. SNAT is enabled on the Virtual Server as well as the Port Translation and Address translation but nothing changed.Any other thought/suggestion?

Regards,

Theo

[Lidev]

Hi,

Do you set source adress filtering on your Virtual Server or enable packet filter ?

Regards

[TheodorosPortwo]

Hi,

None of them.

Regards,

Theodoros

[Lidev]

it's weird, can you share you virtual server configuration ? Pool member monitoring is UP ?