AgileApps Support Wiki Pre Release

Difference between revisions of "Configuring the Quartz Scheduler"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(3 intermediate revisions by the same user not shown)
Line 3: Line 3:
{{Important|
{{Important|
* Quartz must be enabled on at least one platform instance, or the platform won't run.
* Quartz must be enabled on at least one platform instance, or the platform won't run.
* It is recommended that you run Quartz on the back-end servers to avoid any performance issues in the front-end servers.
* If you have multiple instances, Quartz should run on only one of them, ''unless'' you follow the Quartz clustering instructions below.
* If you have multiple instances, Quartz should run on only one of them, ''unless'' you follow the Quartz clustering instructions below.
* Changing the quartz configuration requires a restart of all Application Servers.}}
* Changing the quartz configuration requires a restart of all Application Servers.}}
Line 8: Line 9:
=====Enabling Quartz on a Platform Instance=====
=====Enabling Quartz on a Platform Instance=====


:1. Enable qrtz_manager_instance = 1. This is available at <tt>{install_dir}/profiles/LJP/configuration/tomcat/conf/RN/networking.properties</tt>
:1. Enable qrtz_manager_instance = 1. This is available at <tt>{install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/networking.properties</tt>
:2. Edit <tt>{install_dir}/profiles/LJP/configuration/tomcat/conf/RN/AALSchedulers.xml</tt>
:2. Edit <tt>{install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/AALSchedulers.xml</tt>
:3. Modify the quartz servlet mapping so that:
::a. The <tt>config-file</tt> parameter points to the Quartz properties file:<br/> <tt>{install_dir}/profiles/LJP/configuration/tomcat/conf/RN/quartz.properties</tt>
::b. The <tt>start-scheduler-on-load</tt> property is set to <tt>true</tt>, to make sure that quartz is started whenever the platform starts.


::Example:
::{| width="60%"
<pre>
<servlet>
    <servlet-name>
        QuartzInitializer
    </servlet-name>
    <display-name>
      Quartz Initializer Servlet
    </display-name>
    <servlet-class>
        org.quartz.ee.servlet.QuartzInitializerServlet
    </servlet-class>
    <init-param>
        <param-name>config-file</param-name>
        <param-value>C:/apache-tomcat-6.0.20/conf/RN/quartz.properties</param-value>
                        [ ^-- Path to the properties file ]
    </init-param>
    <init-param>
        <param-name>shutdown-on-unload</param-name>
        <param-value>true</param-value>
    </init-param>
    <init-param>
        <param-name>start-scheduler-on-load</param-name>
        <param-value>true</param-value>
                    [ ^--Enables Quartz ]
    </init-param>
    <load-on-startup>
        1
    </load-on-startup>
</servlet>
</pre>
|}
{{Note| Do not change the value of <tt>org.quartz.scheduler.instanceName property</tt>.}}
:3. Edit <tt>{install_dir}/profiles/LJP/configuration/tomcat/conf/RN/quartz.properties</tt>
:4. Add the following information:
:4. Add the following information:
::a. Database user name (an admin user)
::a. Database user name (an admin user)
Line 63: Line 18:
::{|
::{|
<pre>
<pre>
org.quartz.dataSource.myDS.URL = jdbc:mysql://...
<attribute name="org.quartz.dataSource.myDS.URL" value="jdbc:mysql:"/>
 
<attribute name="org.quartz.dataSource.myDS.user" value=""/> -- root user
org.quartz.dataSource.myDS.user = rootuser                [database user]
<attribute name="org.quartz.dataSource.myDS.password" value=""/> -- password
 
org.quartz.dataSource.myDS.password = password       [database user password]
</pre>
</pre>
|}
|}
{{Note| Do not change the value of <tt>org.quartz.scheduler.instanceName property</tt>.}}


=====Moving Quartz to Another Platform Instance=====
=====Moving Quartz to Another Platform Instance=====
Line 75: Line 29:
Suppose you have one application server instance, and you have decided to add another to handle the traffic volume. And let's say you also decide to move quartz to the new instance, to further reduce the load on the original server. To that, you disable Quartz on the first instance, and start it on the second.
Suppose you have one application server instance, and you have decided to add another to handle the traffic volume. And let's say you also decide to move quartz to the new instance, to further reduce the load on the original server. To that, you disable Quartz on the first instance, and start it on the second.


:1. Disable qrtz_manager_instance = 0. This is available {install_dir}/profiles/LJP/configuration/tomcat/conf/RN/networking.properties
:1. Disable qrtz_manager_instance = 0. This is available {install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/networking.properties
:2. For the second instance, follow the steps above, in [[#Setting up Quartz on a Platform Instance|Setting up Quartz on a Platform Instance]]
:2. For the second instance, follow the steps above, in [[#Setting up Quartz on a Platform Instance|Setting up Quartz on a Platform Instance]]


Line 81: Line 35:
By default, Quartz is pre-configured to run as a cluster of instances running on different servers. To run successfully, however, each server must have the settings shown here. Otherwise, a Quartz instance will not know that the others exist, and will not lock job records that are in progress. Perform this configuration on any server you later add to the cluster.
By default, Quartz is pre-configured to run as a cluster of instances running on different servers. To run successfully, however, each server must have the settings shown here. Otherwise, a Quartz instance will not know that the others exist, and will not lock job records that are in progress. Perform this configuration on any server you later add to the cluster.


:1. Open <tt>{install_dir}/profiles/LJP/configuration/tomcat/conf/RN/AALSchedulers.xml</tt>
:1. Open <tt>{install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/AALSchedulers.xml</tt>
:2. Check this line:
:2. Check this line:
::{|
::{|

Latest revision as of 11:26, 16 October 2019

Warn.png

Important:

  • Quartz must be enabled on at least one platform instance, or the platform won't run.
  • It is recommended that you run Quartz on the back-end servers to avoid any performance issues in the front-end servers.
  • If you have multiple instances, Quartz should run on only one of them, unless you follow the Quartz clustering instructions below.
  • Changing the quartz configuration requires a restart of all Application Servers.
Enabling Quartz on a Platform Instance
1. Enable qrtz_manager_instance = 1. This is available at {install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/networking.properties
2. Edit {install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/AALSchedulers.xml
4. Add the following information:
a. Database user name (an admin user)
b. Password for that user
Example:
<attribute name="org.quartz.dataSource.myDS.URL" value="jdbc:mysql:"/> 
<attribute name="org.quartz.dataSource.myDS.user" value=""/> -- root user
<attribute name="org.quartz.dataSource.myDS.password" value=""/> -- password

Notepad.png

Note: Do not change the value of org.quartz.scheduler.instanceName property.

Moving Quartz to Another Platform Instance

Suppose you have one application server instance, and you have decided to add another to handle the traffic volume. And let's say you also decide to move quartz to the new instance, to further reduce the load on the original server. To that, you disable Quartz on the first instance, and start it on the second.

1. Disable qrtz_manager_instance = 0. This is available {install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/networking.properties
2. For the second instance, follow the steps above, in Setting up Quartz on a Platform Instance
Setting up a Quartz Cluster

By default, Quartz is pre-configured to run as a cluster of instances running on different servers. To run successfully, however, each server must have the settings shown here. Otherwise, a Quartz instance will not know that the others exist, and will not lock job records that are in progress. Perform this configuration on any server you later add to the cluster.

1. Open {install-dir}/profiles/IS_default/configuration/tomcat/conf/RN/AALSchedulers.xml
2. Check this line:
<attribute name="org.quartz.scheduler.instanceId" value="AUTO"          [VERIFY THIS LINE]
3. Under # Configure JobStore, check these lines:
...
# Configure JobStore
<attribute name="org.quartz.jobStore.misfireThreshold" value="60000"/>          [VERIFY THESE LINES]
<attribute name="org.quartz.jobStore.isClustered" value="true"/>
<attribute name="org.quartz.jobStore.clusterCheckinInterval" value="20000"/>

In addition, MySQL must be configured to set the appropriate transaction-isolation level and to specify row-based replication:

  1. Edit {MYSQL_INSTALLATION}/my.cnf
  2. Use the following settings:
transaction-isolation = READ-COMMITTED
binlog-format = ROW