List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:March 4 2011 3:44pm
Subject:RE: best practice: mysql_multi, VMs w/single instance per or doesn't matter?
View as plain text  
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" 
data.

Since I'm running a *AMP application, I can just use "localhost" and not worry 
about forgetting to change the database name references.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com

>-----Original Message-----
>From: Johan De Meersman [mailto:vegivamp@stripped]
>Sent: Friday, March 04, 2011 6:21 AM
>To: Sid Lane
>Cc: MySql
>Subject: Re: best practice: mysql_multi, VMs w/single instance per or doesn't
>matter?
>
>
>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
>database?
>
>If it's only used for QC, it's probably not in intensive use. Why would you 
>go
>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 
>splitting?
>
>
>--
>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




Thread
best practice: mysql_multi, VMs w/single instance per or doesn't matter?Sid Lane3 Mar
  • Re: best practice: mysql_multi, VMs w/single instance per or doesn'tmatter?Reindl Harald3 Mar
    • Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter?Claudio Nanni3 Mar
      • RE: best practice: mysql_multi, VMs w/single instance per or doesn't matter?Daevid Vincent4 Mar
  • Re: best practice: mysql_multi, VMs w/single instance per or doesn't matter?Johan De Meersman4 Mar
    • RE: best practice: mysql_multi, VMs w/single instance per or doesn't matter?Jerry Schwartz4 Mar