Mysql replication server both master slave

Question

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)

score 2 · Accepted Answer · answered Jan 18 '10 at 06:20

2

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

answered Jan 18 '10 at 06:20

John Gardeniers

Thanks, I just installed mysql again using a different port. Works - no troubles so far... – Jonny Jan 18 '10 at 08:21

score 1 · Answer 2 · answered Jan 18 '10 at 07:12

1

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

answered Jan 18 '10 at 07:12

Xorlev

2 Answers2