my client wants to setup mysql replication on his servers, i am not good with it.do you have a step by step procedure? i'm fairly new to administering mysql, I just used it with my scripts. thanks - jack

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.

Glad you're up and running. Furthermore you might want to make sure that time on your master and slave servers are accurately sync'ed as this could cause inaccurate data if you are reading your slave server for backend applications. Cheers!