3

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.

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

2 Answers 2

2

Give this a try:

http://www.howtoforge.com/mysql_database_replication

1

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .