Page History

The DataSync for ServiceNow Agent supports Perspectium DataSync Agents support an “exclusive consumer” mode that provides a Highly Available (HA) Agent solution while maintaining the order of messages in a queue. This active-passive HA Highly Available approach will exclusively allow only one DataSync Agent to actively read messages from a queue. Other DataSync Agents will that passively try to connect to the queue and will only be given access to the queue if another DataSync Agent is no longer connected.

The Agent uses DataSync Agents use the queue in the message connection and locks that queue for exclusive use. If multiple tasks are made using the same message connection, only one subscriber task will be created and used. When running a backup another DataSync Agent, a warning will be logged in the perspectium.log file indicating that the queue is in exclusive use and that consumer wait time will be increased (default is to increase to 30 seconds). Once the first running DataSync Agent is stopped or fails, the backup DataSync Agent will start consuming messages when the queue becomes available and the consumer wait time will be reset.

 NOTE: The Highly Available Agent is only available when your DataSync for ServiceNow Agent is set to connect to the Perspectium Mesh via the AMQP/AMQPS protocol (HTTP/HTTPS are is not supported).

Prerequisites

 First, you will need to install the DataSync for ServiceNow Agentset up one of the Perspectium DataSync Agents.

 You should also stop running your DataSync Agent before making any Agent configuration changes.

Procedure

To configure your DataSync for ServiceNow Agent to run as a Highly Available Agent, follow these steps:

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
    <config>
     <agent>

        <max_reads_per_connect>2000</max_reads_per_connect>
       	<polling_interval>15</polling_interval>

        <subscribe>
            <task>
                <task_name>ticket_table_replication</task_name>
                <polling_interval>30</polling_interval>

                <handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
                <decryption_key>The cow jumped over the moon</decryption_key>

                <message_connection queue="psp.out.replicator.example" password="encrypted:iTOCp4deP7rJNgFkf2AEMA==" user="exampleuser"  use_basic_consume="true" exclusive="true" >amqp://acme.perspectium.net</message_connection>
                <instance_connection user="example.user" password="examplepassword">https://myinstance.service-now.com</instance_connection>
                <consumer_sleep_time>50000</consumer_sleep_time>
                <database_type>mysql</database_type>
                <database_server>localhost</database_server>
                <database_port>3306</database_port>
                <database_user>root</database_user>
                <database_password>encrypt:mypassword</database_password>
                <database_parms/>
                <database>mydatabase</database>
                <skip_database_creation/>
            </task>
      </subscribe>

   </agent>
  </config>