> > At present I don't think we will have so many connections.
> I agree with
> > Topology 3 but I'm concerned about future performance as more
> > connections come in and also the Single Point Of Failure
> (SPOF) at the
> > DB Server. Any further comments?
>
> the HOWTO pretty much covers it. Redundant DB's are really expensive.
> Faster DB's are only expensive.
We use the same setup here as described in topology 3, but have failover
capability in the DBs.
If you wanted to go "on the cheap", setup a mysql database with
auto-replication (I think it is built into later versions of mysql?)...
Another option to check out drdb + heartbeat. Or if you need more
complexity maybe you want to look at Suse/SGI's failsafe.
===
Whatever you choose - test it out and expect it to take a bit of time.
Good luck
|