New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
I host mostly WP sites for myself and friends. It is important for me to have recent backups but they do not have to be more frequent than daily.
i plan to try backup script provided by @dmmcintyre3 and the duplicity tutorial by @Raymii
also will be trying this tutorial to create mirror web server. will setup round-robin dns for critical sites as suggested by @KuJoe
@tchen thanks for mentioning those file sync tools and galera cluster. will explore them once i am comfortable with above stuff.
I hope this is good enough planning for DR
Does anyone have any step-by-step guides for these kinds of setup?
i guess you have deep pockets ...
I'm trying a solution where the mySQL is replicated from master to slave.
Rsync files from master to slave.
Cronjob that checks if master is alive and if not updates DNS via namecheap api.
DRBD and Heartbeat ?
rsync is a good way to back files especially your disk is small. or you have tons of files. Otherwise tar + gzip and ftp will also be a good option, as you can take full backup without afraid of missing some files
You can use rsnapshot to do this. It is very robust:
http://abdussamad.com/archives/361-Automating-incremental-backups-with-Rsnapshot.html
Doing the files is easy. Doing MySQL backups depends on whether the tables are MyISAM or InnoDB. If it's the former you can use mysqlhotcopy:
http://abdussamad.com/archives/492-MySQL-backups-with-mysqlhotcopy.html
If the tables are innodb then you can use mysqldump
http://abdussamad.com/archives/406-Backup-and-restore-MySQL-databases.html