MySQL Database Upload

Note:

• 1. An upstream acquisition plugin is required, or acquisition configuration contains no data.
• 2. Once selected, a scheme’s state and contents cannot be changed in its acquisition node.

1. Create nodes

(1) Open CommBridge Digital Twin and switch to Device Connectivity.

(2) Drag Serial Communication, Data Processing, and MySQL Database Upload into the workspace to create three nodes.

(3) Connect Serial Communication → Data Processing → MySQL Database Upload.

2. Create a scheme

(1) Double-click MySQL Database Upload and select Add scheme.

(2) Enter connection settings and select Next.

(3) Select Add group, enter group information, and confirm.

(4) Select data to upload and confirm.

(5) Select Finish to add the upload scheme.

(6) Enable the scheme and select Save.

3. View results

(1) Select Deploy under Device Connectivity and wait for success.

(2) Switch to Digital Twin and hover over MySQL Database Upload to show node information.

(3) Open MySQL Workbench, then the corresponding database and table to view uploaded content.

4. Configuration reference

Connection settings

Parameter	Description	Format	Example
Scheme name	User-defined scheme name	Nonempty	MQTT upload
Host	MySQL database address	Nonempty	172.21.78.201
Port	MySQL database port	0-65535	1883
Username	MySQL connection username	Unrestricted
Password	MySQL authentication password	Unrestricted
Connection protocol	MySQL connection protocol	JDBC	JDBC

Add groups

Parameter	Description	Format	Example
Group name	User-defined group name	Nonempty	MySQL group 1
Database name	Target MySQL database	Nonempty	test_schame
Table name	Target MySQL table	0-4294967295	test_table
Update method	Database update operation	insert or upsert	insert
Upload interval (ms)	MySQL upload interval	0-4294967295	1000
Aggregate upload	Whether to upload data together	Yes or No	No

Select data

Select schemes configured in upstream acquisition data. Only selected schemes can upload to MySQL.