kafka连接mysql数据库_kafka-web-console 连接Mysql数据库的表和数据信息

Source Server : 206 docker mysql 13306

Source Server Version : 50720

Source Host : 192.168.7.206:13306

Source Database : kafkamonitor

Target Server Type : MYSQL

Target Server Version : 50720

File Encoding : 65001

Date: 2018-05-05 18:32:21

*/

SET FOREIGN_KEY_CHECKS=0;

-- Table structure for groups

DROP TABLE IF EXISTS groups;

CREATE TABLE groups (

id bigint(32) NOT NULL,

name varchar(64) DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Records of groups

INSERT INTO groups VALUES (‘0‘, ‘ALL‘);

INSERT INTO groups VALUES (‘1‘, ‘DEVELOPMENT‘);

INSERT INTO groups VALUES (‘2‘, ‘PRODUCTION‘);

INSERT INTO groups VALUES (‘3‘, ‘STAGING‘);

INSERT INTO groups VALUES (‘4‘, ‘TEST‘);

-- Table structure for offsetHistory

DROP TABLE IF EXISTS offsetHistory;

CREATE TABLE offsetHistory (

id bigint(16) unsigned NOT NULL AUTO_INCREMENT,

zookeeperId bigint(16) DEFAULT NULL,

topic varchar(255) DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- Records of offsetHistory

INSERT INTO offsetHistory VALUES (‘1‘, ‘1‘, ‘dbsync-topic‘);

INSERT INTO offsetHistory VALUES (‘2‘, ‘1‘, ‘test‘);

INSERT INTO offsetHistory VALUES (‘3‘, ‘1‘, ‘consumer_offsets‘);

INSERT INTO offsetHistory VALUES (‘4‘, ‘3‘, ‘test‘);

INSERT INTO offsetHistory VALUES (‘5‘, ‘3‘, ‘dbsync-topic‘);

<