View Single Post
  #3 (permalink)  
Old 01-25-2009, 02:58 PM
jack1981 jack1981 is offline
Junior Member
 
Join Date: Jan 2009
Location: HongKong
Posts: 8
Cool

Quote:
Originally Posted by swordfish View Post
jack - first, welcome to LAMP Admins, glad to have you here

For an in-depth information on MySQL Replication, the MySQL manual should be your first stop. MySQL :: MySQL 5.0 Reference Manual :: 16 Replication

However as you said you are fairly new, check out HowToForge's detailed tutorial on how to setup MySQL replication. How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials

If you are stuck on and have trouble with any part of the tutorials you can ask here
Thanks swordfish, the howtoforge article got me up and running quickly on my test servers.

However I experienced errors immediately when I started the slave server. Some duplicate key exist error, I figure why would this occur. A quick search on google turned up that to get an accurate snapshot of the server I need to shutdown the master server to replicate with which I didn't do in the first place.

I hope this helps someone who is starting with MySQL replication as well.
Reply With Quote