Plan Table

A plan table contains one plan per row:

CREATE TABLE IF NOT EXISTS plans (
  name        VARCHAR(100) NOT NULL PRIMARY KEY,
  plan        BLOB NOT NULL,
  monitor_id  VARCHAR(1000) NULL DEFAULT NULL
) ENGINE=InnoDB

name

The name column is the name of the plan. It can be any string up to 100 characters long. The name is important because it’s used by plan precedence.

plan

The plan column is the full plan in YAML format. This is the exact same content as a plan file: spaces, line breaks, and so on.

monitor_id

The monitor_id column scopes the plan: if set, it’s a monitor plan; if NULL, it’s a shared plan. The value is a config.monitor.id. Since Blip auto-assigns monitor IDs that are not explicitly set, you should explicitly set monitor IDs when using monitor-scoped plans in a table to ensure the two values are equal.

Blip does not create or modify the plan table; you must create it and load the plans (rows).

Grant the necessary MySQL user privileges to read the table if necessary.