Product Documentation

Configuring 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.

To create a database profile by using the command line interface

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
>

To create a database profile by using the configuration utility

Navigate to System > Profiles and on the Database Profiles tab, configure a database profile.

To bind a database profile to a load balancing or content switching virtual server by using the command line interface

At the command line, type:

set (lb | cs) vserver \<name\> -dbProfileName \<string\>

To bind a database profile to a load balancing or content switching virtual server by using the configuration utility

  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 new profile, click plus (+).