Pause a stream

Overview

After starting a stream, you can pause it. When a stream is paused, Datastream won'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" will continue 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.

Pause the stream

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

    Go to the Streams page

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

  3. Click PAUSE.

  4. In the dialog box, 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.