CKafka allows you to dump messages to TencentDB for MySQL to persistently store filtered data.
Currently, this feature relies on the SCF and TencentDB for MySQL services, which should be activated first before you can use this feature.
Message dump to TencentDB for MySQL will be performed with the CKafka trigger in SCF.
Log in to the CKafka console.
Click Instance List on the left sidebar and click the ID/Name of the target instance to enter the instance details page.
On the instance details page, select the Topic Management tab and click Message Dump in the Operation column.
Click Add Message Dump and select General template as the dump type.
After the creation is completed, click the Function Management link to enter the SCF console for the next step.
Upload the code of the CKafkaToMysql template (available on GitHub) to the SCF console.
Add the following environment variables in Function Configuration of the function.
dbhost=172.16.0.59 // Databases VPC host address dbuser=tabor // Database username dbpwd=1237018 // Database password dbdatabase=canmengtest // Database name dbtable=123321 // Table name
Modify the VPC in Function Configuration to make the VPC of the function the same as that of TencentDB.
In the TencentDB for MySQL DMC console, add the relevant databases, tables, and table structures.
Create a database with the same name as in the environment variables:
Create a table with the same name as in the environment variables:
Create a table structure with the same insertion structure as in the function code.
Megs will be inserted to by default. You can modify the insertion structure on line 33 in the
You can also run a TencentDB for MySQL command to directly create tables and data structures:
CREATE TABLE `test_table` ( `offset` VARCHAR(255) NOT NULL , `Megs` LONGTEXT NOT NULL ) ENGINE = InnoDB;
Enable the CKafka trigger on the trigger management page in the SCF console.
CKafkaToMySQLscheme uses the CKafka trigger. For more information on related settings such as retry policy and maximum number of messages, see CKafka Trigger.
msgBodydata of the CKafka trigger by default. If you want to process the logic by yourself, see Event Message Structure for CKafka Trigger.