2

I have a mysql db in my box. Can I replicate it to another db on the same box?

ie, the same box would be both master and slave(s).

Are there other ways of achieving this? (I'm thinking pointers/references, because it's in the same db system)

2 Answers 2

2

Yes, you can. Just run each instance on a different port.

1
  • Thanks, I just installed mysql again using a different port. Works - no troubles so far...
    – Jonny
    Jan 18, 2010 at 8:21
1

Just need different data dirs/sockets, etc. so different my.cnf's.

You must log in to answer this question.

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