Database redundancy in HAproxy with pfsense
-
Im trying to use haproxy for database redundancy. Some details
1st database server IP address- 192.168.10.18
2nd database server IP address- 192.168.10.20
And I created a virtual IP 192.168.10.100 under the lan because these are the Lan IPs
Now I am using this IP in Haproxy but it doesn’t work
I can connect directly both the servers
I tried to apply a NAT rule but it doesn’t work
Can you please help to understand or do you have Anybook on pfsense ? -
@asheeshc2
Shouldn't this better be realized with a database server cluster?
At least if you need write access to the database. -
-
Resolved, there was an issue in connection limit