Project

General

Profile

DB Worker Node Add-on » History » Version 7

Udo Offermann, 03.04.2013 15:20

1 3 Udo Offermann
h1. DB Worker Node Add-on
2 2 Udo Offermann
3 6 Udo Offermann
The *DB Worker Node Add-on* is a all-in-one-system z2 installation comprising the z2-Environment plus a database (at the moment "H2 Database Engine":http://www.h2database.com/ and "Apache Derby":http://db.apache.org/ are supported). The purpose is to have a quick and easy system setup like development or demonstration environments. Of course one can use it also for productive systems if H2 or Derby fulfills your requirements.
4 1 Udo Offermann
5 6 Udo Offermann
The add-on provides wrapper components that launches the actual database during the z2 bootstrap. Since the wrapper is launched on a separate z2 worker node (i.e. the DB Worker node) the database runs in server mode from the web applications point of view (which are running on the web worker node). 
6 1 Udo Offermann
7 6 Udo Offermann
h2. Using the DB Worker Node Add-on
8
9 7 Udo Offermann
At first you have to tell the z2-Environment where to find the DB Worker Node Add-on. Usually this is done in the _environment_ module which is used to describe the overall system setup. The file @dbWorkerAddon.properties@ attached to this page is a z2 repository component for this add-on which you can directly add to the _environment_.
10 6 Udo Offermann
11 7 Udo Offermann
The second step is to launch the DB worker in addition to the web worker (and maybe also a job worker). The so called _home layout_ is defined inside @environment/home.properties@. Attached to this page is a modified @home.properties@ that launches the DB worker and afterwards the web worker. You can simply replace the existing @home.properties@ file by this attached version or change the property manually:
12 1 Udo Offermann
13 7 Udo Offermann
<pre>
14
com.zfabrik.component.type=com.zfabrik.homeLayout
15
home.workers = com.zfabrik.db.environment/h2Worker, environment/webWorker
16
</pre>
17 3 Udo Offermann
18 7 Udo Offermann
Please note that @com.zfabrik.db.environment/h2Worker@ comes first so that the DB is up and running before the web worker is started. 
19
To use Derby instead of H2 you simply replace the @home.workers@ by
20 3 Udo Offermann
21 7 Udo Offermann
<pre>
22
home.workers = com.zfabrik.db.environment/derbyWorker, environment/webWorker
23
</pre>
24
25
The DB worker node is fully transparent to the web applications so there is no need for further changes. As usual you have to make sure that the applications on the web worker are using the corresponding JDBC drivers and database client settings (connection string, user and password etc). Also using migration tools like flyway or other automatic schema generation feature as provided by hibernate for example can be used as usual.