Skip to content

Latest commit

 

History

History
44 lines (31 loc) · 1.75 KB

server_upgrade.md

File metadata and controls

44 lines (31 loc) · 1.75 KB
Raw

Server Upgrade: 1.2.x to 1.3.x

This procedure is for sites running the APEL regional server. Sites running the APEL client are not affected by the schema change described in this document.

Motivation

Version 1.3 of the APEL server software uses a different database schema to version 1.2. This change was made to allow normalised summary records to be sent to APEL servers which necessitated altering one table among other changes. This requires extra steps to be performed during an upgrade.

Summary of procedure

The outline of this procedure is to export all the data from the database except for the super-summaries that are compiled from job recrods and received summaries. The super-summaries are then recreated after importing the data once the schema has been updated.

Procedure

  1. Stop any APEL services that use the database (dbloader, dbunloader, summariser). SSM can continue to run.
  2. Do a full database backup.
  3. Export all data except for the SuperSummaries table. (Assuming the database is named apel.)
mysqldump -u root -p --no-create-info --ignore-table=apel.SuperSummaries apel | gzip > upgrade_data.sql.gz
  1. Log into MySQL and drop the database.
  2. Upgrade the RPMs. (Assuming v1.3.1 packages for SL5 are used.)
rpm -U apel-lib-1.3.1-1.el5.noarch.rpm apel-server-1.3.1-1.el5.noarch.rpm
  1. Log into MySQL and create a new empty database.
  2. Load the new server schema.
mysql -u root -p apel < /usr/share/apel/server.sql
  1. Import data.
zcat upgrade_data.sql.gz | mysql -u root -p apel
  1. Run the summarising process to rebuild the super-summaries.
  2. Restart all APEL services.

Support

Support with this procedure is available through GGUS.