On Tue, Sep 08, 2009 at 02:04:35PM -0400, Ross Walker wrote:
> On Tue, Sep 8, 2009 at 1:57 PM, Pasi Kärkkäinen<pasik@xxxxxx> wrote:
> > On Tue, Sep 08, 2009 at 10:22:56AM -0700, John R Pierce wrote:
> >> Rob Kampen wrote:
> >> > One of my clients use a software product that is "upgrading" and will
> >> > shortly utilize micro$oft SQL server 2005.
> >> > Currently the clients are XP on older machines with the database
> >> > residing on a Samba / CentOS server and this works very well.
> >> > Question: Does anyone run SQL server from XP in a virtualbox on CentOS?
> >> > Any other configuration that works on a linux server?
> >> > I do not want to have to buy another server grade machine just for
> >> > this application.
> >>
> >> SQL Server only runs on Windows SERVER OS's. on a desktop OS like XP,
> >> youc an only run the 'lite' version aka MSDE or SQL Express depending on
> >> which version, and this only allows a very few database connections, and
> >> is mostly suited for standalone single user applications and software
> >> development.
> >>
> >> SQL Server has fairly expensive licensing per user too.
> >>
> >> I would NOT virtualize a SQL database server, they have intensive disk
> >> IO I/O requirements. also don't run a database on a network mounted
> >> file system (samba, NAS, etc) for the same reason.
> >>
> >
> > I've been running various MSSQL databases on VMware VMs without problems..
> > of course you need to have fast enough disks (or a SAN).
> >
> > Also I've been running Oracle, Mysql and PostgreSQL databases on
> > Xen virtual machines for years without problems.
> >
> > It all depends on your CPU and/or IO requirements.. if you need all the
> > possible resources, then virtualization is not a good thing.
>
> Actually $$$ can overcome that.
>
> I know serveral high transaction SQL implementations running off of
> ESX going to either FC 3Par or EMC systems.
>
Yeah and I know some such setups using Equallogic iSCSI storage :)
> But I don't think the OP's requirements are at that level by the sound
> of things.
>
Yep.
-- Pasi
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
