Configure a database profile
A database profile is a named collection of parameters that is configured once but applied to multiple virtual servers that require those particular parameter settings. After creating a database profile, you bind it to load balancing or content switching virtual servers. You can create as many profiles as you need.
Create a database profile by using the CLI
At the command line, type the following commands to create a database profile and verify the configuration:
add db dbProfile <name> [-interpretQuery ( YES | NO )] [-stickiness (YES | NO )] [-kcdAccount <string>]
show db dbProfile
Example:
> add dbProfile myDBProfile -interpretQuery YES -stickiness YES -kcdAccount mykcdaccnt
Done
> show dbProfile myDBProfile
Name: myDBProfile
Interpret Query: YES
Stickyness: YES
KCD Account: mykcdaccnt
Reference count: 0
Done
>
Create a database profile by using the GUI
Navigate to System > Profiles and, on the Database Profiles tab, configure a database profile.
Bind a database profile to a load balancing or content switching virtual server by using the CLI
At the command line, type:
set (lb | cs) vserver <name> -dbProfileName <string>
Bind a database profile to a load balancing or content switching virtual server by using the GUI
-
Navigate to Traffic Management > Load Balancing > Virtual Servers or Traffic Management > Content Switching > Virtual Servers, and open a virtual server.
-
In Advanced Settings, select Profiles and, in the DB Profile list, select a profile to bind to the virtual server. To create a profile, click plus (+).