MySQL is a great database and it has amazingly good built-in replication which helps for backups, load-balancing, performance and redundancy.

After my post yesterday with my searches in it, I got a couple emails asking how I set up MySQL replication. It's not hard, and there are some great resources out there.

Here are some references to get you started:

• The basic howto
• Setting up simple replication for backups
• A toolkit for experimenting with replication on one machine
• A perl program to measure replication performance
• Great blog on advanced MySQL stuff
• MySQL performance blog - from the performance team at MySQL, Inc.
• Jeremy Cole's replication presentation from MySQL 2006 Conference
• Jeremy Cole's blog entries on MySQL

Spend a day or two reading those and you'll be able to sprechen MySQL like an expert.

¶ 6/08/2006