Local database
Local Database
A local database is where the data will be stored on the local device. You can set up multiple buckets and choose the Default retention policy and Default downsample retention policy. You can also select if the data stored is important or not. (explanation below)
Database configuration
When the advanced settings are enabled in the General tab, the following settings are enabled:
| Field | Function |
|---|---|
| Name | Name used in config platform db for this db config |
| Address | Local db instance ip address |
| Port | Local db instance port |
Local database buckets
| Field | Function |
|---|---|
| ID | Unique identifier for the bucket, is used in the measurements section |
| DB name | Name of he local database. Pattern: ^[a-zA-Z][a-zA-Z0-9]*$ |
| RP name | Name of the retention policy. Pattern: ^[a-zA-Z]*$ |
| RP duration | The duration of the local retention policy. Pattern: ^(\d)*[smhd]$ |
| Default RP | Make this bucket the default RP for raw data |
| Default downsample RP | Make this bucket the default RP for downsampled data |
| Important | If this is checked, capture will not delete data from this bucket in case the Min storage available threshold is almost reached (see more info below) |
Automatic data deletion
When your plc is almost running out of available data storage, the Capture system will start deleting data. In the General tab, under Advanced settings, you were able to choose the Min storage available. Capture will start deleting data when the available storage is less than 1.5 times this value (e.g. 150 MB when MSA is 100 MB). However, if you select the important option for a bucket, this will not be done for that bucket.