Brian Beesley wrote: > On Thursday 05 January 2006 22:57, [EMAIL PROTECTED] wrote: >> Decentrializeing the >> server might work but splitting the database into 256 parts would not >> if you lost a harddisk and the system was unrecoverable then you >> would be out part of the data. > > Not necessarily. Why doesn't each server become a backup for databases > stored on a different server. If the database is snapshotted on a > daily basis then the effects of an unrecoverable loss would be > minimal. In any case the converse situation - unrecoverable loss on a > single server - is surely worse.
MySQL does a fairly good job with replication between two or more mysql instances. I have no experience in replicating between geographically distributed servers, but there's no real reason why it shouldn't work just fine. /Per Jessen, Zürich -- http://www.spamchek.com/ - managed anti-spam and anti-virus solution. Let us analyse your spam- and virus-threat - up to 2 months for free. _______________________________________________ Prime mailing list [email protected] http://hogranch.com/mailman/listinfo/prime
