The core application database supports the following: Microsoft SQL, Oracle,
Postgres, and MySQL.
Note: All of the database information here assumes that you have successfully
deployed your database system of choice in an HA configuration, ensuring that the
database server itself is not a single point of failure.
CAUTION:
You may choose to configure redundant
databases and replicate data between them. Jive Software does not
provide database replication configuration or support. Your data center and/or DBA team
must provide database support for you and your configuration. We have seen customers successfully
deploy Oracle RAC and SQL server HA configurations with Jive.
Location of the Web Applications' Database Configuration Information
The web application database configuration information is stored on the web
application nodes in an XML file that lives in Jive home (usually
/usr/local/jive/applications/[name of your application]/home/jive_startup.xml. To
learn how to set up the core application database string on the web application
nodes, see Configuring
the Web Application Servers for High-Availability. For more on what must
be persisted in the core application database during a disaster recovery, see Restoring the Database
With Persistent Properties.
Supported Core Application Databases
- Microsoft SQL Server
Jive supports the JTDS database driver for communication between the Jive
instance and Microsoft SQL Server. While Jive does not specifically perform load or
functional tests against Microsoft SQL Server in a cluster/failover configuration,
the JTDS driver does appear to support SQL Server clustering.
Jive does not currently support the Microsoft JDBC driver. Jive is aware of and is
actively working with customers who have deployed Jive in an HA configuration using
Microsoft SQL Server.
- Oracle
- Jive supports the OCI database driver for both the core web application and the
Activity Engine application, which is supported by Oracle with their Oracle RAC
database system deployments. While Jive does not specifically perform load or
functional tests against an Oracle in a RAC cluster/failover configuration, the OCI
driver does appear to support Oracle RAC. Jive is aware of and is actively working
with customers who have deployed Jive in an HA configuration using Oracle RAC.
- Postgres
- Jive supports Postgres 8 and Postgres 9. The latest version of Postgres, version
9, supports two different types of high availability: hot standby/streaming
replication and warm standby/log shipping which, in theory, would allow for
transparent and automatic failover, assuming there is a way to automatically
redirect all traffic from the live production database server to the hot standby
backup server. Jive Software is not aware of any customers who have deployed against
a Postgres instance configured in this manner. If a mechanism exists for failing
over a database server from one node to another, or from one data center to another,
without disrupting the web application nodes, Jive will support the
configuration.
- MySQL
- Similar to Postgres, there are multiple ways of deploying a highly available
MySQL database system. Also similar to Postgres, Jive Software is not aware
of any customers who have deployed against a MySQL instance configured in
this manner. If a mechanism exists for failing over a database server from
one node to another, or from one datacenter to another, without disrupting
the web application nodes, Jive will
support the configuration.