Data Metering with MySQL Audit Plugin

Data Metering

Data metering is accomplished by a UseaBiLLity MySQL plugin. MySQL has a well-defined architecture for adding custom plugins to the database that can implement a variety of functions, the most well known of these being storage engine plugins. Another type of plugin, Audit, provides a pluggable audit interface that enables information about server operations to be reported to interested parties. For more on MySQL plugin architecture go to the MySQL website.

UseaBiLLity Metering Profile

The UseaBiLLity service uses an audit plugin to track and record all creates, reads, updates and deletes in the MySQL database. Once a map of database events to business metrics has been established and the data metering plugin has been deployed, the UseaBiLLity service pushes down instructions, a metering profile, to the plugin directing it to deliver the results for a specific set of database events on a defined schedule (daily, monthly, quarterly, etc.) to the UseaBiLLity server. Results are encrypted and stored by the plug-in until a scheduled secure transmission to the UseaBiLLity server. Here's a graphic that outlines the process of instrumenting a MySQL application for data metering.

Start by mapping the application to create a metering profile

Download the metering profile to the UseaBiLLity MySQL Plugin

The UseaBiLLity plugin collects metered database events, aggregates and
encrypts them,  and delivers the result via secure transmission to the UseaBiLLity server

UseaBiLLity makes the metered data available for a variety of uses