statsd-mysql-backend
MySQL backend for the [Etsy StatsD] 1
Save statsd counters to a mysql key/value table. Overwrite existing datasets with new counter values.
Vocabulary
ID means the namespace for a metric e.g. the id of a user Key means the name of the metric e.g. how many messages has a user sent yet
Required config values
- mysql.host
- mysql.user
- mysql.password
- mysql.database
- mysql.table
- mysql.pattern ** Regular expression to match the counters that should be stored to mysql
- mysql.pos_key
Match position for the key (usually 1 or 2) - mysql.pos_id
Match position for the id (usually 1 or 2)
Example statsd config
port: 8125 mgmt_port: 8126 backends: "backends/statsd-mysql-backend/lib/index.js" mysql: host: "mysqlhost" user: "user" password: "password" database: "statsd" table: "statistics" pattern: /user\.\./ pos_key: 1 pos_id: 2
MySQL Table format
( `id` int(10) unsigned NOT NULL, `type` varchar(100) NOT NULL, `last_change` int(10) unsigned NOT NULL, `value` int(10) NOT NULL, PRIMARY KEY (`id`,`type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;