Sensys Database Multi Select

To enhance the flexibility of logging data to the database as well as a pub-sub interface simultaneously, Sensys now allows users to specify more than one database plugin to log the environmental and event data.

An MCA parameter db is provided to specify a list of database plugins to enable to log the environmental and event data when running the orcmd aggregator daemon. The MCA parameter is a comma separated list of supported database plugin names. In order to correctly enable all the specified database plugins the users must also provide the correct connection MCA parameters.

Examples:

The following command means a connection to postgres and zeromq is set up so environmental and event data are logged both in the provided database and published to all subscribers:

% orcmd --omca db postgres,zeromq --omca zeromq_bind_port=55067 --omca db_postgres_uri=127.0.0.1 --omca db_postgres_database=test_db --omca db_postgres_user=testuser:testpassword

The next command means all supported plugins should be enabled and used to log the environmental and event data:

% orcmd --omca db postgres,zeromq,print,odbc

If the db MCA parameter is not provided, the database plugin with the highest priority is selected in the following order, so long as the corresponding MCA parameters are provided.

Plugin Priority
postgres 15
odbc 10
print 5
zeromq 3