ADC

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
<!--NeedCopy-->

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
>
<!--NeedCopy-->

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>
<!--NeedCopy-->

Bind a database profile to a load balancing or content switching virtual server by using the GUI

  1. Navigate to Traffic Management > Load Balancing > Virtual Servers or Traffic Management > Content Switching > Virtual Servers, and open a virtual server.
  2. 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 (+).
Configure a database profile