2.5

Table Of Contents
ACE Management Server Administrator’s Manual
16 VMware, Inc.
Database Options
ACEManagementServeroffersthefollowingdatabaseoptions:
EmbeddedSQLitedatabaseThedefaultmodeofACEManagementServer
workswithanembeddedSQLite3databaseengine.TheSQLitedatabaseengineis
initializedduringserverinstallationandrequiresnospecialconfiguration.
The embeddeddatabasesupportsuptoseveralgigabytesofdata.
TheSQLitedatabaseisfilebasedandisnot
designedtobeeffectivelysharedacross
multipleprocesses.Ifyouusethirdpartytoolstoaccessthedatabaseforaread
operation,therefore,youcannotdependontransactionalisolationofthepending
writeoperationsoftheACEManagementServer.
Theembeddeddatabaseisadequatefortestingpurposes,butVMware
recommendsthat
youuseanexternaldatabaseinproductionenvironments.
SupportedexternaldatabaseInproductionenvironments,useasupported
externaldatabaseasabackingstoreforACEManagementServer,throughODBC
connectivity.Supportedexternaldatabaseenginesarethefollowing:
OnWindows,MicrosoftSQLServer(SQLServer2000orSQLServer2005)and
OracleDatabase10g
OnLinux,PostgreSQL7.4orhigher
UsinganexternaldatabasewithACEManagementServeroffersthefollowing
benefits:
OnlinebackupsothatyoudonothavetoshutdownACEManagementServer
tobackupthedatabase.
Enhancedsecuritymodel.Youcanfinetunepermissionstoaccesssensitive
data.TheSQLitedatabaseengineprovidesfilesystembasedsecurity.
Performancefinetuning.
Abilitytouseexternaldatabasemanagementandreportingtools.
AbilitytouseloadbalancerswithmultipleACEManagementServer
instances.YoumustuseanexternalRDBMSasthebackingstore,becausethe
SQLitedatabaseisnotdesignedtobeeffectivelysharedacrossmultiple
processes.
N
OTEIfACEManagementServerisdeployedintheDMZ,useanexternal
databaselocatedinsideyourcorporatenetworkbehindafirewall.