Uploaded image for project: 'UIMA'
  1. UIMA
  2. UIMA-5122

DUCC Database (db) admin tool for save & restore

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.2.0-Ducc
    • Component/s: DUCC
    • Labels:
      None

      Description

      DUCC employs the Cassandra database, which in turn provides the nodetool command to create snapshots of the database. There is also a web site https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_backup_noderestart_t.html that comprises a labor intensive recipe for database restoration from snapshots.

      Provide a DUCC tool to aid in the creation of database snapshots and restoration therefrom.

        Activity

        Hide
        lou.degenaro Lou DeGenaro added a comment -

        code is delivered.

        Show
        lou.degenaro Lou DeGenaro added a comment - code is delivered.
        Hide
        lou.degenaro Lou DeGenaro added a comment -

        Remove import numpy as it is not needed

        Show
        lou.degenaro Lou DeGenaro added a comment - Remove import numpy as it is not needed
        Hide
        lou.degenaro Lou DeGenaro added a comment -

        Deliver DUCC Book update for admin/db_tool.

        Show
        lou.degenaro Lou DeGenaro added a comment - Deliver DUCC Book update for admin/db_tool.
        Hide
        lou.degenaro Lou DeGenaro added a comment -

        Deliver Python code implementing admin/db_tool.

        Show
        lou.degenaro Lou DeGenaro added a comment - Deliver Python code implementing admin/db_tool.
        Hide
        lou.degenaro Lou DeGenaro added a comment -

        revised:

        bash-4.1$ ./db_tool --help
        Usage: db_tool [options]

        Options:
        -h, --help show this help message and exit
        --save=PATH.tar.gz create snapshot of database and save to
        specified tar.gz file; requires database to
        be up
        --save-overwrite=PATH.tar.gz create snapshot of database and save to
        specified tar.gz file, overwriting previous
        file if one exists; requires database to be
        up
        --restore=PATH.tar.gz extract snapshot from specified tar.gz file
        and restore database; requires database to
        be down
        --restore-overwrite=PATH.tar.gz extract snapshot from specified tar.gz file
        and restore database, overwriting previous
        database if one exists; requires database
        to be down
        --quiet print no informational messages
        --verbose print extra debug messages

        Show
        lou.degenaro Lou DeGenaro added a comment - revised: bash-4.1$ ./db_tool --help Usage: db_tool [options] Options: -h, --help show this help message and exit --save=PATH.tar.gz create snapshot of database and save to specified tar.gz file; requires database to be up --save-overwrite=PATH.tar.gz create snapshot of database and save to specified tar.gz file, overwriting previous file if one exists; requires database to be up --restore=PATH.tar.gz extract snapshot from specified tar.gz file and restore database; requires database to be down --restore-overwrite=PATH.tar.gz extract snapshot from specified tar.gz file and restore database, overwriting previous database if one exists; requires database to be down --quiet print no informational messages --verbose print extra debug messages
        Hide
        lou.degenaro Lou DeGenaro added a comment -

        bash-4.1$ ./db_tool --help
        Usage: db_tool [options]

        Options:
        -h, --help show this help message and exit
        --save create snapshot of database; expects database to be up
        --restore restore database from snapshot; expects database to be
        down

        Advanced:
        --debug display debugging messages
        --name=SNAPSHOT name of the snapshot

        Auxiliary:
        --start start the database
        --stop stop the database

        Show
        lou.degenaro Lou DeGenaro added a comment - bash-4.1$ ./db_tool --help Usage: db_tool [options] Options: -h, --help show this help message and exit --save create snapshot of database; expects database to be up --restore restore database from snapshot; expects database to be down Advanced: --debug display debugging messages --name=SNAPSHOT name of the snapshot Auxiliary: --start start the database --stop stop the database

          People

          • Assignee:
            lou.degenaro Lou DeGenaro
            Reporter:
            lou.degenaro Lou DeGenaro
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development