Admin DataWeb^? Service

Objectives

1. To make sure that a remote service is up when requested
2. To insure that updates are done consistently across the network
3. To provide load statistics for load balancing
4. To insure that systems across the network are not vuneralbe to hacking

Features

1. List the services and version it's running
2. Uptime
3. Heart beat services including: Metadata service, Model service, Tabulation&Extraction service, HotReport^? service, Mapping Service, Data Stores (data bases and sources)
4. Data Sources Heartbeat

• MySQL^? database (does a describe table for all dataset in Ioapi configuration)
  
• Sybase (Checks in sys objects for all datasets in Ioapi configuration)
  
• SQL Server (Checks in sys objects for all datasets in Ioapi configuration)
  
• Flat Files (Checks to see if it has read rights to the directory where the files are stored)
  
• SAS

5. Clear the metadata cache only if metadata service if running
6. List the amount of memory (RAM) that is available to Java VM
7. Request metadata replication only if metadata service and local admin is running
8. Request update and restart only if local admin is running

Heart Beat Path and Updates

Two paths for the heart beats.

1.Remote heart beat:

1. Remote server sends heart beats to heartbeat service.
2. Heart beat service in turn sends heart beats to all local services.
3. If the remote server does not get a valid heart beat from heart beat service, the server, services and associated data is marked as down. The metadata services should be notified that data is unreachable.

2.Local heart beat service:

1. Is a local program, very simple and available for review.
2. It also heart beats the heart beat service.
3. If the heart beat service is considered dead, the local heart beat service uses sudo to initate a restart, output logs and email the responsible administrator.

3.Updating Services:

1. Heart beat service receives notification that an update is available. This
2. Local heart beat program requests update Java Web Archive file.
3. Local heart beat program restarts java servlet container.

Local Admin service

1. ReStart tomcat if tomcat script is specified
2. Replicate mysql if all mysql parameters are specified (user,pass,jdbc driver, and ect...)
3. Does a heart beat to see if admin webservice and all other service is running. If not it will request a restart and send out email.
5. Update all dataweb services.

-- CavanCapps - 20 Feb 2008