[Mosquitto-users] Mosquitto and MySQL

Hello, starting to imagine a "serious" application with Mosquitto (or better, with MQTT and Mosquitto as a broker) I was asking myself if anyone investigated about a best practice for keeping messages archived, for later queries and statistics or any other usage. MySQL is my first choice, as

Re: [Mosquitto-users] Mosquitto and MySQL

Hi Stefano, > Two different approaches: > - modify the broker so that it saves messages directly to MySQL instead of > the present way (flat file? SQLite? What's today??) PRO: best integration > CON: difficult to be maintained and configured At the moment the broker only keeps retained messages w

Re: [Mosquitto-users] Mosquitto and MySQL

Roger Light ha scritto: Hi Stefano, Two different approaches: - modify the broker so that it saves messages directly to MySQL instead of the present way (flat file? SQLite? What's today??) PRO: best integration CON: difficult to be maintained and configured At the moment the broker only keeps