Versions Compared

Old Version 8

changes.mady.by.user Tony Johnson

Saved on

compared with

New Version Current

changes.mady.by.user Tony Johnson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

The new servers are running the same OS and Oracle versions as our current production setup, so we do not anticipate any compatibility problems with the new servers. We have done extensive testing of the performance and compatibility of the new servers as detailed below.

Oracle hardware details

Image Added

Testing

Scalability Testing

...

We were able to run 1500 simulated MC jobs continuously for prolonged periods of time, and were able to ingest on orbits worth of trending data in a little over 1 minute.

Failover Testing

Failover testing will be performed on Monday April 7We have tested the ability to failover to the backup database if the primary database fails, and to resync the primary and secondary database. This procedure will be used if the primary database becomes inoperable for an extended period due to hardware or software failure. Currently failover is a manual operation requiring an oracle admin to designate the backup server as "primary". No change is required to GLAST software to switchover to the backup database.

Switchover methodology

We propose to switchover to the new oracle databases sometime during the period April 8-11on Monday April 14. We will perform the following steps

Starting midnight Sunday

  1. full backup of glast-oracle01 (to NFS disk)Restore into glast-oracle03

Starting 8am Monday

  1. Shutdown glast applications
  2. Shutdown glast-oracle01 database. <b>All glast database access will be lost at this time.</b>
  3. Restore into glast-oracle04oracle03
  4. Start Brief (20 min) shutdown to make glast-oracle01 a "primary" server (may not be necessary)as primary databse
  5. Switch glast-oracle01 to be a DNS alias Make glast-oracle03 physical standby for glast-oracle01oracle03Make
  6. Backup glast-oracle04 physical standby for glast-oracle01
  7. Shutdown Glast-apps
  8. Shutdown glast-oracle01.
  9. Make glast-oracle03 primary and change glast-oracle04 to be standby to glast-oracle02
  10. Repoint glast-oracle01 to glast-oracle03
    • POINT OF NO RETURN
  11. Restart Glast apps

...

  1. oracle03 to NFS disk

Approximately 8pm Monday

  1. glast database access restored. <b>glast application can be restarted.</b>
  2. Restore backup to glast-oracle04
  3. Bring up glast-oracle04 as physical standby to glast-oracle03

Tuessday 8am

  1. Short DB outage to switch glast-oracle03 to max availability mode