MyNodeQuery 1.0.2.0 发布,新增Ping节点自定义、仪表盘显示优化等更新

MyNodeQuery 1.0.2.0

MyNodeQuery

简介

MyNodeQuery可以说是代替NodeQuery的个人版,一款简洁好用的探针,支持Telegram节点离线通知、自定义Ping节点、还有网速、流量等报表。

演示站点:https://status.idcoffer.com

Telegram 交流群组:https://t.me/cloudshare

使用

依赖

  • MySql 5.7 或更高版本;
  • Redis (可选)
  • Docker

安装

目前仅提供docker版本

docker run -d --name=mynodequery -p 5000:5000 jaydenlee2019/mynodequery:latest

如何解决每次更新都要从新Install的问题?

创建一个文本 /etc/mynodequery/appsettings.json,内容为:

{
 "Logging": {
     "LogLevel": {
         "Default": "Information",
         "Microsoft": "Warning",
         "Microsoft.Hosting.Lifetime": "Information"
     }
 },
 "MySql": {
     "ConnectionString": ""
 },
 "AllowedHosts": "*",
 "Installed": "false",
 "ReadNodeIpHeaderKey": "X-Real-IP"
}

在docker run 语句中加入 -v /etc/mynodequery/appsettings.json:/app/appsettings.json 即可解决,如:

docker run -d --name=mynodequery -p 5000:5000 -v /etc/mynodequery/appsettings.json:/app/appsettings.json jaydenlee2019/mynodequery:latest

更新

1.0.2.0

  1. 增加站点标题可设置;
  2. 仪表盘同时显示上行和下行网速;
  3. 优化访问速度;
  4. 增加Ping节点分组功能,节点可以自定义分组;
  5. 解决已知bug
  6. 更新注意事项:如果是从1.0.1.4或更早版本升级,请在MySql客户端执行以下SQL语句:
alter table md_ping_nodes add PingNodeGroupID int; 
update md_ping_nodes set PingNodeGroupID=1 where PingNodeGroupID is null; 
alter table `md_ping_nodes` MODIFY COLUMN `ID`  int NOT NULL AUTO_INCREMENT FIRST ;

alter table md_nodes add PingNodeGroupID int default 1;
update md_nodes set PingNodeGroupID=1 where PingNodeGroupID is null; 

CREATE TABLE md_ping_node_groups ( 
ID int(11) NOT NULL AUTO_INCREMENT, 
Name varchar(100) DEFAULT NULL, 
IsDefault bit default 0, 
IsDelete bit default 0, 
PRIMARY KEY (`ID`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
INSERT INTO md_ping_node_groups (`ID`, Name, IsDefault, `IsDelete`) VALUES ('1', '默认分组', b'1', b'0');

alter table bd_node_requests ADD INDEX `ix_bd_node_requests` (`NodeID`,`CreateMinute`,`Ping1`,`Ping2`,`Ping3`,`Ping4`,`Ping5`) USING BTREE;
alter table bd_node_requests ADD INDEX `ix_bd_node_requests_TXRXGap` (`NodeID`,`CreateMinute`,`TXGap`,`RXGap`) USING BTREE;
alter table bd_node_requests ADD INDEX `ix_bd_node_requests_RAMUsage` (`NodeID`,`CreateMinute`,`RAMUsage`,`SwapUsage`) USING BTREE;
alter table bd_node_requests ADD INDEX `ix_bd_node_requests_Load` (`NodeID`,`CreateMinute`,`LoadCPU`,`Load1`,`LoadIO`) USING BTREE;
alter table bd_node_requests ADD INDEX `ix_bd_node_requests_DiskUsage` (`NodeID`,`CreateMinute`,`DiskUsage`) USING BTREE;

……

项目地址:https://hub.docker.com/r/jaydenlee2019/mynodequery