Ingest data from Amazon MSK

Amazon Managed Streaming for Apache Kafka (MSK) is a fully managed service that simplifies the setup, scaling, and management of Apache Kafka clusters, a popular open-source distributed streaming platform. Kafka is designed to handle real-time data feeds and follows the publisher-subscriber (pub-sub) model. Kafka's ability to handle high-volume real-time data makes it crucial for data pipelines, analytics, and event-driven architectures.

To ingest data from Amazon MSK into RisingWave, you need an operational Amazon MSK cluster and a Kafka topic established. Once set, you'll leverage the Kafka connector in RisingWave to consume data from your MSK topic.

This guide will detail the ingesting streaming data from Amazon MSK into RisingWave.

Set up Amazon MSK

To learn about how to set up an Amazon MSK account and create a cluster, see Getting started using Amazon MSK. For this demo, we will assume the selection of Quick create for the Cluster creation method and Provisioned for the Cluster type. The cluster creation can take about 15 minutes.

While creating your cluster, note down the following information regarding the cluster you want to connect to.

1. Get the VPC value from the All cluster settings.

2. Get the Security groups associated with VPC from the All cluster settings.

3. Get the ARN value from the Cluster summary.

To customize the IAM policy, see IAM access control.

Set up EC2 on AWS

To learn how to create an EC2 client machine and add the security group of the client to the inbound rules of the cluster's security group from the VPC console, see Create a client machine.

Configure MSK Kafka

Enable SASL

1. Access the Amazon MSK console and select the MSK cluster.

2. Click on the Properties tab, and click Edit in the Security settings section.

3. Select SASL/SCRAM authentication and click Save changes.

For more information regarding SASL settings, see Sign-in credentials authentication with AWS Secrets Manager.

Create a symmetric key

1. Access the AWS Key Management Service (AWS KMS) console.

2. Click Create Key, select Symmetric, and click Next.

3. Give the key an Alias and click Next.

4. Under Administrative permissions, select AWSServiceRoleForKafka and click Next.

5. Under Key usage permissions, again select AWSServiceRoleForKafka and click Next.

6. Lastly, review the details and click Finish.

For more information, see Creating symmetric encryption KMS keys.

Store a new Secret

1. Access the AWS Secrets Manager console.

2. Click Store a new secret.

3. Under Secret type, select Other type of secret.

4. Under Key/value pairs, click on Plaintext, paste the following in the space below, and replace <your-username> and <your-password> with the username and password you want to set for the cluster.

   {
     "username": "<your-username>",
     "password": "<your-password>"
   }

5. Under Encryption key, select the symmetric key alias you previously created.

6. On the next page, enter a Secret name that starts with AmazonMSK_.

7. After creating the secret, record the Secret ARN (Amazon Resource Name) value.

For more information, see Sign-in credentials authentication with AWS Secrets Manager.

Link the Secret with the MSK cluster

1. Access the Amazon MSK console and select the MSK cluster.

2. Click the Actions tab and select Edit security settings.

3. Select SASL/SCRAM authentication and click Save changes.

4. Back on the main page, click the Properties tab, and in the Security settings section, under SASL/SCRAM authentication, click Associate secrets.

5. Paste the Secret ARN value you recorded in the previous step and click Associate secrets.

Use SSH to log into the EC2 machine

```
ssh -i “xxx.pem" ubuntu@ec2-xx-xxx-xxx-xxx.compute-1.amazonaws.com
```

To find your specific command values:

1. Access the EC2 console and select the instance you created.

2. Click Connect, select SSH client, and copy the command example provided.

Install AWS CLI and Java

sudo apt install unzip
curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"
unzip awscliv2.zip
sudo ./aws/install
sudo apt install openjdk-8-jdk -y

Download Kakfa client

wget https://archive.apache.org/dist/kafka/2.6.2/kafka_2.12-2.6.2.tgz
tar -xzf kafka_2.12-2.6.2.tgz

Configure AWS IAM credentials on EC2

1. Run the following command to configure AWS credentials and default settings.

   aws configure

2. Place the users_jaas.conf with the following contents in /home/ubuntu.

   KafkaClient {
   org.apache.kafka.common.security.scram.ScramLoginModule required
     username="<your-username>"
     password="<your-password>";
   };

3. Run the following command to define the specific security settings Kafka should use.

   export KAFKA_OPTS=-Djava.security.auth.login.config=/home/ubuntu/users_jaas.conf

4. Use the following command to copy the JDK key store file from your JVM cacerts folder into the kafka.client.truststore.jks copy.

   cp /usr/lib/jvm/java-1.8.0-openjdk-amd64/jre/lib/security/cacerts ~/kafka.client.truststore.jks

5. Create client_sasl.properties at /home/ubuntu with the following contents.

   security.protocol=SASL_SSL
   sasl.mechanism=SCRAM-SHA-512
   ssl.truststore.location=/home/ubuntu/kafka.client.truststore.jks

Create a topic using the broker address with SASL

1. Access the Amazon MSK console and select the cluster.

2. Click View client information and copy the URL under Private endpoint for SASL/SCRAM. This will be your <broker-url> from now on.

3. Run the following command to create a topic.

   bin/kafka-topics.sh --bootstrap-server <broker-url> --command-config ~/client_sasl.properties --create --topic <topic-name>

   Optional: The following command will list the topics.

   bin/kafka-topics.sh --bootstrap-server <broker-url> --list --command-config ~/client_sasl.properties

4. Insert test data.

   bin/kafka-console-producer.sh --bootstrap-server <broker-url> --topic <topic-name> --producer.config ~/client_sasl.properties

Once you run the kafka-console-producer command, you will be prompted to enter messages into the console. Each message should be entered on a new line; you can enter as many messages as you like.

After entering messages, you can close the console window or press Ctrl + C to exit the producer.

Consume data from Amazon MSK in RisingWave

Install and launch RisingWave

See Quick start for options on how you can run RisingWave.

Connect the cluster

psql -h localhost -p 4566 -d dev -U root

Create a source in RisingWave

To learn about the specific syntax used to consume data from a Kafka topic, see Ingest data from Kafka.

For example, the following query creates a table that consumes data from an MSK topic connected to Kafka.

CREATE TABLE s (v1 int, v2 varchar) 
WITH (
  connector = 'kafka', topic = '<topic-name>', 
  properties.bootstrap.server = '<broker-url>', 
  scan.startup.mode = 'earliest', 
  properties.sasl.mechanism = 'SCRAM-SHA-512', 
  properties.security.protocol = 'sasl_ssl', 
  properties.sasl.username = '<your-username>', 
  properties.sasl.password = ‘<your-password>’'
) FORMAT PLAIN ENCODE JSON;

Then, you can count the records for accuracy.

SELECT * FROM s;