Preparing to Upgrade

NuoDB Upgrade Compatibility Requirements

Upgrading to NuoDB 4.3 or newer

If your domain is currently using the NuoDB Agent (nuoagent) administration tier, you must first complete your migrations to the NuoDB Admin (nuoadmin) domain administration tier.

If your databases are running a version before NuoDB 4.1.3 or running 4.2.0, then a rolling upgrade to 4.3 or newer requires a two-step process.

  1. First, a rolling upgrade to 4.1.3 or 4.2.1.

  2. Then, a rolling upgrade to 4.3 or newer.

If upgrading with databases down, you may upgrade directly to NuoDB 4.3 or newer from any version.

NuoDB SQL Execution Engine Upgrade Consideration

If you are upgrading a production environment and your NuoDB database applications have not yet been tested or validated using the Vectorized Execution Engine (VEE), then NuoDB recommends that you first upgrade to the latest 4.2 maintenance release using the Scalar Execution Engine (SEE). Test and confirm your applications work correctly on VEE in a test environment before upgrading your production database to use VEE at your convenience. Once satisfied that your production applications are running well on 4.2 using VEE, you can upgrade to 4.3 follow the normal upgrade instructions.

Pre-Upgrade Best Practices

Before you upgrade to a newer NuoDB release, best practices include the following steps:

  1. Stop a Storage Manager (SM) and run nuoarchive check on the archive of every storage group served by that SM. For more information on using nuoarchive check, see NuoDB Archive.

  2. Back up your databases. For information on backing up NuoDB databases, see Backing Up and Restoring Databases.

  3. Determine whether you will want to change any NuoDB configuration files to take advantage of new features or changes to features. See and Changes. On each upgraded host, you will want to make any necessary updates to configuration files before you restart the NuoDB Admin Process (AP) on that host. Installation of the new NuoDB release will not overwrite any existing configuration files:

    • $NUODB_CFGDIR/nuoadmin.conf

    • $NUODB_CFGDIR/jvm-options

    • $NUODB_HOME/etc/nuodb.config

Sample files nuoadmin.conf.sample, jvm-options.sample, and nuodb.config.sample, are provided in $NUODB_HOME/etc. For information on the value of NUODB_HOME and other variables, see Environment Variables.