Available since MemSQL Ops version 4.1.8.

Stop, upgrade, and restart all MemSQL nodes in the cluster.

Usage

usage: memsql-ops memsql-upgrade [--settings-file SETTINGS_FILE] [--async]
                                 [--file-path FILE_PATH | --version VERSION | --version-hash VERSION_HASH]
                                 [--no-prompt] [--restart-on-rollback]
                                 [--skip-snapshot] [--skip-version-check]
                                 [--backup-data-directories | --no-backup-data-directories]

Stop, upgrade, and restart all MemSQL nodes in the cluster.

optional arguments:
  --settings-file SETTINGS_FILE
                        A path to a MemSQL Ops settings.conf file. If not set,
                        we will use the file in the same directory as the
                        MemSQL Ops binary.
  --async               If this option is true, we will exit without waiting
                        for the cluster to be fully upgraded.
  --file-path FILE_PATH
                        A .tar.gz file that contains a MemSQL binary to use
                        during the upgrade.
  --version VERSION     The MemSQL version to which all nodes will be upgraded
                        (e.g. 4.0.0). If this is not set, we will attempt to
                        upgrade all nodes to the latest available MemSQL
                        version.
  --version-hash VERSION_HASH
                        A MemSQL version hash to use.
  --no-prompt           If this option is specified, we will upgrade the
                        cluster without prompting. We will also assume
                        --backup-data-directories is set to true unless
                        otherwise specified.
  --restart-on-rollback
                        In the event of an upgrade failure and rollback,
                        restart the cluster. The default behavior without this
                        flag is to leave the rolled-back cluster in a stopped
                        state.
  --skip-snapshot       Do not run SNAPSHOT on all the databases in the
                        cluster before upgrading. This may cause the upgrade
                        to take longer.
  --skip-version-check  Do not check that the MemSQL version specified is
                        higher than the installed MemSQL version. This flag
                        only applies to maintenance release upgrades.
  --backup-data-directories
                        Backup data directories during the upgrade. If both
                        this and --no-backup-data-directories are not
                        specified, we will prompt before the upgrade.
  --no-backup-data-directories
                        Do not backup data directories during the upgrade.
                        Specifying this option will result in faster upgrades
                        and will use less disk space during the upgrade at the
                        risk of data loss. If both this and --backup-data-
                        directories are not specified, we will prompt before
                        the upgrade.

Was this Article Helpful?

Thanks For Your Feedback!