Prerequisites
- pool.js >= 6.x
- MySQL/MariaDB
- Load the database schema
Install
Collection Service
npm install -g traaittplatform-pool-monitorexport MYSQL_HOST=<server ip>export MYSQL_PORT=<server port>export MYSQL_USERNAME=<server username>export MYSQL_PASSWORD=<server password>export MYSQL_DATABASE=<database>traaittplatform-pool-monitor
Additional Options
export MYSQL_SOCKET=<server socket path >export MYSQL_CONNECTION_LIMIT=<# of maximum server connections >export HISTORY_DAYS=<# of days to keep history >export UPDATE_INTERVAL=<# of seconds between updating pool list >export POLLING_INTERVAL=<# of seconds between checking pools >export POOL_LIST_URL=<Full URL to pool list >
As a Module for Pulling Stats
npm install --save traaittplatform-pool-monitor
Sample Code
const StatsDatabase = const db = host: 'localhost' port: 3306 username: 'root' password: 'password' database: 'traaittplatform' connectionLimit: 10 db
Database Schema
NOT EXISTS `pools` ( `id` VARCHAR(64) NOT NULL, `name` VARCHAR(255) NOT NULL, `url` VARCHAR(255) NOT NULL, `api` VARCHAR(255) NOT NULL, `type` VARCHAR(255) NOT NULL, `miningAddress` VARCHAR(255) NOT NULL, `mergedMining` INT(1) NOT NULL DEFAULT 0, `mergedMiningIsParentChain` INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `type` (`type`), KEY `mergedMining` (`mergedMining`), KEY `mergedMiningIsParentChain` (`mergedMiningIsParentChain`)) engine = innodb DEFAULT charset = utf8 ROW_FORMAT = COMPRESSED; ( `id` VARCHAR(64) NOT NULL, `timestamp` BIGINT(1) UNSIGNED NOT NULL, `height` BIGINT(20) NOT NULL DEFAULT 0, `hashrate` BIGINT(20) NOT NULL DEFAULT 0, `miners` BIGINT(20) NOT NULL DEFAULT 0, `fee` DOUBLE NOT NULL DEFAULT 0, `minPayout` BIGINT(20) NOT NULL DEFAULT 0, `lastBlock` BIGINT(20) NOT NULL DEFAULT 0, `donation` DOUBLE NOT NULL DEFAULT 0, `status` INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`, `timestamp`), KEY `status` (`status`), KEY `lastBlock` (`lastBlock`)) engine = innodb DEFAULT charset = utf8 ROW_FORMAT = COMPRESSED;
Author
The TurtCoin Developers
- Twitter: @traaittplatform
- Github: @traaittplatform
License
Copyright © 2019 The TurtCoin Developers.
This project is AGPL-3.0 licensed.