2.0

Table Of Contents
VMware, Inc. 77
Chapter 4 Installing and Configuring the ACE 2 Management Server
Enable Database Connection Pooling If Not Already Enabled
AusefulperformanceoptimizationtipforserversonLinuxplatformsistoenable
databaseconnectionpoolingintheODBCDriverManager(itisdisabledbydefault).
To enable database connection pooling on Linux platforms
1StarttheODBCConfigutilityasarootuser.
2ClicktheAdvancedtab.
3 SelectthecheckboxforConnectionPooling.
Enablingthisoptioncangiveasubstantialperformancegainunderhighload,asthe
ACE2ManagementServercanreusethedatabaseconnectionsratherthanopening
newoneforeveryrequest.
OnWindowsplatforms,
ODBCconnectionpoolingisenabledbydefault,soyoudon’t
havetotakeanyadditionalconfigurationsteps.
Using an External Database With the ACE 2 Management Server
Appliance
TheACE2ManagementServerAppliancedoesnotcontainaPostgreSQLdatabase
server.Youmustuseanexternalservertowhichtheserverapplianceconnectsoverthe
network.Onepossibilityyoumightconsideriswhetheranapplianceversionofa
databaseserverwouldsuityoursetup.
To set up an ODBC connection to your PostgreSQL external database
1Logintotheserverapplianceconsoleasroot,usingthepasswordyoucreated
duringyourfirstrunoftheserverappliance.
2Openthe/etc/odbc.inifileinatexteditor;forexample:
vaos# vi /etc/odbc.ini
ThisfilecontainsasettingfortheODBCDSNcalledpostgres_dsn.
3 Uncommentalllinesinthepostgres_dsn fileexceptthefirsttwo(thatis,remove
theleadingʹ#ʹsymbolineachline).
4Replaceplaceholders<...>withthePostgreSQLdatabaseserverDNSnameorIP
address,andthedatabasenameinthisserver.
5IfyouhaveconfiguredyourPostgreSQLservertolistenona
nondefaultport
number,usethatportnumberintheconfiguration;otherwise,keepthedefault
portnumbersetting.
6 Savethefile.