dbTalk Databases Forums  

[Info-Ingres] Virtualisation vendor

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] Virtualisation vendor in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default [Info-Ingres] Virtualisation vendor - 07-21-2011 , 05:19 AM






Hi All,

Currently we ar eusing VMWare to do the virtualisation...but they are starting to gouge us for License fees. The question becomes are there other VM vendors out there and does Ingres run on their stuff?

Of specific interest has been something called Hyper-V. Does anyone know anything about this?

Marty

Reply With Quote
  #2  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Virtualisation vendor - 07-21-2011 , 08:48 AM






I use VirtualBox for all my Linux and Windows based VMs. It is
(supposedly) less capable for datacenter use than VMware but I have no
personal experience in VirtualBox in datacenters. Depends on what you
are using virtualization (virtualisation? ;-) for.


--
daryl.monge (AT) ingres (DOT) com
------------------------------------------------------------------------
daryl.monge (AT) ingres (DOT) com's Profile: http://community.ingres.com/forum/member.php?userid=736
View this thread: http://community.ingres.com/forum/sh...ad.php?t=13518

Reply With Quote
  #3  
Old   
Armand Pirvu (gmail)
 
Posts: n/a

Default Re: [Info-Ingres] Virtualisation vendor - 07-21-2011 , 09:08 AM



IMO each has pros and cons

I use both VMWare and VirtualBox

No preference really with one exception

VMWare you need to do some hacking (a big word but still hacking and not supported) for clustering, whereas in VirtualBox this is native and it is easy .



On Jul 21, 2011, at 8:48 AM, Ingres Forums wrote:

Quote:
I use VirtualBox for all my Linux and Windows based VMs. It is
(supposedly) less capable for datacenter use than VMware but I have no
personal experience in VirtualBox in datacenters. Depends on what you
are using virtualization (virtualisation? ;-) for.


--
daryl.monge (AT) ingres (DOT) com
------------------------------------------------------------------------
daryl.monge (AT) ingres (DOT) com's Profile: http://community.ingres.com/forum/member.php?userid=736
View this thread: http://community.ingres.com/forum/sh...ad.php?t=13518

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Reply With Quote
  #4  
Old   
Chris
 
Posts: n/a

Default Re: Virtualisation vendor - 07-21-2011 , 11:28 AM



On Jul 21, 3:19*am, Martin Bowes <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:
Quote:
Currently we ar eusing VMWare to do the virtualisation...but they are starting to gouge us for License fees. The question becomes are there other VMvendors out there and does Ingres run on their stuff?

Of specific interest has been something called Hyper-V. Does anyone know anything about this?
What platform(s) are you hosting? And what platform is VMware being
run on?

I can't think of a a good ESX equivalent. Vbox has already been
mentioned if you want a VMware server/player equivalent.

If you are only using Linux for the guest there are other options that
are (relatively) native, e.g. Xen, KVM, etc.

http://virt.kernelnewbies.org/ has some nice short and easy to read
high level summaries.

It all boils down to management tools in the end though.

Reply With Quote
  #5  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Virtualisation vendor - 07-22-2011 , 02:40 AM



At work we use XEN (Citrix) and have few installations of Ingres 10
(community edition).
At home I run KVM for "toy" VMs and run latest Ingres version. So, I
can confirm that Ingres works perfectly on both KVM (my recommendation)
and XEN.


--
dejan

Reply With Quote
  #6  
Old   
Martin Crouch
 
Posts: n/a

Default Re: [Info-Ingres] Virtualisation vendor - 07-22-2011 , 03:52 AM



What's performance like running an Ingres DBMS server in a VM?

We've been tending to shy away from virtualising our production DBMS
servers as their performance bottleneck is mostly due to IO (rather than
CPU or memory).

The VMs I've seen tend to have a massive single "disk file" so you
don't get the ability to put the log on a separate spindle to the data
like you can with a physical host. Or are there solutions to this?

Reply With Quote
  #7  
Old   
Michael Dyer
 
Posts: n/a

Default Re: [Info-Ingres] Virtualisation vendor - 07-22-2011 , 04:32 AM



Hi Martin,
I have experience only with VMWare, but with that I have successfully
created a test rig for failover in a cluster, where the Ingres binaries
were located in the virtual 'local' disks of the 3 nodes of the virtual
cluster, but the data was in a 'common' disk.

I was interested only in specific aspects of demonstrating failover, but
this shows that it is possible to have multiple partitions accessible
from a virtual system.

I agree with your reservations about performance.

This is a great way of having multiple environments on one hardware
system, but I have experience of being unable to show a client's problem
in a virtual system, but was able to show the problem in a non-virtual
system with nominally fewer resources.

Maybe I could have tweaked the virtual configuration to get better
performance, but I needed to get the client problem fixed fast.

Michael

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Crouch
Sent: 22 July 2011 09:52
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] Virtualisation vendor

What's performance like running an Ingres DBMS server in a VM?

We've been tending to shy away from virtualising our production DBMS
servers as their performance bottleneck is mostly due to IO (rather than

CPU or memory).

The VMs I've seen tend to have a massive single "disk file" so you
don't get the ability to put the log on a separate spindle to the data
like you can with a physical host. Or are there solutions to this?
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.