Upgrading to a New Release

{question}

How do I upgrade my NuoDB database to a new version?

{question}

{answer}

There are two methods to upgrade your NuoDB database:

A. Offline upgrade

1. Shut down all hosts

  • nuodb [domain] > shutdown host <ip_address>
  • An example for one host command
  • Check all hosts are down
    nuodb [domain] > show domain summary

2. Back up database archive directories

  • While this step is optional, it is recommended as a best practice

3. Install the new version on each host

  • Caution: Do not uninstall the previous release of NuoDB
  • For example on RedHat:
    sudo rpm --upgrade nuodb-2.5.4.x86_64.rpm (or any other version)
  • For example on Ubuntu:
    sudo dpkg -i nuodb-2.5.4.x86_64.deb (or any other version)

4. Check all hosts are up

  • nuodb [domain] > show domain summary

B. Rolling upgrade (Online Upgrade)

  • In a rolling upgrade, you upgrade one host in the domain at a time. You start with any broker host in the domain and you can upgrade the hosts in any order
  • There are three steps. You must perform for every host

1. Shut down NuoDB processes on the host (gracefully)

$ nuodbmgr --broker aBroker --user adminUserName --password adminUserPw

--command 'shutdown host <ip_address> graceful true shutdownHost true disableEnforcer True removeFromMembership true'

2. Install the new version of NuoDB

  • Caution: Do not uninstall the previous release of NuoDB
  • For example on RedHat:
    sudo rpm --upgrade nuodb-2.5.4.x86_64.rpm (or any other version)
  • For example on Ubuntu:
    sudo dpkg -i nuodb-2.5.4.x86_64.deb (or any other version)

3. Restart the broker and verify upgrade

$ sudo service nuoagent start

  • At the final stage the Transaction Engine (TE) upgrades the system tables
  • The enforcer will start the TE last (if TE exists in that host)
  • If the last engine restarted is an SM or a TE doesn’t exist on a host, you should start an additional TE on that host so system table will upgrade

4. Rolling Upgrade verify

  • Run the following queries per database
  • All versions should have the same number

SQL> SELECT * FROM system.versions;

More Information can be found in Nuodb documentation:

Upgrading to a New Release

{answer}

 

Have more questions? Submit a request

Comments