Job database requirements
By default, Spotfire Statistics Services relies on H2 database implementation to maintain the job queue.
- The standalone installation configures H2 in the in-process mode. This installation option requires no additional configuration, and simply works out of the box.
- The cluster installation configures H2 in the server mode. This installation option requires minor post-installation configuration.
When H2 is running in a Spotfire Statistics Services cluster (that is, in server mode), one of the managed servers is configured to run a true JDBC-compliant database, which is used by all other nodes in the cluster.
Note: H2 provides no failover capability for a
Spotfire Statistics Services cluster.
Optionally, you can use an enterprise-class database server. Spotfire Statistics Services works with the following supported enterprise-class database servers:
- Oracle (10g or later).
- Microsoft SQL Server (2005 or later).
- MySQL (5.0.89 or later).