Database Cluster Configuration File

Top Previous Next

The database cluster configuration file is called database.cluster.xml. It is located in AggreGate Server installation directory.

This file defines:

•	The list of databases that will store AggreGate Server data

•	Database load balancing rules

•	Synchronization strategy for the recovered database cluster nodes

In most cases, this file should not be edited directly. Use Cluster Databases table accessible via Server Configurator utility to make changes to database cluster settings.

Configuring Database Cluster File

Here is the list of changes necessary to manually set up database replication:

•	Set the dialect attribute of <cluster> tag according to your database type:

Database Type	Attribute Value
Apache Derby	derby
Firebird, InterBase	firebird
H2	h2
HSQLDB	hsqldb
IBM DB2	db2
Ingres	ingres
Mckoi	mckoi
MySQL	mysql
MySQL MaxDB	maxdb
Oracle	oracle
PostgreSQL	postgresql
Sybase	sybase
Standard (SQL-92 compliant)	standard

•	Make sure that number of <database/> blocks matches the number of databases in the failover cluster. Add/remove blocks if necessary.

•	Assign an unique ID to every database by editing id attribute of every <database/> block.

•	Set value in every <driver> tag to the name of your JDBC driver class name. See Database Driver for details about driver class names. Also, check database-specific notes to find out where to get the driver and what is its class name.

•	Put your database driver file into /lib subfolder of AggreGate Server installation folder. Check database-specific notes for details.

•	Set the <url> tag to your database connection URL. URLs will likely be different for all databases in the cluster, since URL usually includes database server address. See Database URL and database-specific notes for details.

•	Properly set <username> and <password> tags for each database.

All databases in the cluster must use the same username/password pair for accepting AggreGate Server connections.