OK, I currently have 2 Rack mount machine nearly identical sitting in a local datacenter. The are nothing more then MySQL database servers. their raid setup is Raid 0 (4 drives) but i am using drbd to do a network based Raid 1 (bidirectional) with MySQL partition.
I also have configured on the 2 machines a heart beat service monitor for a failover system if machine 1's MySQL goes down.
Now this method seems fine, but i have noticed some cases this fail over method is not good enough. So I want to add one more failover into my setup. I want to get a router that suppose a LAN based failover.
But i can not find a cost effective solution atm. I know the Cisco Pix 515 support this, but its way more then what i need.
Any one have any suggestions for a good cost effective gigabit router that supports this?