Nov 292009
I’m currently writing an application which will be running from a MySQL backend, along with a good friend of mine. So we get to play with SVN, as well as MySQL. I’m wondering whether it would be worth setting up MySQL replication on one of the servers, as we have 2 to use if we need them. Possibly even 3.
If anybody has some good guides on how to set this up, it’d be great to hear from you, now I have my install set up to allow the test user to connect remotely, I’m looking for another mini-project to include in this larger one
Also…if you notice any DB oddities on here, please forgive me
2 Responses to “Some MySQL Fun”
Sorry, the comment form is closed at this time.

Setting up a replicated msql server is easy
Checkout this HOW-TO
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
Cheers from Uruguay
Although it’s not a tutorial, I can very much recommend the O’Reilly book “High Performance MySQL”.
Although the title doesn’t show it, the book deals with a lot of relavent mysql topics like replication, backup strategies, performance, and many more and provides a really deep insight into the workings of mysql.