Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

It seems so simple: I have two servers running MySQL, one has a nice big database of important stuff, the other is an empty shell ready to be used as a replication slave. These are the steps I should need to take to set up replication:

  1. Add a user to the master with the relevent replication & host privileges
  2. Run a statement from the slave telling it to 'replicate this db from this server'
  3. Done. That's it.

Instead I have to mess around with my.cnf settings on both servers, mess about with binary logs and positions and snapshots. Yes I know some of these things are optimisations for large databases but is this the best way they could think of doing this? I just want to replicate a database, this is a very common practice. I still have not managed it.

Where can I find a decent how-to for this? Everything I've found so-far is either missing some important step, is written for an older version of MySQL or is just plain too complex for me or requires a degree of commitment I'm clearly not prepared to take, and that includes the official documentation.

share|improve this question
    
Please watch your language. –  Antoine Benkemoun Feb 15 '10 at 14:37
    
Sorry, MySQL makes me angry –  Jimmy Feb 15 '10 at 14:39
5  
Have you considered other DB engines, careers or counselling? –  Chopper3 Feb 15 '10 at 14:50
3  
@chaopper3 - awesome edit of the original post. +1 –  Coops Feb 15 '10 at 15:08
1  
I'm here all week, try the chicken :) –  Chopper3 Feb 15 '10 at 15:31

2 Answers 2

I bought the book titled "High Performance MySQL" by Schwartz, Zaitsev, Tkachenko, et al.

I have also used Slony on PostgreSQL. Wasn't straightforward, either.

Master-master replication seems a good idea.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.