How do I mirror a MySQL db onto another server

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Kadanis
Forum Contributor
Posts: 180
Joined: Tue Jun 20, 2006 8:55 am
Location: Dorset, UK
Contact:

How do I mirror a MySQL db onto another server

Post by Kadanis »

Basically, we have just installed a new backup server for our application/database server. I need to set up an automated mirror of the database so that everything is copied across quickly and frequently.

I'm using rSync for the files, but I wondered if anyone here can suggest an easy way of doing the database. The backup schedule needs to be something like every 5 - 15 minutes tops.

Thanks in advance
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Look up "MySQL replication". You may also want to look up "MySQL with NDB". These are cluster/redundancy techniques.
blackbeard
Forum Contributor
Posts: 123
Joined: Thu Aug 03, 2006 6:20 pm

Post by blackbeard »

Post Reply