Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 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 was marked as an exact duplicate of an existing question.

Added question here:… – Jonny Jan 18 '10 at 5:42

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.