Starting a database activity stream - Amazon Aurora
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

Starting a database activity stream

To monitor database activity for all instances in your Aurora DB cluster, start an activity stream at the cluster level. Any DB instances that you add to the cluster are also automatically monitored. If you use an Aurora global database, start a database activity stream on each DB cluster separately. Each cluster delivers audit data to its own Kinesis stream within its own Amazon Web Services Region.

When you start an activity stream, each database activity event, such as a change or access, generates an activity stream event. SQL commands such as CONNECT and SELECT generate access events. SQL commands such as CREATE and INSERT generate change events.

To start a database activity stream

  1. Open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the navigation pane, choose Databases.

  3. Choose the DB cluster on which you want to start an activity stream.

  4. For Actions, choose Start activity stream.

    The Start database activity stream: name window appears, where name is your DB cluster.

  5. Enter the following settings:

    • For Amazon KMS key, choose a key from the list of Amazon KMS keys.

      Note

      If your Aurora MySQL cluster can't access KMS keys, follow the instructions in Network prerequisites for Aurora MySQL database activity streams to enable such access first.

      Aurora uses the KMS key to encrypt the key that in turn encrypts database activity. Choose a KMS key other than the default key. For more information about encryption keys and Amazon KMS, see What is Amazon Key Management Service? in the Amazon Key Management Service Developer Guide.

    • For Database activity stream mode, choose Asynchronous or Synchronous.

      Note

      This choice applies only to Aurora PostgreSQL. For Aurora MySQL, you can use only asynchronous mode.

    • Choose Immediately.

      When you choose Immediately, the DB cluster restarts right away. If you choose During the next maintenance window, the DB cluster doesn't restart right away. In this case, the database activity stream doesn't start until the next maintenance window.

    When you're done entering settings, choose Start database activity stream.

    The status for the DB cluster shows that the activity stream is starting.

To start database activity streams for a DB cluster , configure the DB cluster using the start-activity-stream Amazon CLI command.

  • --resource-arn arn – Specifies the Amazon Resource Name (ARN) of the DB cluster.

  • --mode sync-or-async – Specifies either synchronous (sync) or asynchronous (async) mode. For Aurora PostgreSQL, you can choose either value. For Aurora MySQL, specify async.

  • --kms-key-id key – Specifies the KMS key identifier for encrypting messages in the database activity stream. The Amazon KMS key identifier is the key ARN, key ID, alias ARN, or alias name for the Amazon KMS key.

The following example starts a database activity stream for a DB cluster in asynchronous mode.

For Linux, macOS, or Unix:

aws rds start-activity-stream \ --mode async \ --kms-key-id my-kms-key-arn \ --resource-arn my-cluster-arn \ --apply-immediately

For Windows:

aws rds start-activity-stream ^ --mode async ^ --kms-key-id my-kms-key-arn ^ --resource-arn my-cluster-arn ^ --apply-immediately

To start database activity streams for a DB cluster, configure the cluster using the StartActivityStream operation.

Call the action with the parameters below:

  • Region

  • KmsKeyId

  • ResourceArn

  • Mode