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

Golden nine silver ten iron 12, tencent, currently Meituan have received five companies such as intention to offer essay | the nuggets technology

5 tips for programmers to quickly deal with code bugs, binary debugging method is a necessary weapon!

[Design Pattern] – Template method

2.1 configuration`kafka-eagle`The environment variable

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