Get started
Yandex Data Transfer

Migrating data to Yandex Managed Service for Greenplum®

Written by

You can migrate your database from a third-party Greenplum® or PostgreSQL cluster to Managed Service for Greenplum® using Yandex Data Transfer. This method allows you to:

  • Migrate the database without interrupting user service.
  • Migrate from older Greenplum® versions to newer versions.
  • Go without creating an intermediate VM or granting online access to your Managed Service for PostgreSQL target cluster.

For more information, see What tasks is Yandex Data Transfer used for?.

Note

Data Transfer enables you to transfer the state of the source database to the Managed Service for Greenplum® target without keeping it up-to-date (the Snapshot transfer type). Changes that occurred on the source after the transfer is completed will not be transferred.

To migrate your database, you need to directly transfer the data, acquire a write lock for the old database, and switch over the load to the database cluster in Yandex Cloud.

Before you begin

Create a Managed Service for Greenplum® target cluster with the computing capacity and storage size appropriate for the environment where the migrated database is deployed.

The database name in the target cluster must be the same as the source database name.

Transferring data

  1. Prepare the source cluster:

  2. Prepare the target cluster.

  3. Create a source endpoint with the following parameters:

    • Database type: Greenplum® or PostgreSQL.

    • Endpoint parameters → Connection settings: Custom installation.

      Specify the parameters for connecting to the source cluster.

  4. Create a target endpoint with the following parameters:

    • Database type: Greenplum®.

    • Endpoint parameters → Connection settings: MDB cluster.

      Specify the ID of the target cluster.

  5. Create a transfer of the Snapshot type that will use the created endpoints.

  6. Activate the transfer.

  7. Wait for the transfer status to change to Completed.

    For more information about transfer statuses, see Transfer lifecycle.

  8. Switch the source cluster to read-only mode and switch the load to the target cluster.

  9. Delete the completed transfer.

  10. Delete endpoints for the source and target.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc in the United States and/or other countries.

In this article: