...
administration credentials include:
ETL Processing
- windows user accounts (dev, qa, prod)
- ssh keys (dev, qa, prod)
Web Application
- applogic grid root
- ssh access to linux VMs
- tomcat
- geoserver
- postgres
- MAD application admin
- apache httpd
TODO - Paul - enumerate all these accounts, to be stored and maintained at a single unpublished location known to the support staff.
TODO - Paul - review all of the administration credentials, and do the following:
- insure that default passwords are not used
Viruses
We will not be scanning for viruses.
...
We are using the Postgres database which is known for stability and robustness.
In any event, every 24 hours we
- run consistency checks
- run a full vacuum/analyze to guarantee good performance
- backup the database
- copy the backup to offsite location
- retain backups as needed (todo - need this from Hema)
TODO - Paul - automate all of this
TODO - Hema - we need your business schedule to do these things at a good time
...
Disk Space
Every 24 hours we
- check that there are no disk space issues
- notify application support if there are any issues
TODO - Will, can I ask you to look at this? Paul can help.
Failover
Before we go into production and once every year, we will conduct a failover exercise to ensure that we are able to provide business continuity.
TODO - Paul
Service Level Agreement (separate docs?)
...
Who will provide Bug Fixes and Enhancements?
...
How will we decide what bugs get fixed and what enhancements are built (governance)?
...
Maximum time allowed for ETL outage.
...
Recovery Time Objective
...
Without MAD, DBI will not be able to issue permits. (Is this correct?) The recovery time objective for the application is 2 hours. Hema, is this acceptable?
...
Recovery Point Objective
...
The recovery point objective for the database is 24 hours. I am assuming that, given our limited resources, we will use database backups for recovery, and that we do not want to use replication. If we were to use replication, we could have a recovery point objective right down to a single transaction. But we have no expertise here and so I recommend against this approach.
...
Administration Roles
We need some wiki pages and some bodies - detailed belowto flesh out who is going to do what...
...
Virtual Machine Admin
...
Can our ASP provide this until we move to 200 Paul?
user administration
TODO - Hema, can DBI help with this?
...