Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm fairly new to databases so I hope this isn't a silly question!

Is it possible to set up master/slave replication on the SAME server?

I understand there are not any advantages to this in terms of hardware utilisation/recovery purposes, but a set up like this would help test a piece of software I am developing.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

It's possible, why not. You have to run two instances of MySQL. One will be a master, second - a slave.

Check this for detailed instructions https://dev.mysql.com/doc/refman/5.5/en/multiple-servers.html

share|improve this answer
    
I thought about that, but I was concerned about potential conflicts. Thanks for your help! –  user279171 Feb 19 at 13:41

The best way to setup replication for testing purpose on a local machine is to use MySQL Sandbox very easy to setup and manage multiple Master-Slave and different replication methods.

http://mysqlsandbox.net/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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