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.

Possible Duplicate:
Mysql replication server both master slave

On my development box, I want to experiment with a replication setup. But I don't want to create several mysqld processes (is it even possible?).

I figured I have the main database in the process - have this as the master, then in the same process create the slave databases, and have the master data replicated into the databases that exist in the same db server. Is this possible? Is there an easier way of achieving this without trying to set up replication?

Maybe to put it more simply: I want my Mysql server to be both master and slave(s) at the same time.

share|improve this question

migrated from stackoverflow.com Jan 18 '10 at 19:19

This question came from our site for professional and enthusiast programmers.

marked as duplicate by splattne Apr 10 '10 at 14:14

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
Added question here: serverfault.com/questions/103669/… –  Jonny Jan 18 '10 at 5:42

1 Answer 1

Yes it is possible. Every time you launch mysql it has to read my.cnf to get the port information, socket, data files, etc. Change the port as well as the socket values. You can use the same binary with just different config files.

I had to do a setup like this one time to overcome a 2GB limitation when the client could not upgrade to a 64 bit processor. They have multiple databases, so we created them on different ports and they act individually.

share|improve this answer

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