Previous: Up: Deploymenet OptionsNext:

Configuration and Message Monitor Storage

By default, the configuration and message monitor services uses the embedded file based Derby database. Although this simplifies an out of the box solution deployment, it has several disadvantages:

These are only a small collection of issues and it becomes obvious that an enterprise/distributed database solution is needed for a robust production solution.

The configuration service's Spring web deployment file beans.xml found in the <DIRECTHOME>/apache-tomcat-xxx/webapps/config-service/WEB-INF directory contains templates for connecting to a MySQL or Oracle database. The pattern is very similar for other database such as Postgress, so it would not take a lot of effort and Googling to figure out how to add other database implementations.

To connect to different database source, simply comment out the EMBEDDED DERBY JPA configuration sections of the beans.xml and uncomment the database configuration that you want to use. For the most part, these configurations are complete with the exception of the following properties which need to be set specific to your database deployment:

The message monitor uses a slightly different configuration option, but is essentially the same as the configuration service. The database configuration of the message monitor is in the monitor.properties file found in the <DIRECTHOME>/apache-tomcat-xxx/webapps/msg-monitor/WEB-INF/classes/properties directory. The database connection parameters are set with the following properties that you will need to update:

Other database such as Oracle allow for finer grained tuning via properties; consult your database vendor for more information.

Keep in mind that the Bare Metal deployment does not ship with drivers for other database vendors; you will need to consult your vendor (or vendor's website) to obtain the appropriate JDBC libraries. Once procured, the libraries need to be placed into the <DIRECTHOME>/apache-tomcat-xxx/webapps/config-service/WEB-INF/lib and <DIRECTHOME>/apache-tomcat-xxx/webapps/msg-monitor/WEB-INF/lib folders.

After you migrate the services to your new distributed data source, it is recommended that you consider deploying multiple instance of the tomcat server using a fault tolerant and load balance configuration (instructions are beyond the scope of this document).


Previous: Up: Deploymenet OptionsNext: