Mysql replication, one database server process
- by Jonny
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.