Is there a synchrnization method for Autosys Web UI Database?
search cancel

Is there a synchrnization method for Autosys Web UI Database?

book

Article ID: 280933

calendar_today

Updated On:

Products

Autosys Workload Automation

Issue/Introduction

Autosys offers a DB failover stragey for Scheduler DB's as they sync in real time and we have setup.  

We are not able to find an Autosys DB failover for WCC DB's as they do not sync at all.

May you provide the Autosys DB failover / sync strategy please for WCC DB?

Environment

Any

Resolution

Usually scheduler functionality is different since the jobs are live it needed a running environment to rely when the primary DB is down.

Web UI databases depend on collectors mechanism to store data in the database. Usually for synchronization it has to collect to data from AE database so databases need not have dependency to synchronize, it automatically gets data from AE database as soon as it is up and running.

For Web UI the functionality varies because Collectors contact AutoSys Database and gets data and store them in WCC database.

For configuring HA in Web UI you must setup Apache HTTPD load balancer.

High Availability
Web UI can be installed in High Availability mode. High Availability includes load balancing, which is implemented using Apache HTTPD Server. Apache HTTPD Server can be installed on any server that has access to the Web UI servers in a High Availability group, including a server on which Web UI is installed.
Web UI instances in a High Availability group share the Web UI and Reporting databases, and use a common instance of CA EEM. Web UI configurations are stored in the common database, and changes to the configurations are available to all Web UI instances in the High Availability group.

This enhances more here:

Web UI Deployment Scenarios

Configuring HTTPD