Kafka - eagle installation - Moment For Technology

1. Download address

kafka-eagle

2. Install and configure

2.1 configuration`kafka-eagle`The environment variable

vim /etc/profile

Export KE_HOME = / usr/local/soft/kafka - eagle - web - the 2.0.3 export PATH = $PATH: $KE_HOME/binCopy the code

2.2 to modify`conf/system-config.properties`The configuration file

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# multi zookeeper & kafka cluster list
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
kafka.eagle.zk.cluster.alias=cluster1
cluster1.zk.list=192.168.79.132:2181192168 79.132:2182192168 79.132:2183
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# zookeeper enable acl
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
cluster1.zk.acl.enable=false
cluster1.zk.acl.schema=digest
cluster1.zk.acl.username=test
cluster1.zk.acl.password=test123
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# broker size online list
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
cluster1.kafka.eagle.broker.size=20
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# zk client thread limit
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
kafka.zk.limit.size=32
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka eagle webui port
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
kafka.eagle.webui.port=8048
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka jmx acl and ssl authenticate
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
cluster1.kafka.eagle.jmx.acl=false
cluster1.kafka.eagle.jmx.user=keadmin
cluster1.kafka.eagle.jmx.password=keadmin123
cluster1.kafka.eagle.jmx.ssl=false
cluster1.kafka.eagle.jmx.truststore.location=/Users/dengjie/workspace/ssl/certificates/kafka.truststore
cluster1.kafka.eagle.jmx.truststore.password=ke123456
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka offset storage
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
cluster1.kafka.eagle.offset.storage=kafka
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka jmx uri
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
cluster1.kafka.eagle.jmx.uri=service:jmx:rmi:///jndi/rmi://%s/jmxrmi
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka metrics, 15 days by default
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
kafka.eagle.metrics.charts=true
kafka.eagle.metrics.retain=15
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka sql topic records max
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
kafka.eagle.sql.topic.records.max=5000
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# delete kafka topic token
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
kafka.eagle.topic.token=keadmin
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka sasl authenticate
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
cluster1.kafka.eagle.sasl.enable=false
cluster1.kafka.eagle.sasl.protocol=SASL_PLAINTEXT
cluster1.kafka.eagle.sasl.mechanism=SCRAM-SHA-256
cluster1.kafka.eagle.sasl.jaas.config=org.apache.kafka.common.security.scram.ScramLoginModule required username="kafka" password="kafka-eagle";
cluster1.kafka.eagle.sasl.client.id=
cluster1.kafka.eagle.blacklist.topics=
cluster1.kafka.eagle.sasl.cgroup.enable=false
cluster1.kafka.eagle.sasl.cgroup.topics=
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka ssl authenticate
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka sqlite jdbc driver address
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka.eagle.driver=org.sqlite.JDBC
# kafka.eagle.url=jdbc:sqlite:/hadoop/kafka-eagle/db/ke.db
# kafka.eagle.username=root
# kafka.eagle.password=www.kafka-eagle.org
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# kafka mysql jdbc driver address
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
kafka.eagle.driver=com.mysql.jdbc.Driver
kafka.eagle.url=JDBC: mysql: / / 127.0.0.1:3306 / ke? useSSL=false&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&serverTim ezone=Asia/Shanghai
kafka.eagle.username=root
kafka.eagle.password=root
Copy the code

The Kafka-Eagle database file can be viewed on kafka-Eagle Github, written in a utility class

kafka-eagle github

