Changes between Version 22 and Version 23 of Petascope_9.5


Ignore:
Timestamp:
Jul 4, 2017 10:41:53 AM (3 months ago)
Author:
bphamhuu
Comment:

rename to petascopedb_94_backup

Legend:

Unmodified
Added
Removed
Modified
  • Petascope_9.5

    v22 v23  
    1717For example, to use postgresql as a backend database for petascope, the following (default) configuration is specified:
    1818{{{
    19 spring.datasource.url=jdbc:postgresql://localhost:5432/petascopedb_cis
     19spring.datasource.url=jdbc:postgresql://localhost:5432/petascopedb
    2020spring.datasource.username=petauser
    2121spring.datasource.password=petapasswd
    2222spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
    2323}}}
    24 The existing database configuration is kept without any change (note that it is only used during migration, as the source of existing `petascopedb` or, later on, `petascopedb_cis`):
     24The existing database configuration is kept without any change (note that it is only used during migration, as the source of existing `petascopedb` or, later on, `petascopedb`):
    2525{{{
    2626metadata_url=jdbc:postgresql://localhost:5432/petascopedb
     
    3838The database schema in petascope 9.5 has changed, so existing rasdaman installation would need to migrate by executing a migration script `update_petascopedb.sh`.
    3939
    40 This will create a new database `petascopedb_cis`, and will not modify the existing `petascopedb`.
     40This will create a new database `petascopedb`, and will not modify the existing `petascopedb` (except rename it to: `petascopedb_94_backup`).
    4141
    4242== Developer's guide on update_petascopedb.sh
     
    51511. Execute the migration script: `./update_petascopedb.sh`
    52521. All coverages in pre 9.5 `petascopedb` will be read by the old `CoverageMetadata` model which is imported in the new petascope as a legacy package.
    53 1. If coverage id doesn't exist in the new `petascopedb_cis`, a process to translate from old `CoverageMetadata` model to CIS coverage data model is done and then persisted in `petascopedb_cis`.
     531. If coverage id doesn't exist in the new `petascopedb`, a process to translate from old `CoverageMetadata` model to CIS coverage data model is done and then persisted in `petascopedb`.
    54541. While running the migration, all services of the new petascope web application, such as: WCS, WCPS, WMS, and WCS-T, will not be available to make sure the data is migrated safely.
    5555
     
    5858The following parts of petascope are saved to allow for rollback in the unlikely case of an unsuccessful migration.
    5959
    60 * The old `petascopedb` is preserved to allow the user to test the new petascope version first. It is their decision, ultimately, whether to drop the previous database or not.
     60* The old `petascopedb` is preserved (except it is renamed to: `petascopedb_94_backup`) to allow the user to test the new petascope version first. It is their decision, ultimately, whether to drop the previous database or not.
    6161* The old petascope web application will be moved from `rasdaman.war` to `rasdaman.war.old` in the Tomcat webapps directory
    6262* The `petascope.properties` is backed up to `petascope.properties.DATE.bak` by the `update_properties.sh` script.
     
    65651. rename the new petascope (rasdaman.war and petascope.properties to rasdaman.war.new and petascope.properties.new)
    66661. rename the old petascope back to the original (rasdaman.war.bak and petascope.properties.DATE.bak to rasdaman.war and petascope.properties).
     671. rename the backuped database from `petascopedb_94_backup` to `petascopedb`.
    67681. restart Tomcat
    6869
     
    7475{{{
    7576# Postgresql (default)
    76 spring.datasource.url=jdbc:postgresql://localhost:5432/petascopedb_cis
     77spring.datasource.url=jdbc:postgresql://localhost:5432/petascopedb
    7778spring.datasource.username=*db-username*
    7879spring.datasource.password=*db-password*
     
    8081
    8182# Mysql
    82 spring.datasource.url=jdbc:mysql://localhost:3306/petascopedb_cis?createDatabaseIfNotExist=true
     83spring.datasource.url=jdbc:mysql://localhost:3306/petascopedb?createDatabaseIfNotExist=true
    8384spring.datasource.username=*db-username*
    8485spring.datasource.password=*db-password*
     
    8687
    8788# HSQLDB
    88 spring.datasource.url=jdbc:hsqldb:file://home/rasdaman/petascopedb_cis.db
     89spring.datasource.url=jdbc:hsqldb:file://home/rasdaman/petascopedb.db
    8990spring.datasource.username=*db-username*
    9091spring.datasource.password=*db-password*
    9192
    9293# H2
    93 spring.datasource.url=jdbc:h2:file://home/rasdaman/petascopedb_cis.db;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1
     94spring.datasource.url=jdbc:h2:file://home/rasdaman/petascopedb.db;DB_CLOSE_ON_EXIT=FALSE;DB_CLOSE_DELAY=-1
    9495spring.datasource.username=*db-username*
    9596spring.datasource.password=*db-password*