Run a stream

This page describes the actions that you can take when you run a stream. The actions include:

Start the stream

When you created a stream, you either created the stream and started it immediately, or created the stream without starting it.

If you created the stream, but you didn't start it, then you can do so now. By starting the stream, Datastream can transfer data, schemas, and tables from the source database to the destination.

  1. Go to the Streams page in the Google Cloud Console.

    Go to the Streams page

  2. Select the checkbox to the left of the stream that you want to start.

  3. Click START.

  4. In the dialog, click START. The status of the stream changes from Not started to Starting to Running.

After starting a stream, you can monitor it to verify that Datastream transferred data from the source database to the destination.

Pause the stream

After starting a stream, you can pause it. When a stream is paused, Datastream doesn't pull any new data from the source database into the destination. However, some data may continue to be written to the destination as data "in flight" continues to flow.

In some cases, if you pause a stream, then the source database must retain the data until you resume the stream. The retention period for the source database may be limited. If the stream is paused for longer than the source retention period, and then the stream is resumed, this can cause the stream to fail. If this occurs, delete the stream, create a new one, and then start it so that Datastream can transfer data, schemas, and tables from the source database to the destination.

  1. Go to the Streams page in the Google Cloud Console.

    Go to the Streams page

  2. Select the checkbox to the left of the stream that you want to pause.

  3. Click PAUSE.

  4. In the dialog, click PAUSE. The status of the stream changes from Running to Draining. Draining a stream is the process of emptying the stream so that it doesn't contain any data.

    After the stream is drained of all data, then the status of the stream changes from Draining to Paused.

After pausing a stream, you can resume it so that Datastream can transfer new data from the source database to the destination.

Resume the stream

You can resume a stream that you paused. By resuming the stream, Datastream can transfer new data from the source database to the destination.

  1. Go to the Streams page in the Google Cloud Console.

    Go to the Streams page

  2. Select the checkbox to the left of the stream that you want to resume.

  3. Click RESUME. The status of the stream changes from Paused to Running.

After resuming a stream, you can monitor it to verify that Datastream transferred new data from the source database to the destination.