在 Amazon Keyspaces 中檢視 CDC 串流

使用 CQL 檢視 CDC 串流

• 若要監控資料表的 CDC 狀態，您可以使用下列陳述式。

  SELECT custom_properties
  FROM system_schema_mcs.tables 
  WHERE keyspace_name='my_keyspace' and table_name='my_table';

  命令的輸出看起來與此類似。

  ...
  custom_properties
  ----------------------------------------------------------------------------------
  {'cdc_specification':{'status': 'Enabled', 'view_type': 'NEW_IMAGE', 'latest_stream_arn': 'arn:aws:cassandra:aws-region:111122223333:/keyspace/my_keyspace/table/my_table/stream/stream_label''}}
  ...

使用 檢視 CDC 串流 AWS CLI

1. 此範例說明如何查看資料表的串流資訊。

   aws keyspaces get-table \
   --keyspace-name 'my_keyspace' \
   --table-name 'my_table'

   命令的輸出如下所示。

   {
       "keyspaceName": "my_keyspace",
       "tableName": "my_table",
       ... Other fields ...,
       "latestStreamArn": "arn:aws:cassandra:aws-region:111122223333:/keyspace/my_keyspace/table/my_table/stream/stream_label",
       "cdcSpecification": {
           "status": "ENABLED",
           "viewType": "NEW_AND_OLD_IMAGES"    
       }
   }

2. 您可以在指定的 中列出帳戶中的所有串流 AWS 區域。下列命令是此範例。

   aws keyspaces list-streams --region aws-region

   命令的輸出可能看起來像這樣。

   {
       "Streams": [
           {
               "StreamArn": "arn:aws:cassandra:aws-region:111122223333:/keyspace/ks_1/table/t1/stream/2023-05-11T21:21:33.291",
               "StreamLabel": "2023-05-11T21:21:33.291",
               "KeyspaceName": "ks_1"
               "TableName": "t1",
           },
           {
               "StreamArn": "arn:aws:cassandra:aws-region:111122223333:/keyspace/ks_1/table/t2/stream/2023-05-11T21:21:33.291",
               "StreamLabel": "2023-05-11T21:21:33.291",
               "KeyspaceName": "ks_1"Create a keyspace with the name catalog. Note
                                   that streams are not supported in multi-Region keyspaces.
               "TableName": "t2",
           },
           {
               "StreamArn": "arn:aws:cassandra:aws-region:111122223333:/keyspace/ks_2/table/t1/stream/2023-05-11T21:21:33.291",
               "StreamLabel": "2023-05-11T21:21:33.291",
               "KeyspaceName": "ks_3"
               "TableName": "t1",
           }
       ]
   }

3. 您也可以使用下列參數列出指定金鑰空間的 CDC 串流。

   aws keyspaces list-streams --keyspace-name ks_1 --region aws-region

   命令的輸出看起來與此類似。

   {
       "Streams": [
           {
               "StreamArn": "arn:aws:cassandra:aws-region:111122223333:/keyspace/ks_1/table/t1/stream/2023-05-11T21:21:33.291",
               "StreamLabel": "2023-05-11T21:21:33.291",
               "KeyspaceName": "ks_1"
               "TableName": "t1",
           },
           {
               "StreamArn": "arn:aws:cassandra:aws-region:111122223333:/keyspace/ks_1/table/t2/stream/2023-05-11T21:21:33.291",
               "StreamLabel": "2023-05-11T21:21:33.291",
               "KeyspaceName": "ks_1"
               "TableName": "t2",
           }
       ]
   }

4. 您也可以使用下列參數列出指定資料表的 CDC 串流。

   aws keyspaces list-streams --keyspace-name ks_1 --table-name t2 --region aws-region

   命令的輸出看起來與此類似。

   {
       "Streams": [
           {
               "StreamArn": "arn:aws:cassandra:aws-region:111122223333:/keyspace/ks_1/table/t2/stream/2023-05-11T21:21:33.291",
               "StreamLabel": "2023-05-11T21:21:33.291",
               "KeyspaceName": "ks_1"
               "TableName": "t2",
           }
       ]
   }

在 Amazon Keyspaces 主控台中檢視 CDC 串流

1. 登入 AWS Management Console，並在 https：//https://console.aws.amazon.com/keyspaces/home 開啟 Amazon Keyspaces 主控台。

2. 在導覽窗格中，選擇資料表，然後從清單中選擇資料表。

3. 選擇串流索引標籤以檢閱串流詳細資訊。