Of course you also know that this isn't always true, right? Depends on the corruption itself. If it is bad data that is stored well, but dangerous to the database, then of course. Naturally the best way to prevent this is in the testing phases (which is not always easy or possible to predict - and as a person who is forced into coding sometimes I absolutely refuse to comment on releasing untested code... lol). If it is physical corruption, it can be prevented from replicating, in fact it wouldn't even be possible to replicate in MS SQL as a physically corrupt database is marked down pretty quick. As for Oracle I haven't really seen it corrupt in that way. I am sure it does, I just haven't seen it..
I am kinda shocked by all the negative tone about armchairing (and the constant spite from kinwolf - what with sarcastically calling me a genius). Sorry, but IT is as much a puzzle / game as anything in BGG. There is no armchairing here, just talking strategy to better optimize the play of the game. I made it pretty clear I support and continue to support BGG even with down time I mean you have to talk about the bad things to make something good happen. People who click the "Addicts click here" button then claim to say the downtime doesn't affect them are fooling themselves. On Sunday, January 13, 2013 10:08:51 PM UTC-5, kinwolf wrote: > > When a database is corrupt, it's replica is also corrupt genius. A > failover is only useful when the actual server hosting the DB goes down. > > On Sunday, 13 January 2013 22:02:15 UTC-5, casperthegoth wrote: >> >> Well, I don't know what DB backend BGG uses. Oracle its no problem. >> >> >> http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-switchoverfailoverbest-128455.pdf >> >> Computer outage? Failover switching time: 30 seconds. And it works well, >> we have done this in several government networks. >> >> SQL has similar options not at my fingertips. >> >> On Sunday, January 13, 2013 9:29:40 PM UTC-5, kinwolf wrote: >>> >>> You work in IT and you think you can simply swap a DB with another? WOW! >>> Tell your boss to keep you away from all the servers using a DB right now! >>> >>> >>> -- You received this message because you are subscribed to the Google Groups "BGG Down" group. To view this discussion on the web visit https://groups.google.com/d/msg/bgg_down/-/Z6eP6Ah57b0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/bgg_down?hl=en.