DROP TABLE IF EXISTS `ke_alarm_clusters`;
CREATE TABLE `ke_alarm_clusters`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `server` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `alarm_group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `alarm_times` int(11) NULL DEFAULT NULL,
  `alarm_max_times` int(11) NULL DEFAULT NULL,
  `alarm_level` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_normal` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Y',
  `is_enable` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Y',
  `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL.PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_alarm_config
-- ----------------------------
DROP TABLE IF EXISTS `ke_alarm_config`;
CREATE TABLE `ke_alarm_config`  (
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alarm_group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `alarm_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `alarm_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `http_method` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `alarm_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL.PRIMARY KEY (`cluster`, `alarm_group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_alarm_consumer
-- ----------------------------
DROP TABLE IF EXISTS `ke_alarm_consumer`;
CREATE TABLE `ke_alarm_consumer`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `topic` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lag` bigint(20) NULL DEFAULT NULL,
  `alarm_group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `alarm_times` int(11) NULL DEFAULT NULL,
  `alarm_max_times` int(11) NULL DEFAULT NULL,
  `alarm_level` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_normal` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Y',
  `is_enable` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Y',
  `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL.PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_alarm_crontab
-- ----------------------------
DROP TABLE IF EXISTS `ke_alarm_crontab`;
CREATE TABLE `ke_alarm_crontab`  (
  `id` bigint(20) NOT NULL,
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `crontab` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_enable` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'Y',
  `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL.PRIMARY KEY (`id`, `type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_connect_config
-- ----------------------------
DROP TABLE IF EXISTS `ke_connect_config`;
CREATE TABLE `ke_connect_config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `connect_uri` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `alive` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `modify` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL.PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_consumer_bscreen
-- ----------------------------
DROP TABLE IF EXISTS `ke_consumer_bscreen`;
CREATE TABLE `ke_consumer_bscreen`  (
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `topic` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `logsize` bigint(20) NULL DEFAULT NULL,
  `difflogsize` bigint(20) NULL DEFAULT NULL,
  `offsets` bigint(20) NULL DEFAULT NULL,
  `diffoffsets` bigint(20) NULL DEFAULT NULL,
  `lag` bigint(20) NULL DEFAULT NULL,
  `timespan` bigint(20) NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_consumer_group
-- ----------------------------
DROP TABLE IF EXISTS `ke_consumer_group`;
CREATE TABLE `ke_consumer_group`  (
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `topic` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` int(11) NULL DEFAULT NULL.PRIMARY KEY (`cluster`, `group`, `topic`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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 utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `topic_number` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `coordinator` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `active_topic` int(11) NULL DEFAULT NULL,
  `active_thread_total` int(11) NULL DEFAULT NULL.PRIMARY KEY (`cluster`, `group`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_logsize
-- ----------------------------
DROP TABLE IF EXISTS `ke_logsize`;
CREATE TABLE `ke_logsize`  (
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `topic` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `logsize` bigint(20) NULL DEFAULT NULL,
  `diffval` bigint(20) NULL DEFAULT NULL,
  `timespan` bigint(20) NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_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 = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_metrics
-- ----------------------------
DROP TABLE IF EXISTS `ke_metrics`;
CREATE TABLE `ke_metrics`  (
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `broker` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `value` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `timespan` bigint(20) NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_metrics_offline
-- ----------------------------
DROP TABLE IF EXISTS `ke_metrics_offline`;
CREATE TABLE `ke_metrics_offline`  (
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `one` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mean` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `five` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `fifteen` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL.PRIMARY KEY (`cluster`, `key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_p_role
-- ----------------------------
DROP TABLE IF EXISTS `ke_p_role`;
CREATE TABLE `ke_p_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'role name',
  `seq` tinyint(4) 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 = utf8mb4 COLLATE = utf8mb4_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(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'resource name',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `parent_id` int(11) NOT NULL.PRIMARY KEY (`resource_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_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(20) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `resource_id` int(11) NOT NULL.PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_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(20) NOT NULL AUTO_INCREMENT,
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `host` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ksql` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `spend_time` bigint(20) NULL DEFAULT NULL,
  `created` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `tm` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL.PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_topic_rank
-- ----------------------------
DROP TABLE IF EXISTS `ke_topic_rank`;
CREATE TABLE `ke_topic_rank`  (
  `cluster` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `topic` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `tkey` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `tvalue` bigint(20) NULL DEFAULT NULL.PRIMARY KEY (`cluster`, `topic`, `tkey`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ke_user_role
-- ----------------------------
DROP TABLE IF EXISTS `ke_user_role`;
CREATE TABLE `ke_user_role`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `role_id` tinyint(4) NOT NULL.PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_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(20) NOT NULL AUTO_INCREMENT,
  `rtxno` int(11) NOT NULL,
  `username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `realname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL.PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ke_users
-- ----------------------------
INSERT INTO `ke_users` VALUES (1.1000.'admin'.'123456'.'[email protected]'.'Administrator');
Copy the code

2.3 Modifying the Kafka Startup Command to open the JMX configuration

vim bin/kafka-server-start.sh

export JMX_PORT="9999" 
Copy the code

mo4tech.com (Moment For Technology) is a global community with thousands techies from across the global hang out!Passionate technologists, be it gadget freaks, tech enthusiasts, coders, technopreneurs, or CIOs, you would find them all here.

Kafka – eagle installation

1. Download address

2. Install and configure

2.1 configuration`kafka-eagle`The environment variable

2.2 to modify`conf/system-config.properties`The configuration file

2.3 Modifying the Kafka Startup Command to open the JMX configuration

Kafka – eagle installation

1. Download address

2. Install and configure

2.1 configurationkafka-eagleThe environment variable

2.2 to modifyconf/system-config.propertiesThe configuration file

2.3 Modifying the Kafka Startup Command to open the JMX configuration

Related Posts

You can build a Spring Boot application in five minutes, two ways

Forget Snowflake and feel the 587 times better globally unique ID generation algorithm

1.5 Java. Lang. NullPointerException problem | Java Debug notes

2.1 configuration`kafka-eagle`The environment variable

2.2 to modify`conf/system-config.properties`The configuration file