Citrix ADC

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  [-interpretQuery ( YES | NO )] [-stickiness (YES | NO )] [-kcdAccount ] 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 toSystem > Profilesand, on theDatabase Profilestab, configure a database profile.

结合数据库负载均衡或者配置文件content switching virtual server by using the command line interface

At the command line, type:

set (lb | cs) vserver  -dbProfileName  

结合数据库负载均衡或者配置文件content switching virtual server by using the configuration utility

  1. Navigate toTraffic Management > Load Balancing > Virtual Servers or Traffic Management > Content Switching > Virtual Servers, and open a virtual server.
  2. InAdvanced Settings, selectProfilesand, in theDB Profilelist, select a profile to bind to the virtual server. To create a new profile, click plus (+).