The consolidated database (CDB) is a runtime cache database used by Unwired Server.
The CDB is a required component of Unwired Platform. By default, an embedded SQL Anywhere® database server is used as the CDB. However, during installation you can configure Unwired Server to use an existing SQL Anywhere instance as its CDB server.
If you install multiple Unwired Servers in a load-balancing cluster, all Unwired Servers in the same cluster must share a CDB; however, in this scenario, a CDB failure can introduce a single point of failure for Unwired Platform. To mitigate this risk, you can run the CDB in failover mode using a shared-disk cluster. For information about implementing server and data tier clusters with optimal redundancy, see System Administration > Systems Design.
If you choose an existing database instance as your CDB server, ensure that the database is configured to be case-insensitive; otherwise, issues with primary keys may arise during operation of Unwired Platform. In Unwired Platform, consolidated databases and client databases are configured as case insensitive by default. This configuration requires that primary keys in the datasource also be case insensitive. Otherwise, if there are two records with primary keys that just have case differences in the back-end system, they are treated as one record when loading them into the consolidated database. In this case, the second primary key overwrites the first that may exist in the consolidated database already.