MQTT status updates to mysql

I need a simple script that can handle a lot of traffic, able to constantly update the status of each device communicating to a mysql table.

Countless people are already doing this so I don’t want to re-invent the wheel, I just basically want you to mod your existing script to suit my needs.

Once this is working and shown to be reliable, I will ask for more functionality to be added and it may turn into an ongoing work for you.

Specifically;

1. Store device details and update if/when they have changed.
temp, plug #x on/off, topic, power usage, basic info shown in Tasmota GUI.

2. Add new row each time there is a status update. for example, a plug was turned on or off.
3. Add new row each time the device connects for any reason. Minimal info.

The point is to have a historical trail of activities and what happened.
The OS is Linux.