Database Store Settings

Classic Configuration

Stores are configured in the stores.conf file. The syntax for database stores is:

[store_name] # mandatory -- square brackets included.
  type = dbstore
  dbstore_driver_url = JDBCURL
  dbstore_driver_username = username
  dbstore_driver_password = password
  [processor_id = processor-id]
Note: Note that the square brackets [ ] DO NOT indicate that the store_name is an option; they must be included around the name.

Example Using MySQL Server

[$sys.failsafe]
  type=dbstore
  dbstore_driver_url=jdbc:mysql://mysqlsrv_1:3306/sysfs
  dbstore_driver_username=admin
  dbstore_driver_password=admin123

[$sys.meta]
  type=dbstore
  dbstore_driver_url=jdbc:mysql://mysqlsrv_1:3306/sysmeta
  dbstore_driver_username=admin
  dbstore_driver_password=admin123

Example Using Microsoft SQL Server

[$sys.meta]
  type=dbstore
  dbstore_driver_url=jdbc:sqlserver://sqlsrv_1:3415;databaseName=sysmeta
  dbstore_driver_username=admin
  dbstore_driver_password=admin123

[$sys.failsafe]
  type=dbstore
  dbstore_driver_url=jdbc:sqlserver://sqlsrv_1:3415;databaseName=sysfs
  dbstore_driver_username=admin
  dbstore_driver_password=admin123

Example Using Oracle 10g

[$sys.meta]
  type=dbstore
  dbstore_driver_url=jdbc:oracle:thin:adminmeta/admin123@osrv_1:1521:orclperf
  dbstore_driver_username=adminmeta
  dbstore_driver_password=admin123

[$sys.failsafe]
  type=dbstore
  dbstore_driver_url=jdbc:oracle:thin:adminfs/admin123@osrv_1:1521:orclperf
  dbstore_driver_username=adminfs
  dbstore_driver_password=admin123

Example Using Oracle RAC 10g

[$sys.failsafe]
  type=dbstore
  dbstore_driver_url=jdbc:oracle:oci:<user>/<passwd>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host1>)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=<host2>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))
  dbstore_driver_username=admin
  dbstore_driver_password=admin123

Example Using IBM DB2 Server

[$sys.meta]
  type=dbstore
  dbstore_driver_url=jdbc:db2://db2srv_1:50000/SYSMETA
  dbstore_driver_username=admin
  dbstore_driver_password=admin123

[$sys.failsafe]
  type=dbstore
  dbstore_driver_url=jdbc:db2://db2srv_1:50000/SYSFS
  dbstore_driver_username=admin
  dbstore_driver_password=admin123

Administration

View Stores
show store store-name
Show the details of a specific store. This command can be used to get details about either a file-based store or a database store.
The store-name must be the exact name of a specific store.