Differences between revisions 4 and 24 (spanning 20 versions)
Revision 4 as of 2009-09-09 01:49:28
Size: 686
Editor: c-67-176-12-8
Comment:
Revision 24 as of 2013-05-01 04:35:27
Size: 1050
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
[[Anchor(mostrecent)]]
 * Status (Tues 09-0802009)
  * Currently I'm testing the use of the warm standby server as a PITR backup/recovery source (est completion = today)
  * Next step is to finish the WAL backup scripts in a way that allows us to recover in a controlled manner - plus the creation of the backup meta data (est completion = Late tomorrrow)
  * Next I'll coordinate a full xfs backup/restore test on hmidb0/1 with xfsdump as the defined backup command (est completion = ? probably Thurs)
  * After this I'll start on the "Kevin evaluates our plan to disseminate database data to the public..." task
<<Anchor(mostrecent)>>

= Current Tasklist =
== Updated Tues 12-01-2009 ==
== SLONY ==
=== subscribe_series() ===
 * 80% complete
 * modifications to get_slony_logs and the slony1 dump scripts are in progress (for integration with subscribe_series)
 * subscribe series (end2end) should be ready for installation/testing by end of day Wed (12-2-2009)
=== publish_series() ===
 * Design is complete
 * on hold until subscribe_series is complete
 * ETA: Monday 12-14
== WARM Standby ==
=== dcs servers ===
 * initial design / setup in progress
 * NFS mounts complete (setup by Keh-Cheng)
 * ETA: completion should be early/mid this afternoon (12-1-2009)
== Backup / Recovery ==
 * New design doc in place
 * Code construction on hold until slony is complete
== Additional Tasks ==
 * single-command warm standby failover
 * single-command warm standby re-set
 * add/drop things from SLONY script
 * graphing tool to show avg slony load per object
 * Monitoring

Kevins's archive

Current Tasklist

Updated Tues 12-01-2009

SLONY

subscribe_series()

  • 80% complete
  • modifications to get_slony_logs and the slony1 dump scripts are in progress (for integration with subscribe_series)
  • subscribe series (end2end) should be ready for installation/testing by end of day Wed (12-2-2009)

publish_series()

  • Design is complete
  • on hold until subscribe_series is complete
  • ETA: Monday 12-14

WARM Standby

dcs servers

  • initial design / setup in progress
  • NFS mounts complete (setup by Keh-Cheng)
  • ETA: completion should be early/mid this afternoon (12-1-2009)

Backup / Recovery

  • New design doc in place
  • Code construction on hold until slony is complete

Additional Tasks

  • single-command warm standby failover
  • single-command warm standby re-set
  • add/drop things from SLONY script
  • graphing tool to show avg slony load per object
  • Monitoring

JsocWiki: KevinsProgress (last edited 2013-05-01 04:35:27 by localhost)