Versions Compared

Old Version 1

changes.mady.by.user Brian Van Klaveren

Saved on

compared with

New Version 2

changes.mady.by.user Brian Van Klaveren

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This gives us an effective configuration of 16 3Ghz cores, 256GB RAM, and 14TB+ disk space.

...

Migration Procedures

 In conjunction with the physical database migration from glast-oracle03 and 04, we have been planning concurrently performing a reversible pipeline migration. Because of constraints on storage, it is not possible to perform a reversible migration on Oracle 10g, and Oracle 10g doesn't support SQL features we are using in the upgraded pipeline software. More information about the pipeline migration can be found here:  Pipeline Migration and Pipeline II, v1.5 

Pipeline Software compatibility information

The current pipeline is 1.4.2. The new pipeline will be 1.5.

  • 1.4.2 is incomatible with 1.5 schema, and 1.5 is incompatible with 1.4.2 schema.
  • 1.4.2 is compatible with 10g and 11g
  • 1.5 is compatible ONLY with 11g 

There are back-out procedures I’ve written just in case there is a need to back out of the pipeline upgrade to 1.5 and use 1.4.2 instead. Those back out procedures would be fine for the case where we turn the pipeline back on and something isn’t immediately fixable, but those back out procedures are not written in the case that we decide to drop back to 1.4.2 after a week. Basically, I keep the snapshot of the tables I’m changing and I can reinsert them for use, but I don’t have a way of updating the tables with any changes. 

Stages

Due to the size of the GLASTTREND database, we plan to perform the migration in two stages over two days time.

The actual timing of the stages is somewhat arbitrary, but I’ve suggested that we actually do GLASTTREND first, although it doesn’t matter much to me or Max. Since the GLASTTREND stage will take an absolute minimum of 8 hours, and likely closer to 10-12, I think Ian and Arash might need to coordinate their schedules a bit, so I’d like to see if Ian actually has a preference on which to do first.

Stage 1

In Stage 1, we will migrate the Trending data (GLASTTREND account). This involves the following:

...