/!40111 SET SQL_NOTES=@OLD_SQL_NOTES/;
核心机制总结
在结构化Block入库中,入库字段如下:。
* puidworker_idworker_full_namejob_idheighthash
#-l指定日志目录
//比特币节点
{
rpc_addr = ""; //rpc地址
}
;
//kafka群集
kafka = {
};
//mysql配置,用于存储检测到的块
pooldb = {
host = "";
port = 3306;
dbname = "";
};
found_块数据库结构
-- ------------------------------------------------------
/!40101 SET NAMES utf8/;
/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE/;
/!40103 SET TIME_ZONE='+00:00'/;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0/;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'/;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0/;
--
DROP TABLE IF EXISTS found_blocks;
CREATE TABLE found_blocks
puid int NOT NULL,
worker_id bigint NOT NULL,
height int NOT NULL,
hash char NOT NULL,
size int NOT NULL,
prev_hash char NOT NULL,
UNIQUE KEY hash ,
KEY height
--
DROP TABLE IF EXISTS found_nmc_blocks;
CREATE TABLE found_nmc_blocks
aux_block_hash char NOT NULL,
aux_pow text NOT NULL,
UNIQUE KEY aux_block_hash
--
worker_id bigint NOT NULL,
puid int NOT NULL,
group_id int NOT NULL,
UNIQUE KEY puid_worker_id ,
KEY puid_group_id
--
worker_id bigint NOT NULL,
puid int NOT NULL,
group_id int NOT NULL,
UNIQUE KEY puid_worker_id ,
KEY puid_group_id
/!40103 SET TIME_ZONE=@OLD_TIME_ZONE/;
/!40101 SET SQL_MODE=@OLD_SQL_MODE/;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS/;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES/;
CREATE TABLE `found_blocks`
`puid` int NOT NULL,
`worker_id` bigint NOT NULL,
`height` int NOT NULL,
`hash` char NOT NULL,
`size` int NOT NULL,
`prev_hash` char NOT NULL,
UNIQUE KEY `hash` ,
KEY `height`
1d
发表评论