Kafka入门，mysql5.7 Kafka-Eagle部署（二十五）

最新推荐文章于 2024-04-21 11:36:46 发布
最新推荐文章于 2024-04-21 11:36:46 发布
阅读量670 收藏
点赞数 2
文章标签： kafka 分布式
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43205308/article/details/131647593
版权

官网

https://www.kafka-eagle.org/

下载解压

这里使用的是2.0.8

创建mysql数据库

创建名为ke数据库,新版本会自动创建，不会创建的话，自己手动创建，不然会报查不到相关表信息错误

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
 
-- ----------------------------
-- Table structure for ke_alarm_clusters
-- ----------------------------
DROP TABLE IF EXISTS `ke_alarm_clusters`;
CREATE TABLE `ke_alarm_clusters`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `server` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `alarm_group` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `alarm_times` int NULL DEFAULT NULL,
  `alarm_max_times` int NULL DEFAULT NULL,
  `alarm_level` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `is_normal` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y',
  `is_enable` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y',
  `created` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_alarm_clusters
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_alarm_config
-- ----------------------------
DROP TABLE IF EXISTS `ke_alarm_config`;
CREATE TABLE `ke_alarm_config`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `alarm_group` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `alarm_type` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `alarm_url` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `http_method` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `alarm_address` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `created` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`cluster`, `alarm_group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_alarm_config
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_alarm_consumer
-- ----------------------------
DROP TABLE IF EXISTS `ke_alarm_consumer`;
CREATE TABLE `ke_alarm_consumer`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `group` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `topic` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `lag` bigint NULL DEFAULT NULL,
  `alarm_group` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `alarm_times` int NULL DEFAULT NULL,
  `alarm_max_times` int NULL DEFAULT NULL,
  `alarm_level` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `is_normal` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y',
  `is_enable` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y',
  `created` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_alarm_consumer
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_alarm_crontab
-- ----------------------------
DROP TABLE IF EXISTS `ke_alarm_crontab`;
CREATE TABLE `ke_alarm_crontab`  (
  `id` bigint NOT NULL,
  `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `crontab` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `is_enable` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'Y',
  `created` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_alarm_crontab
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_connect_config
-- ----------------------------
DROP TABLE IF EXISTS `ke_connect_config`;
CREATE TABLE `ke_connect_config`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `connect_uri` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `version` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `alive` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `created` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_connect_config
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_consumer_bscreen
-- ----------------------------
DROP TABLE IF EXISTS `ke_consumer_bscreen`;
CREATE TABLE `ke_consumer_bscreen`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `group` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `topic` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `logsize` bigint NULL DEFAULT NULL,
  `difflogsize` bigint NULL DEFAULT NULL,
  `offsets` bigint NULL DEFAULT NULL,
  `diffoffsets` bigint NULL DEFAULT NULL,
  `lag` bigint NULL DEFAULT NULL,
  `timespan` bigint NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  INDEX `idx_timespan`(`timespan`) USING BTREE,
  INDEX `idx_tm_cluster_diffoffsets`(`tm`, `cluster`, `diffoffsets`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_consumer_bscreen
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_consumer_group
-- ----------------------------
DROP TABLE IF EXISTS `ke_consumer_group`;
CREATE TABLE `ke_consumer_group`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `group` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `topic` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` int NULL DEFAULT NULL,
  PRIMARY KEY (`cluster`, `group`, `topic`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_consumer_group
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_consumer_group_summary
-- ----------------------------
DROP TABLE IF EXISTS `ke_consumer_group_summary`;
CREATE TABLE `ke_consumer_group_summary`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `group` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `topic_number` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `coordinator` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `active_topic` int NULL DEFAULT NULL,
  `active_thread_total` int NULL DEFAULT NULL,
  PRIMARY KEY (`cluster`, `group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_consumer_group_summary
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_logsize
-- ----------------------------
DROP TABLE IF EXISTS `ke_logsize`;
CREATE TABLE `ke_logsize`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `topic` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `logsize` bigint NULL DEFAULT NULL,
  `diffval` bigint NULL DEFAULT NULL,
  `timespan` bigint NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  INDEX `idx_timespan`(`timespan`) USING BTREE,
  INDEX `idx_tm_topic`(`tm`, `topic`) USING BTREE,
  INDEX `idx_tm_cluster_diffval`(`tm`, `cluster`, `diffval`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_logsize
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_metrics
-- ----------------------------
DROP TABLE IF EXISTS `ke_metrics`;
CREATE TABLE `ke_metrics`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `broker` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `key` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `value` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `timespan` bigint NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_metrics
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_metrics_offline
-- ----------------------------
DROP TABLE IF EXISTS `ke_metrics_offline`;
CREATE TABLE `ke_metrics_offline`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `key` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `one` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mean` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `five` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `fifteen` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`cluster`, `key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_metrics_offline
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_p_role
-- ----------------------------
DROP TABLE IF EXISTS `ke_p_role`;
CREATE TABLE `ke_p_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'role name',
  `seq` tinyint NOT NULL COMMENT 'rank',
  `description` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'role describe',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_p_role
-- ----------------------------
INSERT INTO `ke_p_role` VALUES (1, 'Administrator', 1, 'Have all permissions');
INSERT INTO `ke_p_role` VALUES (2, 'Devs', 2, 'Own add or delete');
INSERT INTO `ke_p_role` VALUES (3, 'Tourist', 3, 'Only viewer');
 
-- ----------------------------
-- Table structure for ke_resources
-- ----------------------------
DROP TABLE IF EXISTS `ke_resources`;
CREATE TABLE `ke_resources`  (
  `resource_id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'resource name',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `parent_id` int NOT NULL,
  PRIMARY KEY (`resource_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_resources
-- ----------------------------
INSERT INTO `ke_resources` VALUES (1, 'System', '/system', -1);
INSERT INTO `ke_resources` VALUES (2, 'User', '/system/user', 1);
INSERT INTO `ke_resources` VALUES (3, 'Role', '/system/role', 1);
INSERT INTO `ke_resources` VALUES (4, 'Resource', '/system/resource', 1);
INSERT INTO `ke_resources` VALUES (5, 'Notice', '/system/notice', 1);
INSERT INTO `ke_resources` VALUES (6, 'Topic', '/topic', -1);
INSERT INTO `ke_resources` VALUES (7, 'Message', '/topic/message', 6);
INSERT INTO `ke_resources` VALUES (8, 'Create', '/topic/create', 6);
INSERT INTO `ke_resources` VALUES (9, 'Alarm', '/alarm', -1);
INSERT INTO `ke_resources` VALUES (10, 'Add', '/alarm/add', 9);
INSERT INTO `ke_resources` VALUES (11, 'Modify', '/alarm/modify', 9);
INSERT INTO `ke_resources` VALUES (12, 'Cluster', '/cluster', -1);
INSERT INTO `ke_resources` VALUES (13, 'ZkCli', '/cluster/zkcli', 12);
INSERT INTO `ke_resources` VALUES (14, 'UserDelete', '/system/user/delete', 1);
INSERT INTO `ke_resources` VALUES (15, 'UserModify', '/system/user/modify', 1);
INSERT INTO `ke_resources` VALUES (16, 'Mock', '/topic/mock', 6);
INSERT INTO `ke_resources` VALUES (18, 'Create', '/alarm/create', 9);
INSERT INTO `ke_resources` VALUES (19, 'History', '/alarm/history', 9);
INSERT INTO `ke_resources` VALUES (20, 'Manager', '/topic/manager', 6);
INSERT INTO `ke_resources` VALUES (21, 'PasswdReset', '/system/user/reset', 1);
INSERT INTO `ke_resources` VALUES (22, 'Config', '/alarm/config', 9);
INSERT INTO `ke_resources` VALUES (23, 'List', '/alarm/list', 9);
INSERT INTO `ke_resources` VALUES (24, 'Hub', '/topic/hub', 6);
 
-- ----------------------------
-- Table structure for ke_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `ke_role_resource`;
CREATE TABLE `ke_role_resource`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` int NOT NULL,
  `resource_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_role_resource
-- ----------------------------
INSERT INTO `ke_role_resource` VALUES (1, 1, 1);
INSERT INTO `ke_role_resource` VALUES (2, 1, 2);
INSERT INTO `ke_role_resource` VALUES (3, 1, 3);
INSERT INTO `ke_role_resource` VALUES (4, 1, 4);
INSERT INTO `ke_role_resource` VALUES (5, 1, 5);
INSERT INTO `ke_role_resource` VALUES (6, 1, 7);
INSERT INTO `ke_role_resource` VALUES (7, 1, 8);
INSERT INTO `ke_role_resource` VALUES (8, 1, 10);
INSERT INTO `ke_role_resource` VALUES (9, 1, 11);
INSERT INTO `ke_role_resource` VALUES (10, 1, 13);
INSERT INTO `ke_role_resource` VALUES (11, 2, 7);
INSERT INTO `ke_role_resource` VALUES (12, 2, 8);
INSERT INTO `ke_role_resource` VALUES (13, 2, 13);
INSERT INTO `ke_role_resource` VALUES (14, 2, 10);
INSERT INTO `ke_role_resource` VALUES (15, 2, 11);
INSERT INTO `ke_role_resource` VALUES (16, 1, 14);
INSERT INTO `ke_role_resource` VALUES (17, 1, 15);
INSERT INTO `ke_role_resource` VALUES (18, 1, 16);
INSERT INTO `ke_role_resource` VALUES (19, 1, 18);
INSERT INTO `ke_role_resource` VALUES (20, 1, 19);
INSERT INTO `ke_role_resource` VALUES (21, 1, 20);
INSERT INTO `ke_role_resource` VALUES (22, 1, 21);
INSERT INTO `ke_role_resource` VALUES (23, 1, 22);
INSERT INTO `ke_role_resource` VALUES (24, 1, 23);
INSERT INTO `ke_role_resource` VALUES (25, 1, 24);
 
-- ----------------------------
-- Table structure for ke_sql_history
-- ----------------------------
DROP TABLE IF EXISTS `ke_sql_history`;
CREATE TABLE `ke_sql_history`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `host` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ksql` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `status` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `spend_time` bigint NULL DEFAULT NULL,
  `created` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_sql_history
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_topic_rank
-- ----------------------------
DROP TABLE IF EXISTS `ke_topic_rank`;
CREATE TABLE `ke_topic_rank`  (
  `cluster` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `topic` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `tkey` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `tvalue` bigint NULL DEFAULT NULL,
  PRIMARY KEY (`cluster`, `topic`, `tkey`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_topic_rank
-- ----------------------------
 
-- ----------------------------
-- Table structure for ke_user_role
-- ----------------------------
DROP TABLE IF EXISTS `ke_user_role`;
CREATE TABLE `ke_user_role`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `role_id` tinyint NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_user_role
-- ----------------------------
INSERT INTO `ke_user_role` VALUES (1, 1, 1);
 
-- ----------------------------
-- Table structure for ke_users
-- ----------------------------
DROP TABLE IF EXISTS `ke_users`;
CREATE TABLE `ke_users`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `rtxno` int NOT NULL,
  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `realname` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
 
-- ----------------------------
-- Records of ke_users
-- ----------------------------
INSERT INTO `ke_users` VALUES (1, 1000, 'admin', '123456', 'admin@email.com', 'Administrator');
 
SET FOREIGN_KEY_CHECKS = 1;

配置环境遍历

# kafkaEFAK
export KE_HOME=/usr/local/src/kafka-eagle/kafka-eagle-bin-2.0.8/efak-web-2.0.8
export PATH=$PATH:$KE_HOME/bin

在这里插入图片描述
记得source

source /etc/profile.d/my_env.sh

修改配置

vim $KE_HOME/conf/system-config.properties

多余的配置去掉
在这里插入图片描述
在这里插入图片描述

如果发现启动失败，可能是mysql版本不同，导致连不上数据库，可以看下日志报错，以下配置是5.7版本的

efak.driver=com.mysql.jdbc.Driver
efak.url=jdbc:mysql://hadoop100:3306/ke?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT
efak.username=root
efak.password=*****

启动

ke.sh start

初始化账号密码 admin 123456
在这里插入图片描述

Long long ago.
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
kafkaeagle mysql_kafka eagle 使用教程
weixin_36202273的博客
02-10 979
下载环境Windows：安装JDK并配置JDK环境变量KE_HOME=D:Programskafka-eagle-web-1.2.0Linux:安装JDK并配置环境变量export KE_HOME=/opt/kafka-eagle-web-1.2.0export PATH=$PATH:$KE_HOME/binke数据库准备将kafka-eagle-web...
kafkaeagle mysql_kafka-eagle监控和管理kafka
weixin_33158756的博客
02-03 254
kafka-eagle监控和管理kafka最近想做一个kafka监控，本来准备用zabbix来监控的，需要重复造轮子，本来准备用kafka-Manager的，在GitHub上无意发现了kafka-eagle，看了官方介绍准备试一下.....下载地址部署前提：部署好java环境，JDK8+(1)、下载需要的版本到服务器上，我下载的是最新版本wget https://github.com/smartl...
kafkaeagle mysql_Kafka(06) Kafka监控-Kafka Eagle
weixin_42554408的博客
02-17 144
本文概览：介绍Kafka Eagle的部署和简单实用1 部署1、下载地址github地址2、配置环境变量sudo vi /etc/profile，添加如下内容：export KE_HOME=/Users/wuzhonghu/local/kafka-eagle-bin-1.2.1/kafka-eagle-web-1.2.11exportKE_HOME=/Users/wuzhonghu/local/k...
第6章 Kafka-Eagle监控【Kafka】
最新发布
小心星的博客
04-21 598
第6章 Kafka-Eagle监控【Kafka】
mysql simpleconsumer_Kafka实战宝典：监控利器kafka-eagle
weixin_39757743的博客
02-17 92
概述Kafka作为当前最流行的消息中间件广泛用于流式数据的中间存储，其界面化管理工具有多种，其中Kafka Eagle(简称KE)能够实现比Kafka的其他界面化管理工具更加丰富的操作和监控选项，最突出的功能是使用Kafka提供的JMX端口实现了Kafka读取数据的图表化监控、移植ZKCli到前端操作、Kafka SQL实时消费，并提供用户管理功能。该系统由《Kafka并不难学！入门、进阶、商业实...
kafka-eagle-2.0.3的ke数据库脚本
12-10
kafka-eagle-2.0.3安装如果发现eagle不会自动建库建表是，可以下载该sql脚本，自己建库建表
kafka-eagle-bin-2.1.0.tar.gz
07-05
4. 启动：执行`bin/kafka-eagle-start.sh`启动服务，使用`bin/kafka-eagle-stop.sh`停止服务。 5. 访问：在Web浏览器中输入`http://服务器IP:端口`，按照提示进行登录和操作。 ### 使用注意事项 1. 确保运行环境已...
kafka-eagle-2.0.8.tar.gz
12-28
在部署Kafka Eagle 2.0.8时，需要注意的是，用户需要首先解压`kafka-eagle-bin-2.0.8`压缩包，然后按照官方提供的文档进行配置和启动服务。通常，这包括设置环境变量、配置服务器连接信息以及启动Web服务等步骤。 ...
5、kafka监控工具Kafka-Eagle介绍及使用
05-29
在部署 Kafka-Eagle 之前，需要确保 Kafka 和 ZooKeeper 已经正确安装并运行。开启 Kafka 的 JMX 端口是必要的，因为 Kafka-Eagle 需要通过 JMX 接口收集监控数据。JMX 是 Java 平台的一个标准扩展，允许应用程序...
kafka-eagle-bin-2.0.5.tar.gz
07-07
- **配置文件**：修改conf/kafka-eagle-site.xml，配置Kafka集群地址、Zookeeper地址以及其它相关参数。 - **启动服务**：执行bin/kafka-eagle-start.sh脚本启动服务，然后在浏览器中输入http://服务器IP:8080...
kafka-eagle-bin-1.3.2.tar.gz
01-24
安装Kafka Eagle 1.3.2版本，首先需要下载解压`kafka-eagle-bin-1.3.2`压缩包，然后按照以下步骤进行配置： 1. **环境准备**：确保系统已安装Java环境，Kafka集群正常运行。 2. **解压部署**：将压缩包解压到指定...
kafka-eagle
08-23
kafka管理工具
kafka监控工具kafka-eagle
07-01
kafka监控工具kafka-eagle，git下载太慢，更新与2018-07-01
kafka-eagle 2.0.9数据库脚本 MySQL8.0
Bright
01-20 1975
/* Navicat Premium Data Transfer Source Server : aaa Source Server Type : MySQL Source Server Version : 80026 Source Host : localhost:3306 Source Schema : ke Target Server Type : MySQL Target Server Version : 80026
kafkaeagle mysql_kafka-eagle 管理工具安装
weixin_29957761的博客
02-17 290
kafka-eagle 维护kafka集群提供一个监控工具，可以很容易发现分布在集群中的哪些topic分布不均，或者分区在整个集群中分布不均的情况。它支持管理多个集群、选择副本、副本重新分配以及创建Topic。同时，这个管理工具也是一个非常好的可以快速浏览这个集群的工具环境要求安装JDK、数据库、zk和kafka服务启动系统配置 JAVA_HOME和KE_HOME数据库sqllite或mysqlk...
mysql show profilke_Kafka 消息监控 - Kafka Eagle
weixin_42516642的博客
02-04 96
1.概述Kafka Eagle 用于监控 Kafka 集群中 Topic 被消费的情况。包含 Lag 的产生，Offset 的变动，Partition 的分布，Owner ，Topic 被创建的时间和修改的时间等信息。本文安装的版本是Kafka Eagle 1.1.4(之前试用了一下2.解压 Kafka Eagle解压下载的压缩包，如下图所示：tar -zxvf kafka-eagle-${ver...
Kafka Eagle连接mysql问题
qq_42599616的博客
07-08 1644
Kafka Eagle安装问题一、问题描述二、解决方法三、Eagle链接 一、问题描述 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. 无法连接mysql 二、解决方法 其主要问题是mysql驱动过低， 需要用更高版本的的Eagle 本人尝试过从1.2版本起，到2.0版本的Eagle，仍然无法连接上mysql 8.0.
kafka之Eagle 监控
花&败
04-10 906
一、环境准备 Kafka-Eagle 框架可以监控 Kafka 集群的整体运行情况，在生产环境中经常使用。 1、准备一台mysql Kafka-Eagle 的安装依赖于 MySQL，MySQL 主要用来存储可视化展示的数据。 这里我们使用之前安装的mysql8.0 2、Kafka 环境准备 使用之前安装的kafka集群 二、Kafka-Eagle 安装 1、首先修改kafka集群的/home/dhapp/software/kafka_2....
Kafka运维监控：Kafka-Eagle安装
m0_53400772的博客
06-08 1192
kafka自身并没有集成监控管理系统，因此对kafka的监控管理比较不便，好在有大量的第三方监控管理系统来使用，常见的有：Kafka Manager（雅虎开源的Kafka集群管理器）还有JMX接口自开发监控管理系统。
kafka中kraft协议配置kafka-eagle
08-22
要在kafka中配置kafka-eagle以使用kraft协议，您需要进行以下步骤： 1. 首先，确保您已经安装并准备好了Kafka环境。关闭Kafka集群，您可以使用命令`kf.sh stop`。 2. 在`/opt/module/kafka/bin/kafka-server-start.sh`文件中修改配置。您可以使用命令`vim bin/kafka-server-start.sh`进行编辑。根据引用，您需要在启动Kafka之前分发到其他节点。 3. 确保您已经安装了MySQL作为kafka-eagle的持久化手段。这是监控工具所需的。可以参考引用中的说明来完成这一步骤。 4. 下一步是安装kafka-eagle。kafka-eagle是一个开源的可视化和管理软件，可以用于监控多个Kafka集群、监控 Topic 的消费情况，并提供了Kafka Manager的相关功能。您可以参考引用中的说明来了解更多关于kafka-eagle的信息。 5. 配置kafka-eagle以使用kraft协议。在kafka-eagle的配置文件中，您需要指定kafka集群的地址和端口，并设置适当的协议参数以兼容kraft协议。具体的配置步骤可以参考kafka-eagle的官方文档或者引用中的说明。 请注意，配置kafka-eagle可能会有一些特定的步骤和参数，具体取决于您的环境和需求。因此，建议您参考官方文档和引用中的说明来获得更详细和准确的配置信息。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* [Day547.Kafka-Eagle监控&Kraft模式](https://blog.csdn.net/qq_43284469/article/details/123194372)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *3* [kafka-eagle-web-2.0.2-bin.tar.gz](https://download.csdn.net/download/as4589sd/12897706)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值