up vote 2 down vote favorite
share [g+] share [fb]

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)

link|improve this question
feedback

2 Answers

up vote 2 down vote accepted

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

link|improve this answer
Thanks, I just installed mysql again using a different port. Works - no troubles so far... – Jonny Jan 18 '10 at 8:21
feedback

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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