Requirements for Eon Mode databases

Eon Mode databases perform the same backup and restore operations as Enterprise Mode databases. There are additional requirements for Eon Mode because it uses a different architecture.

Required configuration file parameters

You must back up Eon Mode databases to a supported cloud storage location. Vertica requires that you set the following values in your vbr configuration file:

• cloud_storage_backup_path

• cloud_storage_backup_file_system_path

A backup path is valid for one database only. You cannot use the same path to store backups for multiple databases. For more about these configuration parameters, see [CloudStorage].

Eon Mode databases that use S3-compatible on-premises cloud storage can back up to Amazon Web Services (AWS) S3.

Cloud storage access

In addition to having access to the cloud storage bucket used for the database's communal storage, you must have access to the cloud storage backup location. Verify that the credential you use for access to communal storage also has access to the backup location. For more information about configuring cloud storage access for Vertica, see Configuring backups to and from cloud storage.

For AWS, note that while your backup location may be in a different region, backup and restore operations across different S3 regions are incompatible with Virtual Private Cloud (VPC) endpoints.

S3 on-premises and private cloud storage

If your database runs on-premises, then your communal storage is not on AWS but on another storage platform that uses the S3 protocol. This means there can be two endpoints and two sets of credentials, depending on where you back up. This additional information is stored in environment variables, not parameters in the configuration file. See Configuring backups to and from cloud storage for more information.

Backups of Eon Mode on-premises databases do not support AWS IAM profiles.

Eon Mode on-premises databases support the following vbr tasks:

• backup

• restore

• listbackup

• replicate

• quick-check

• full-check

• quick-repair

• collect-garbage

• remove

HDFS on-premises storage

To back up an Eon Mode database that uses HDFS on-premises storage, the communal storage and backup location must use the same HDFS credentials and domain. All vbr operations are supported, except copycluster.

Vertica supports Kerberos authentication, High Availability Name Node, and wire encryption for vbr operations. Vertica does not support at-rest encryption for Hadoop storage.

For details, see Configuring backups to and from HDFS.

Database restore requirements

When restoring a backup of an Eon Mode database, the restore database must satisfy the following requirements:

• Share the same name as the backup database.

• Have at least as many nodes as the primary subcluster(s) in the backup database.

• Have the same node names as the nodes of the backup database.

• Use the same catalog directory location as the backup database.

• Use the same port numbers as the backup database.

• For object restore, have the same shard subscriptions. If the shard subscriptions have changed, you cannot do object restores but can do a full restore. Shard subscriptions can change when you add or remove nodes or rebalance your cluster.

You can restore a full or object backup that was taken from a database with primary and secondary subclusters to the primary subclusters in the target database. The database can have only primary subclusters, or it can also have any number of secondary subclusters. Secondary subclusters do not need to match the backup database. The same is true for replicating a database; only the primary subclusters are required. The requirements are similar to those for Reviving an Eon Mode database cluster.

Use the [Mapping] section in the configuration file to specify the mappings for the primary subcluster.