Good disaster recovery plan for web server

vanarp

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

Dean

Does anyone have any step-by-step guides for these kinds of setup?

goexodus

Cloud, SAN, multiple cloud fail over, RAID 1010, file backups to cloud, roundrobin load balancing, IP failover, DNS clustering, anycast CDN and DDoS protection.

i guess you have deep pockets ...

mikho

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.

Romeo

DRBD and Heartbeat ?

asolar

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

Abdussamad

@vanarp said:

Wondering if there is any script that someone has already coded to handle rsync of files/directories and MySQL replication in regular intervals. Most of the websites are WP driven.

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