VMware Cloud Community
RParker
Immortal
Immortal

vCenter Appliance - DB considerations

I have been doing some reading, according to what I found the embedded database is DB2.  but the appliance does NOT support external SQL / DB2 database only Oracle 10/11G are allowed.

That's not a problem, but if you want to use the embedded DB2 database (I assume this isn't the same as IBM DB2??!?) be aware that you may see people incorrectly show the support as 5 hosts / 50 VM's.

PG. 43, vCenter host / management guide (VM Ware documentation page):

embedded -
Use the embedded database. This option is available only for a small
inventory size, with fewer than 100 hosts and 1000 virtual machines.
`
Which implies you CAN use it for 100 hosts.. I know VM ware discourages embedded databases in the past, but this *IS* Linux, not the same as Windows (there are architectural differences I won't get into) so theorhetically.. this should be OK (embedded / internal DB) to use going forward.  I guess someone will have to stress test it to see what it will do.
I like the appliance for one main reason, SPEED.  The appliance configured as is with no changes, using embedded in our environment and hosting the VM on the SAN is significantly faster than vCenter running on physical hardare.  It's a LOT faster.  A LOT.
That's why I want to push to use Linux Appliance than installing vCenter (again).  I know it won't be any better.  Not blaming Windows, actually the opposite, because we have MANY apps that run great on Windows, I prefer Windows, but whoever wrote vCenter (.NET version) is shall we say.. lacking in fundamental programming techniques.
Anyway, I am only posting this so we can avoid miscommunication that seems to impeded installs...
0 Kudos
3 Replies
elspliffo
Contributor
Contributor

Hi RParker,

thanks for sharing this, this is very interesting.

People are indeed spreading the "50 vms support" information, but VMware too, considering this :

http://www.vmware.com/files/pdf/techpaper/Whats-New-VMware-vCenter-Server-50-Technical-Whitepaper.pd...

Are you actually run more than 50 vms/5 esxi hosts with a vCSA 5 vappliance/internal database ?

Thanks for your feedback

0 Kudos
AndreTheGiant
Immortal
Immortal

The 5hosts and 50 VMs is not a technical limit... you can easy have more than this number.

The problem (at least with SQL Express) is the DB size limit, that mean that if could fill faster with a lot of hosts and/or VMs.

I don't know the size limit of the embedded DB2 of VCSA...

Andre

Andrew | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
0 Kudos
pbannister
Contributor
Contributor

There is no limit on database size in DB2 Express. The limits are on the number of CPUs used (2) and the amount of memory used (2GB).

http://www-01.ibm.com/software/data/db2/express/about.html

Otherwise, this is a full-up version of IBM DB2. The old advice was for 5 hosts and 50 VMs when using Microsoft SQL Express ... but it is not at all clear that the same limits should apply to the vCSA when using the embedded DB2 Express instance. I suspect the old advice got carried over, but does not in fact apply.

A mere 5 hosts / 50 VMs sure looks like small data to me....

0 Kudos