Output plugin for pigsty => mysql

npm install pigsty-mysql
4 downloads in the last day
21 downloads in the last week
51 downloads in the last month


This is a mysql output plugin for Pigsty (see https://github.com/threatstack/pigsty).



npm install pigsty-mysql -g

Latest source code from repo

npm install https://github.com/threatstack/pigsty-mysql/tarball/master -g


Please add the following configuration to the output section in /etc/pigsty/pigsty.config.js

output: {

     mysql: {
       user: 'mysql-username',
       password: 'password',
       host: '',
       database: 'snorby',
      // max_pool_size: 5   // optional: # of sql connections;
      // localtime: true    // optional: set to true to disable inserting into UTC. pigsty inserts event in UTC by default.


Known Issues

  • mysql reconnection not handled
  • tcp options table not being inserted


Use the git issues, or send an email to support@threatstack.com


Copyright (C) 2013 Threat Stack, Inc (https://www.threatstack.com)

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.

npm loves you