This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| access:access_server_2015_maintenance [2015/04/27 19:41] mjallison | access:access_server_2015_maintenance [2015/08/31 23:15] (current) mjallison [Sprint 6 - 2015 Maintenance / Track support] | ||
|---|---|---|---|
| Line 37: | Line 37: | ||
| Prediction: The only stories with velocities are Story 1 (1.5) and Story 2 (1.4). Using an average velocity of 1.45 the predicted end of work is May 13, 2015 (30 work days). | Prediction: The only stories with velocities are Story 1 (1.5) and Story 2 (1.4). Using an average velocity of 1.45 the predicted end of work is May 13, 2015 (30 work days). | ||
| - | ======== Sprint 5B - 2015 Maintenance ====== | + | How to archive a project: | 
| + | * Project contents are placed in a zip file, named same as project | ||
| + | * A new folder is created /Projects/Archived to hold zip files once complete. | ||
| + | * Zip archives are built, then stored in S3, only then are project items removed. | ||
| + | * All file system items for the project are stored in same path in zip; e.g. Photos/picture12345.jpg, etc. | ||
| + | * KMZ tracks etc. are stored in Tracks/foo.kmz (per previous rule) | ||
| + | * Track system tracks are stored in Tracks/gps/date/serial/YYYY/MMDD.txt (same as server file system). | ||
| + | * Track stats are stored in Tracks/gps/date/serial/YYYY/MMDD.stats.txt (from MySQL) | ||
| + | * upon completion and storage of project archive, the following items are deleted from normal stores: | ||
| + | * Project removed from project table | ||
| + | * Track entries removed from track table | ||
| + | * Track statistics for associated tracks are removed from trackstats table | ||
| + | * All files in the project folder, AND the project folder will be deleted from the file store. | ||
| + | * A complementary API method will exist allowing the project zip to be restored. | ||
| + | * Sanity/legality tests for table based data will be undertaken to prevent sql injection attacks. | ||
| + | * The zip file is not modified during a restoration. | ||
| + | * Both archive and restore methods are to be atomic. | ||
| + | * It is possible that some data may not be able to be deleted during archive, but this will not affect the state of the zip archive. | ||
| + | * The customer file store may exceed their storage quota during archive or restore processing. | ||
| + | * After archive or restore the customer quota may be exceeded. | ||
| + | * The customer is responsible for deleting files to restore the quota balance. | ||
| - | **Start** 2015-04-10 | + | * All functionality occurs via a single API call (part of project API) | 
| + | * User must be CustomerAdmin in order to execute. | ||
| + | * Archived project is just like any other file, may be deleted by anyone. | ||
| + | * Project archiving will be available via menu options in the access client. | ||
| + | |||
| + | ======== Sprint 6 - 2015 Maintenance / Track support ====== | ||
| + | |||
| + | **Start** 2015-08-06 | ||
| ^ Task Number  ^ Owner ^ Estimate ^ Actual ^ Status ^ Description  ^  | ^ Task Number  ^ Owner ^ Estimate ^ Actual ^ Status ^ Description  ^  | ||
| - | | **5.1** |  | | |  | **Tracks** | | + | | **6.1** |  | | |  | **Tracks** | | 
| - | | **5.5** |  | | |  | **Architecture** | | + | | 6.1.1 |  | 1 |  1 | Done | Add multiple telemetry channels per tracker | | 
| - | | 5.5.1 |  Mike A | 1 |  | | Characterize current file store performance | | + | | 6.1.2 |  | 0 |  |  | <del>Add telemetry history for each tracker channel, 5 min per channel, 1 week history</del> This is a tracker task | | 
| - | | 5.5.2 |  Mike A | 5 |  |  | Design HSM flow and table structure | | + | | 6.1.3 |  | 1 |  0.5 | Done | Add TZ to point upload msg to allow for local break @ midnight. | | 
| - | | 5.5.3 |  Mike A | 5 |  |  | Implement HSM for files | | + | | 6.1.4 |  | 2 |  |  | GPS Track point orphan detector. | | 
| - | | 5.5.4 |  Mike A | 3 |  |  | Implement HSM for tracks | | + | | **6.2** |  | | |  | **Architecture** | | 
| - | | 5.5.5 |  Mike A | 3 |  | | Test dual server install, requires HSM, rollover DNS | | + | | 6.2.1 |  Mike A | 1 |  3  | Done | Characterize current file store performance (track, file ) | | 
| - | | **Total**  |  | **17** | **X** | | | | + | | 6.2.2 |  Mike A | 5 |  |  N/A  | Design HSM flow and table structure | | 
| + | | 6.2.3 |  Mike A | 5 |  |  N/A  | Implement HSM for files | | ||
| + | | 6.2.4 |  Mike A | 3 |  |  N/A  | Implement HSM for tracks | | ||
| + | | 6.2.6 |  | new  | 7 | Done | Implement streaming of file upload | | ||
| + | | 6.2.5 |  Mike A | 3 |  0  | Defer | Test dual server install, requires HSM, rollover DNS | | ||
| + | | 6.3 |  | 2 |  4 | Done | Add archive project to Access Client. (cust admin only)| | ||
| + | | 6.4 |  | | |  | **Files** | | ||
| + | | 6.4.1 |  | 1 |  0 | N/A | Can't be done <del>When referencing public url for ".html" file, post file contents, not file object.</del> | | ||
| + | | 6.5 |  | 3 |  |  Done | Characterize file / track upload performance | | ||
| + | | 6.6 |  | 3 |  |  | Investigate and scope a REST API, minimal file and track | | ||
| + | | 6.7 |  | new  | 2 | Done | Add track/cust-active bits to control access to server functionality | | ||
| + | | Accclt-15  |  Mike A | 0.5  | |  | Windows install sets install to 0.0.0 | | ||
| + | | **Total**  |  | **34.5** | **17.5** | | | | ||
| - | Prediction: 12 actual, using velocity of 1.45. | + | Prediction: 24 actual, using velocity of 1.45. |