The biggest issue for me is that you want your development environment to be
as identical as possible to the production environment (to avoid mistakes when
you move your application over). You don't want your production environment to
accidentally access your development data; but at the same time you want to
make sure that your development isn't accidentally playing with the "live"
Since I'm running a *AMP application, I can just use "localhost" and not worry
about forgetting to change the database name references.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>From: Johan De Meersman [mailto:vegivamp@stripped]
>Sent: Friday, March 04, 2011 6:21 AM
>To: Sid Lane
>Subject: Re: best practice: mysql_multi, VMs w/single instance per or doesn't
>Other people have answered with pros and cons of virtualisation, but I would
>rather ask another question: why do you feel it necessary to split up the
>If it's only used for QC, it's probably not in intensive use. Why would you
>through the bother of splitting it up? You're staying on the same server,
>apparently, so you'll have to decide which instance gets what part of cpu,
>memory and other resources, you'll have to provide separate backup for all
>instances, et cetera; while leaving things as they are is zero effort.
>What is the problem with the current setup that will be resolved by
>Bier met grenadyn
>Is als mosterd by den wyn
>Sy die't drinkt, is eene kwezel
>Hy die't drinkt, is ras een ezel
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1