Skip to end of metadata
Go to start of metadata

Vista database backup & recovery

As of 06.18.10 the Vista DB is 1400+GB in size. The latest test to restore this database to chaco, which is nearly identical to the production Vista database hardware, took 10 hours, 22 minutes (38.4 MB/s). However, we estimate that the Vista database will reach 2000GB before Vista is retired as the primary LMS on campus. Given that rate, a restore will eventually require roughly 15 hours.

As of 11.15.09 the Vista DB is 1100+GB in size and is taking roughly 19 hours to backup and 23 hours to restore to our sysprep environment.

This is not ideal since a real disaster recovery scenario would require at best 26 - 30 hours to fully recover. Add to that the fact that the size of the database grows every day and in one or two years this recovery scenario would be 48 hours or more.

Backup & Restore testing

Testing is underway to try to determine what piece in the backup chain is slowing the process down.

  • 11.10.09 - A restore from NetBackup (coming from tapes) to Denali took 22 hours, 26 minutes
  • 11.13.09 - A restore from NetBackup (coming from disks) to Denali took 23 hours, 51 minutes
  • 06.16.10 - A backup from chaco to NetBackup took only 3 hours, 50 minutes
  • 06.17.10 - A restore from NetBackup to chaco took 10 hours, 22 minutes

Other Institutions' backup times (for reference)

  • Jason.Santee@mail.wvu.edu (West Virginia University)
    • 680GB Oracle database
    • 6 hour backup
    • 32 MB/s
  • cooling@csus.edu (Sacramento State)
    • 660GB 64-bit Oracle database
    • 2.75 hour backup
    • 68 MB/s
  • john.desha@utah.edu (University of Utah)
    • 2.27TB Oracle database
    • 3.5 hour backup
    • 188 MB/s
  • GMichko@Central.uh.edu (University of Houston)
    • 500GB Oracle database
    • 2.25 hour backup
    • 63 MB/s
  • ken.lacey@dit.ie  (Dublin Institute of Technology)
    • 405GB Oracle database
    • 6 hour backup
    • 19.2 MB/s
  • daniel.smith@wmich.edu (Western Michigan University)
    • 532GB Oracle database
    • 5.5 hour backup
    • 27.5 MB/s
  • edward.smith@bellevuecollege.edu (Bellevue College, Bellevue WA)
    • 480GB MSSQL database
    • 1.75 hour backup
    • 78 MB/s
  • No labels