Every highly available application requires a highly available database, and VMware Horizon View is no exception.
The View Composer supports both Microsoft SQL Server and Oracle.
Note
Note that not all versions of vCenter support the same database versions that the View Composer does.
The following table lists the databases compatible with the View Composer and various versions of vCenter:
|
Database |
Database High Availability |
vCenter Server 6.0 |
vCenter Server 5.5 |
vCenter Server 5.1 |
vCenter Server 5.0 |
vCenter Server 4.1 |
|---|---|---|---|---|---|---|
|
Microsoft SQL Server 2014 Standard and Enterprise (32- and 64-bit) |
Yes |
Yes |
Yes |
No |
No |
No |
|
Microsoft SQL Server 2012 Express (32- and 64-bit) |
No |
Yes |
Yes |
Yes |
Yes |
No |
|
Microsoft SQL Server 2012 (SP1) Standard and Enterprise (32- and 64-bit) |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
|
Microsoft SQL Server 2008 Express (R2 SP2) (64-bit) |
No |
Yes |
Yes |
Yes |
Yes |
No |
|
Microsoft SQL Server 2008 (SP3), Standard, Enterprise, and Datacenter (32- and 64-bit) |
Yes |
No |
No |
Yes |
Yes |
Yes |
|
Microsoft SQL Server 2008 (R2 SP2), Standard and Enterprise (32- and 64-bit) |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Oracle 10g Release 2, Standard, Standard ONE, and Enterprise [10.2.0.4] (32- and 64-bit) |
Yes |
No |
No |
Yes |
Yes |
Yes |
|
Oracle 11g Release 2, Standard, Standard ONE, and Enterprise [11.2.0.3] (32- and 64-bit) |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Oracle 12C, Standard, ONE Edition, Enterprise, Release 1 [12.1.0.1.0] - 64-bit |
Yes |
Yes |
Yes |
No |
No |
No |
Note
Check out the VMware Product Interoperability Matrixes for more details:
http://www.vmware.com/resources/compatibility/sim/interop_matrix.php
With the flexibility of VMware vSphere comes multiple ways to approach High Availability for databases. We can utilize VMware High Availability to ensure that database VMs are protected in the event of host failure. We can utilize database clusters to ensure that the database is always available and to provide load balancing. We can also use active-passive configurations to provide access to the database in the event of a failure.
As with all systems, good backups of the databases are essential to get things running again in the event of a disaster.