MySQL replication: have you done this?

[sherab]

Hi guys,
My VPS aggregates a huge amount of data and I want to replicate my VPS MySQL to a local box for client side processing of this data.
Has anyone here successfully set up replication on their VPS?

Many thanks!
Julian

[JPC-Masood]

Yes it works great. There is a step by step tutorial on MySQL website on how to setup replication.

[sherab]

Masood! How are you?!!!!! Before I respond to this question let me say that it's always a pleasure to see the hardest working man in tech.

Anyway, do you have a link to it? I have a VPS and had trouble finding some of the files to modify. Specifically I have VPS where a sub account I set up on it needs to be the master and I had a hard time locating the my.cnf (or .my.cnf) file among other things.

Should I just open a ticket detailing my angst?
As always thanks so much and again, great to see you!
Julian

[JPC-Masood]

Hi Julian,

Here is the link to the Replication chapter: http://dev.mysql.com/doc/refman/5.0/en/replication.html

The server wide my.cnf file is usually at this path /etc/my.cnf

Sure you can open a support ticket if you need a helping hand. Thanks

[impleri]

I set one up about a month ago. Just follow the guide Masood linked and it'll be fine. Very straightforward, especially if you're even vaguely familiar with playing with MySQL from the CLI.