Project

General

Profile

Disk Upgrade Plan

Upgrade of rexdbsrv2

Sysadmins (Monday 1/14)

  1. Shut down rexdbsrv2 - that will shut down Postgres
  2. Replace HDs
  3. Create RAID10 using six new HDs
  4. Start the server
  5. Format three new drives as they were before:
    /dev/sdc /data0 xfs (6 physical volumes, RAID 10, 9TB)
    /dev/sdd /data1 xfs (1 physical volume, no RAID, 3TB)
    /dev/sde /data2 xfs (1 physical volume, no RAID, 3TB)
  6. Set the ownership of /data0, /data1, /data2 to postgres
  7. Pass the server to REXDB (Vladimir)

REXDB (Tuesday 1/15 or earlier)

  1. Stop data feed into rexdbsrv1
  2. Restore the directory structures on /data{0,1,2}
  3. Upgrade Postgres to 9.1.7
  4. Set up a hot standby server on rexdbsrv2 using base backup taken from primary server running on rexdbsrv1 (copy data)
  5. Redirect data access web server to rexdbsrv2
  6. Stop primary server on rexdbsrv1
  7. Promote hot standby rexdbsrv2 to primary.
  8. Start data feed into rexdbsrv2

Upgrade of rexdbsrv1

Sysadmins (Wednesday 1/16 or earlier)

  1. Shut down rexdbsrv1
  2. Replace HDs
  3. Create RAID10 using six new HDs
  4. Start the server
  5. Format three new drives as they were before:
    /dev/sdc /data0 xfs (6 physical volumes, RAID 10, 9TB)
    /dev/sdd /data1 xfs (1 physical volume, no RAID, 3TB)
    /dev/sde /data2 xfs (1 physical volume, no RAID, 3TB)
  6. Set the ownership of /data0, /data1, /data2 to postgres
  7. Pass the server to REXDB (Vladimir)

REXDB (Thursday 1/17 or earlier)

  1. Stop data feed
  2. Restore the directory structures on /data{0,1,2}
  3. Upgrade Postgres to 9.1.7
  4. Set up a hot standby server on rexdbsrv1 using base backup taken from primary server running on rexdbsrv2 (copy data)
  5. Redirect data access web server to rexdbsrv1
  6. Stop primary server on rexdbsrv2
  7. Promote hot standby on rexdbsrv1 to primary
  8. Start data feed into rexdbsrv1
  9. Set up a hot standby server on rexdbsrv2 using base backup taken from primary server running on rexdbsrv1
  10. Redirect data access web server to rexdbsrv2
  11. Transfer servers to DBAs

Posrtgres will be upgraded to 9.1.7 during this upgrade.