Database Cluster Configuration File

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

This file defines:

  • The list of databases that will store Iotellect 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 a unique ID to every database by editing id attribute of every <database> block.
  • Set location attribute in each <database> block. 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 Iotellect Server connections.

If PostgreSQL is used as Iotellect Server's database engine you need to add the following properties to the Database URL:

"tcpKeepAlive=true&amp;networkTimeout=60&amp;socketTimeout=60&amp;loginTimeout=60&amp;connectTimeout=60&amp;cancelSignalTimeout=60".

Timeouts are set in seconds.

Was this page helpful?