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.

I am setting up a web staging environment and want to have a duplicate but separate MySQL service on the same machine. Development environments will connect to one service and staging environments will connect to another. This way when setting up a staging environment, I don't need to change database names, just the port on the MySQL server I connect to.

Is this easy and possible? I plan on manually copying the databases over to the staging environment when ready.

share|improve this question
    
This was ultimately what I ended up following: ubuntuforums.org/archive/index.php/t-1154296.html –  Kirk Nov 29 '10 at 20:42

1 Answer 1

up vote 0 down vote accepted

Yep. It's easy and possible if i understand your problem correctly.

Only use the tool that Mysql developed for this

Instance Manager

Only one thing. U can't share the databases between the 2 instances in an easy way. Seems that the server "blocks" the files it's use and the database files too. But maybe there's a workaround for that. I dont know it.

share|improve this answer
    
Do you know why they removed it in MySQL 5.5? That seems that a weird thing to remove. –  Kirk Nov 29 '10 at 15:52
1  
@Kirk Well, Have no idea. We use it in Windows, and the management tool is show as a "part" of the tray monitor. Get a lock at this URL.dev.mysql.com/doc/administrator/en/… –  Carlos Nov 30 '10 at 11:09

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.