Diagram
Strategy
- What to Backup?
- How Many Backups?
- Where Do You Backup?
- Disaster Recovery: Tornadoes, Earthquakes and Hellfire
What to Backup? Data.
- Posts & Pages: database contents
- Need to 'dump' database to a file
- Codex has recipes for phpMyAdmin and many ISPs
- Some plugins will also do this
What to Backup? Files.
- Files on disk: Wordpress code, themes, uploads
- Many hosts offer backups of these
- Test; time them on a restore. 3 days OK?
- Recognize problem might be ISP down.
- Alternative: save before you upload
How Many Backups?
- Thumbrule: three, plus-or-minus two
- Judge based on activity level,
- the cost of losing a post,
- the cost of rebuilding from scratch
- Location, location, location: off-site
- Automate or automate reminder (calendar)
Where Do You Backup?
- On same machine for fast restore
- On separate machine for computer crash
- Separate ZIP code for outages
- Different time zone for disasters
How Crazy Do You Go?
- Evaluate cost v. risk
- Simple solutions are often sufficient.
- Be realistic about cost (in time and effort) and dedication
- Automated solutions are great, but need to be monitored
- At a minimum, make a backup now and before each update
Disaster Recovery
- Murphy's Law: Anything that can go wrong will.
- Anything that can't, will, too.
- O'Toole's Rule: Murphy was an optimist.
- Two-plus things will always go wrong
- That's what distinguishes disasters from Mondays
- It's not a 'Perfect Storm.' Get over yourself.
Disaster Recovery
- Hot/warm/cold standby strategies
- Google might mistake for 'splogging'
- DNS Issues: content's great, but people have to find it
- Fireproof safes are usually good for paper NOT MEDIA
- Fahrenheit 451?
Backing up your own machine (batch,shell,cron)
$cat bin/blog.tedroche.com.backup.sh
#! /bin/sh
# Dump the Database, overwriting the previous SQL if exists
mysqldump -u wordpress-user -pXXXXxxXXXXxxxXXXxxx ↵
--skip-lock-tables wordpress ↵
> ~/blog.tedroche.com.sql
# Compress the SQL, forcing an overwrite
gzip --force /home/troche/blog.tedroche.com.sql
# Send the file
scp ~/blog.tedroche.com.sql.gz ftp.tedroche.com:
Backing up your own machine: files
cd /var/www/html
tar cvzf ~/blog.tedroche.com.20110408.tgz blog.tedroche.com/
See the man page for more options like --exclude and --exclude-file
Thank you!
Questions?
- Presentation at http://www.tedroche.com/papers.html
This document was edited with ViM, http://www.vim.org/ on Linux (also available on OSX, Windows and other fine platforms. Interoperability is Good.
The templates for the document and instructions on their use are the Simple Standards-based Slide Show System, S5 developed by Eric Meyer and available at http://www.meyerweb.com/eric/tools/s5/ under a Creative Commons license. Thanks, Eric!
About the presenter:
Ted Roche learned to program BASIC on a PDP-4 at the age of 15. He was conferencing and IM'ing on the Dartmouth Time Sharing System in the late 1970s. (IM and chat rooms are old. So's Ted.) He shipped his first commercial app in 1978, which ran on a WANG 2200. His first public domain software was a quad-density Epson printer driver for the Commodore 64 GEOS operating system, hand-coded in 6502 assembler. Amigas were his favorite computers, although PCs are getting better. He ran the electrical plant on a nuclear-powered ballistic missile submarine until the Russians gave up, and then there wasn't any challenge in it any more. He has coded with "ohs." (requisite obscure Dilbert reference)
Since 1987, Ted has worked fulltime as a software developer. He has worked for state agencies, insurance companies and consulting firms. He established Ted Roche & Associates on July 4, 2001 . Ted Roche & Associates, LLC develops Web, client-server and LAN-based applications using Ruby on Rails, Python, PHP, Apache, Linux, MySQL, PostgreSQL, Microsoft Visual FoxPro, and other best-of-breed tools. Based in New Hampshire, his company offers consulting, training and mentoring, on-site and long-distance, as well as software development services. Ted is author of Essential SourceSafe, co-author of the award-winning Hacker's Guide to Visual FoxPro series, and a contributor to six other FoxPro books and author of numerous magazine articles. He's a popular speaker at conferences worldwide. Ted is a Microsoft Certified Solution Developer, Microsoft Certified System Engineer, and nine-time winner of the Microsoft Support Most Valuable Professional award. He's earned MySQL certification twice: the Core certification for MySQL 4.x and the Certified Developer certification for 5.x. He was recently recognized by the ACM and inducted as Senior Member.
Ted has worked with Linux since 1999. The Ted Roche & Associates, LLC intranet and extranet run on Apache, Ruby on Rails, PHP, Python, WebMin, MySQL, PostgreSQL and other LAMP applications. Ted's office automation tools include OpenOffice.org, FireFox, Thunderbird, Camino, SciTE, git, Subversion, CygWin, PuTTY, WinSCP and OS X Tiger. In 2005 and 2006, he was one of the team teachers for the LAMP certificate at the New Hampshire Technical Institute's Center for Training and Business Development (http://www.nhti.edu/ctbd) along with Bruce Dawson, Bill Sconce and David Berube. He is the former Fearless Leader and chair of the board (2006-9) of the Greater New Hampshire Linux User Group (http://www.gnhlug.org) and continues to be a LAMP activist with the Central New Hampshire Linux User Group (http://www.centralug.org).
The most current contact information for Ted can be found at http://www.tedroche.com
This work is licensed under a Creative Commons Attribution 2.5 License.