SQL - ALTER CLUSTER

Updates attributes on an existing cluster.

Syntax

ALTER CLUSTER <cluster> <attribute-name> <attribute-value>
  • <cluster> Defines the cluster you want to change. You can use its logical name or ID. Beginning with version 2.2, you can use the wildcard * to update multiple clusters together.
  • <attribute-name> Defines the attribute you want to change. For a list of supported attributes, see the table below.
  • <attribute-value> Defines the value you want to set.

Examples

  • Change the name of a cluster, using its name:

    orientdb> ALTER CLUSTER profile NAME "profile2"

IMPORTANT: cluster name, status, compression, conflictstrategy are strings, so they have to be "quoted"

  • Change the name of a cluster, using its ID:

    orientdb> ALTER CLUSTER 9 NAME "profile2"

  • Update the cluster conflict strategy to automerge:

    orientdb> ALTER CLUSTER V CONFLICTSTRATEGY "automerge"

  • Put cluster V_2012 offline:

    orientdb> ALTER CLUSTER V_2012 STATUS "OFFLINE"

  • Update multiple clusters with a similar name:

    orientdb> ALTER CLUSTER employee* status "offline"

For more information see, CREATE CLUSTER, DROP CLUSTER, ALTER CLUSTER commands.
For more information on other commands, please refer to Console Commands and SQL Commands.

Supported Attributes

NameTypeSupportDescription
NAMEStringChanges the cluster name.
STATUSStringChanges the cluster status. Allowed values are ONLINE and OFFLINE. By default, clusters are online. When offline, OrientDB no longer opens the physical files for the cluster. You may find this useful when you want to archive old data elsewhere and restore when needed.
CONFLICTSTRATEGYString2.0+Defines the strategy it uses to handle conflicts in the event that OrientDB MVCC finds an update or a delete operation it executes against an old record. If you don't define a strategy at the cluster-level, it uses the database-level configuration. For more information on supported strategies, see the section below.

Note: from version 3.x attributes COMPRESSION, USE_WAL, RECORD_OVERFLOW_GROW_FACTOR, RECORD_OVERFLOW_GROW_FACTOR are no longer supported.

Supported Conflict Strategies

StrategyDescription
versionThrows an exception when versions are different. This is the default setting.
contentIn the event that the versions are different, it checks for changes in the content, otherwise it uses the highest version to avoid throwing an exception.
automergeMerges the changes.

To know more about other SQL commands, take a look at SQL Commands.