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]
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
Copyright © Cloud Software Group, Inc. All rights reserved.