tag:blogger.com,1999:blog-9238405.post3826193725581799164..comments2024-03-18T02:04:50.380-07:00Comments on Agile Testing: MySQL fault-tolerance and disaster recovery techniquesGrig Gheorghiuhttp://www.blogger.com/profile/17863511617654196370noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-9238405.post-5256384640342742072009-07-02T06:21:51.401-07:002009-07-02T06:21:51.401-07:00While discussing fault-tolerance, you may wish to ...While discussing fault-tolerance, you may wish to think about the importance of offsite backups:<br /><br /><br />"Flight Simulator community website Avsim has experienced a total data loss after both of their online servers were hacked. The site's founder, Tom Allensworth, explained why 13 years of community developed terrains, skins, and mods will not be restored from backups: 'Some have asked whether or not we had back ups. Yes, we dutifully backed up our servers every day. Unfortunately, we backed up the servers between our two servers. The hacker took out both servers, destroying our ability to use one or the other back up to remedy the situation.'"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9238405.post-50016974153225773322009-06-15T15:31:08.193-07:002009-06-15T15:31:08.193-07:00If you're already using Amazon EC2 and happen ...If you're already using Amazon EC2 and happen to have your database on an EBS volume, then you don't need to lock your database for the time it takes to do a whole database dump with mysqldump.<br /><br />Instead, you can simply take a consistent EBS snapshot and use a new EBS volume from this to seed your slave server.<br /><br />I point out the initial steps in this process in this tutorial:<br /><br /> http://ec2ebs-mysql.notlong.com<br /><br />-- Eric HammondEric Hammondhttp://www.anvilon.comnoreply@blogger.comtag:blogger.com,1999:blog-9238405.post-65960089864623101472009-05-15T13:32:00.000-07:002009-05-15T13:32:00.000-07:00While discussing fault-tolerance, you may wish to ...While discussing fault-tolerance, you may wish to think about the importance of offsite backups:<br /><br /><A HREF="http://it.slashdot.org/article.pl?sid=09/05/15/0138204" REL="nofollow"><br />"Flight Simulator community website Avsim has experienced a total data loss after both of their online servers were hacked.</A> <I>The site's founder, Tom Allensworth, explained why 13 years of community developed terrains, skins, and mods will not be restored from backups: 'Some have asked whether or not we had back ups. Yes, we dutifully backed up our servers every day. Unfortunately, we backed up the servers between our two servers. The hacker took out both servers, destroying our ability to use one or the other back up to remedy the situation.'"</I>Anonymousnoreply@blogger.com