Another trick on doing MySQL Backup

Here is a trick on how to do backups on a very busy server (lots of writes and reads) without taking the server down.

http://www.howtoforge.com/back_up_mysql_dbs_without_interruptions

The trick is:

1. Create a second MySQL Server for replication.

2. Schedule the backup using cron / mysqldump on the replicated server.

A very logical solution indeed!