= As usual, the system operating normally isn't half as interesting = as the system failing :-) Could you describe acceptable and = unacceptable consequences of failures? = = For instance, if one database goes down, is it acceptable to have: = - a few seconds dataloss?
Yes, a few seconds is fine, considering that the databases are presumed to be solid performers, and DB server failures would be rare. = - a few seconds before the database switches over? Also fine, depending on what goes on between during the switch. If there is a complete, brief outage, then that's fine, but I'd need to avoid unsynchronized writes to both servers. = - a requirement for manual switchover? I guess it depends how manual the switchover is. If the switch needed to occur during off-hours, I could imagine that it might take an hour for one of the IS guys (the ones with the pagers) to respond to the monitoring notices. I'd prefer reliable automation, but it depends what it would cost us to achieve this. = If both databases go down (power failure in the facility), is it = acceptable to have: = - a few seconds dataloss? Yes that's fine. = - a manual restart sequence? Also fine, we've got good UPS, and could recover well from shortish power outages. (I'm not too worried about longer power outages...) = - a restore from last backup situation? That one sounds sketchy. Depends on the dataloss and the time to restore, I guess. Thanks again, Jamie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203040 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
