Sqlite Persistence

Introduction

Available since version 2.1.

This plugin provides a replacement for the traditional mosquitto persistence normally enabled with persistence true.

This plugin should be preferred when you are interested in persistence, because it saves changes to disk as they are made, where as the traditional persistence only takes periodic snapshots.

Usage

The plugin requires minimal configuration.

The plugin_opt_sync option can be set to extra, full, normal, or off, with a default of normal. This option controls how hard sqlite works to ensure data is on the disk before continuing. This is better described by sqlite themselves.

The plugin_opt_page_size option sets the database page size, as described here.

The plugin_opt_flush_period option is a positive integer number of seconds, defaulting to 5, that the plugin will batch database updates over in order to improve performance.

Config

Windows:

persistence_location <path to save mosquitto.sqlite3>
global_plugin C:\Program Files\Mosquitto\mosquitto_persist_sqlite.dll
plugin_opt_acl_file <my acl file path>

Other:

persistence_location <path to save mosquitto.sqlite3>
global_plugin /path/to/mosquitto_persist_sqlite.so
plugin_opt_acl_file <my acl file path>