up vote 0 down vote favorite
share [g+] share [fb]

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.

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

1 Answer

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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