MQTT Protocol use for EPIC datalogging in MySQL

MQTT/SparkplugB & OPC UA
1

Hey guys,

Can I use MQTT Protocol for EPIC datalogging into MySQL?

If yes, Then kindly provide some steps.

Thanks & Regards,
Aanand

2

While I have not done it, it should go something like this.
image

Configure your broker details in the MQTT node.

Here is some pseudo code for the function node.
image

Lastly, configure the MySQL Node with the server details and database name.

3

It’s working. Thanks Beno.

My Application is to punch Groov EPIC data (every 5 minutes) into database without using Optodatalink.
1)I have directly punched data using Node-red through MySQL node.
2)I have punched data using MQTT Node into MySQL.
In both case, I need to use Node-Red.

Then what is the best option, I have to choose from both?
I didn’t find any advantage of MQTT in this application. If I miss something then please tell me.

Thanks & Regards,
Aanand

4

MQTT works best if you have many sites.

5

To clarify, do you mean if you have many subscribers to the message queue or MQTT is best in general?

6

@philip Good catch, I meant subscribers.
Since he is only pushing data one way to a database, there is no advantage to MQTT in this case.

7

Thanks a lot, Guys,

Thanks & Regards,
Aanand