Red Hat Camel K is deprecated
Red Hat Camel K is deprecated and the End of Life date for this product is June 30, 2025. For help migrating to the current go-to solution, Red Hat build of Apache Camel, see the Migration Guide.53.3. 使用方法
本节论述了如何使用 mysql-sink
。
53.3.1. Knative Sink
您可以通过将 mysql-sink
Kamelet 绑定到 Knative 对象来将 mysql-sink Kamelet 用作 Knative sink。
mysql-sink-binding.yaml
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
name: mysql-sink-binding
spec:
source:
ref:
kind: Channel
apiVersion: messaging.knative.dev/v1
name: mychannel
sink:
ref:
kind: Kamelet
apiVersion: camel.apache.org/v1alpha1
name: mysql-sink
properties:
databaseName: "The Database Name"
password: "The Password"
query: "INSERT INTO accounts (username,city) VALUES (:#username,:#city)"
serverName: "localhost"
username: "The Username"
Copy to clipboardCopied53.3.1.1. 前提条件
确保已将 "Red Hat Integration - Camel K" 安装到您连接到的 OpenShift 集群中。
53.3.1.2. 使用集群 CLI 的步骤
-
将
mysql-sink-binding.yaml
文件保存到本地驱动器中,然后根据需要编辑该文件。 使用以下命令运行 sink:
Copy to clipboardCopiedoc apply -f mysql-sink-binding.yaml
53.3.1.3. 使用 Kamel CLI 的步骤
使用以下命令配置并运行 sink:
kamel bind channel:mychannel mysql-sink -p "sink.databaseName=The Database Name" -p "sink.password=The Password" -p "sink.query=INSERT INTO accounts (username,city) VALUES (:#username,:#city)" -p "sink.serverName=localhost" -p "sink.username=The Username"
Copy to clipboardCopied此命令在集群的当前命名空间中创建 KameletBinding。
53.3.2. Kafka Sink
您可以通过将 mysql-sink
Kamelet 绑定到 Kafka 主题,将 mysql-sink Kamelet 用作 Kafka 接收器。
mysql-sink-binding.yaml
apiVersion: camel.apache.org/v1alpha1
kind: KameletBinding
metadata:
name: mysql-sink-binding
spec:
source:
ref:
kind: KafkaTopic
apiVersion: kafka.strimzi.io/v1beta1
name: my-topic
sink:
ref:
kind: Kamelet
apiVersion: camel.apache.org/v1alpha1
name: mysql-sink
properties:
databaseName: "The Database Name"
password: "The Password"
query: "INSERT INTO accounts (username,city) VALUES (:#username,:#city)"
serverName: "localhost"
username: "The Username"
Copy to clipboardCopied53.3.2.1. 先决条件
确保您已在 OpenShift 集群中安装了 AMQ Streams Operator,并在当前命名空间中创建一个名为 my-topic
的主题。另外,请确保已将 "Red Hat Integration - Camel K" 安装到您连接到的 OpenShift 集群中。
53.3.2.2. 使用集群 CLI 的步骤
-
将
mysql-sink-binding.yaml
文件保存到本地驱动器中,然后根据需要编辑该文件。 使用以下命令运行 sink:
Copy to clipboardCopiedoc apply -f mysql-sink-binding.yaml
53.3.2.3. 使用 Kamel CLI 的步骤
使用以下命令配置并运行 sink:
kamel bind kafka.strimzi.io/v1beta1:KafkaTopic:my-topic mysql-sink -p "sink.databaseName=The Database Name" -p "sink.password=The Password" -p "sink.query=INSERT INTO accounts (username,city) VALUES (:#username,:#city)" -p "sink.serverName=localhost" -p "sink.username=The Username"
Copy to clipboardCopied此命令在集群的当前命名空间中创建 KameletBinding。