This section will go over common configuration procedures for the Pivot server. See also the full detail view of the config API.
You need to tell Pivot where to save its state.
Pivot can save state in either a local SQLite file or a database (for clustering).
The simplest place to save Pivot's state is in a SQLite file located somewhere relative to the config. To do so, add the following to the config:
stateStore:
type: sqlite
connection: ./pivot-settings.sqlite
For clustering to work, Pivot's state needs to be saved in an external database. To do so, add the following to the config:
stateStore:
type: mysql
connection: 'mysql://username:password@hostname:3306/database'
tablePrefix: 'imply-state-'
This will create a number of tables, all of which will be prefixed with the supplied tablePrefix
.
Note: currently only MySQL (mysql
), Postgres (pg
), and SQLite (sqlite
) are supported as state stores.