Originally Posted by johndavis
Will all the journals, forum posts etc still be there when the problem is worked out?
I use MySQL database replication to instantaneously copy updates from the main server in Vegas to two remote computers (one server hosted in Canada, and my home workstation in California). Also, pics (which aren't stored in the MySQL database) are mirrored via a separate cronjob every minute. All data is also separately backed up to an external hard drive here at home. There are also other external hard drives which are backed up to weekly and stored in a firesafe. So even if a complete hardware failure should completely wipe out the server in Vegas, we should have multiple versions of the data in distributed geographical locations. Usually we should be looking at zero data loss, or at worst a minute's worth of pic updates.
So while the data might not still be there on the server's hard drives, it is restorable from elsewhere, probably up-to-the-minute or better.
This doesn't say how long it'll take to bring the server back up, of course - but the data itself should be ok.
Last edited by NeilGunton; 06-20-09 at 05:17 PM.