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.
But I don't think the OP's requirements are at that level by the sound
of things.
-Ross
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
Thanks for all the comments and suggestions - very much appreciated.
This is a very small scale application - up to four PC's running XP
accessing what I have just been informed by the software provider will
be an SQL Express database server. This I am assured will run just fine
on an XP instance. They suggest reviving an old XP machine - TOO UGLY -
can you believe this? Don't folk think about backups, HW failures .....
Thus running on either VMware or VirtualBox will probably work okay.
All this gives me a feeling of de-ja-vu vis-a-vis QuickBooks - this app
used to work fine with a shared data file for up to five users on a
Samba share, then they "upgraded" to SQL server and performance
plummeted.......
I have some VirtualBox experience but have not yet moved into the realms
of VMware - the ESXi product looks interesting - thanks John for
pointing this one out.
How do these two virtualization systems compare wrt NIC and HDD access?
If I read correctly ESXi is actually a hypervisor and thus each OS
running will need to be allocated their own space on the HDD or I'll
have to look at setting up an iSCSI target on the CentOS VM and
accessing from the XP VM???? Have I got my head around this correctly?
The server currently has two SATA drives in software RAID1 for / and
/boot and swap partitions. All data is on a RocketRAID controller set up
with three more SATA drives as a RAID5 /dev/sdc1.
Any suggestions on least pain way forward?
Thanks
Rob
begin:vcard
fn:Rob Kampen
n:Kampen;Rob
email;internet:rob@xxxxxxxxxxxxxxxxx
tel;cell:407-341-3815
version:2.1
end:vcard
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
