Upgrading a database using Cloudera Operational Database

Learn how to upgrade your existing Cloudera Operational Database in the Cloudera environment.

  • You need to use the CDP Beta CLI and run the upgrade-database command to upgrade your database.
  • Required role: You must be logged into the Cloudera Operational Database as an ODAdmin.
  • To use Cloudera Operational Database on a GCP environment, you must do it through CDP CLI with --use-hdfs flag.
  • Before you perform the Cloudera Operational Database upgrade: In the Cloudera Manager properties, increase the omid_max_heap_size property for the Omid service to at least 3GB before starting the upgrade from 7.2.9/7.2.10 to 7.2.11:
  • Understand Cloudera environment and user management. For more information, see User Management and Cloudera Environments topics.
  • Ensure you are authorized to upgrade a database.
  • You must download and install the latest CDP CLI beta version.
  • Cloudera recommends that you run the prepare-upgrade-database command before upgrading the cluster. This command performs all validations and downloads all required parcels for the upgrade operation. For more information, see prepare-upgrade-database.
  1. Log in to the CDP CLI tool.
  2. Run the following command to prepare for the upgrade. This step is optional.
    To reduce the chances of upgrade failures, Cloudera Operational Database supports a preparation phase for the runtime upgrades. During this phase, Cloudera Operational Database runs all the validations and downloads the required parcels for the machines.

    cdp opdb prepare-upgrade-database --environment <environment-name> --database <database-name> --runtime <runtime-version> [OR --image-id <image-id>]

    Option Description
    --environment (string) The name or CRN of the environment.
    --database <value> The name or CRN of the database.
    --runtime <value> The runtime version to upgrade to.
    --image-id <imageId> The image ID to upgrade to.
  3. Run the following command to upgrade the database.
    This command upgrades an operational database in an environment to a given Runtime:

    cdp opdb upgrade-database --environment <environment-name> --database <database-name> --runtime <runtime-version> [--os-upgrade-only | --no-os-upgrade only]

    Option Description
    --environment (string) The name or CRN of the environment.
    --database <value> The name or CRN of the database.
    --runtime <value> The runtime version to upgrade to.
    [--os-upgrade-only | --no-os-upgrade-only] Controls whether to perform only an Operating System upgrade.