跳到主要内容
版本:最新版本(unreleased)

install

Polaris 部署文档 (待修改)

简介

部署配置中心&服务发现Polaris套件,包括Cynosure、Companion、zk集群,采用容器化方案。

基础环境

docker版本1.12.x +,请自行安装。

ZK集群

zk安装文档不再此赘述。

Cynosure

注:启动companion参数分别代表companion的ip地址-h10.1.86.211,端口-p6868,zk集群地址-z10.1.86.211:2181,10.1.86.70:2181,10.1.86.212:2181,cynosure地址-whttps://10.1.87.69:8095

启动完成后,可以输入以下url验证是否正常启动了。如果正常启动了,会有返回结果。
http://ip:port/finder/query_zk_info?project=AIaaS&group=aitest&service=iatExecutor&version=2.0.0
(ip\port根据实际情况替换)

Mysql脚本


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_cluster
-- ----------------------------
DROP TABLE IF EXISTS `tb_cluster`;
CREATE TABLE `tb_cluster` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '集群唯一标识',
`name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '集群名称',
`push_url` varchar(500) COLLATE utf8_bin NOT NULL COMMENT '集群推送地址',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_name` (`name`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_dic
-- ----------------------------
DROP TABLE IF EXISTS `tb_dic`;
CREATE TABLE `tb_dic` (
`type` varchar(1) NOT NULL,
`type_name` varchar(20) NOT NULL,
PRIMARY KEY (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for tb_gray_group
-- ----------------------------
DROP TABLE IF EXISTS `tb_gray_group`;
CREATE TABLE `tb_gray_group` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '版本id',
`version_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '版本id',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '灰度组名称',
`content` text COLLATE utf8_bin COMMENT '推送实例内容',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '版本描述',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_name_version_id` (`version_id`,`name`) USING BTREE,
KEY `idx_service_id` (`version_id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_lastest_search
-- ----------------------------
DROP TABLE IF EXISTS `tb_lastest_search`;
CREATE TABLE `tb_lastest_search` (
`id` varchar(150) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_id` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`url` varchar(200) COLLATE utf8_bin DEFAULT NULL,
`pre_condition` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uq_user_id_url` (`user_id`,`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_loadbalance
-- ----------------------------
DROP TABLE IF EXISTS `tb_loadbalance`;
CREATE TABLE `tb_loadbalance` (
`name` varchar(50) COLLATE utf8_bin NOT NULL,
`abbr` varchar(100) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`name`,`abbr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_project
-- ----------------------------
DROP TABLE IF EXISTS `tb_project`;
CREATE TABLE `tb_project` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '项目id',
`name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '项目名称',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '项目描述',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_name` (`name`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_project_member
-- ----------------------------
DROP TABLE IF EXISTS `tb_project_member`;
CREATE TABLE `tb_project_member` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '唯一标识',
`user_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '用户id',
`project_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '项目id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`creator` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uq_user_id_project_id` (`user_id`,`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
`role_name` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '角色名称',
`role_type` tinyint(4) NOT NULL COMMENT '角色类型',
PRIMARY KEY (`role_name`,`role_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service
-- ----------------------------
DROP TABLE IF EXISTS `tb_service`;
CREATE TABLE `tb_service` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '服务id',
`group_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '服务组id',
`name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '服务名称',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '服务描述',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_group_id_name` (`group_id`,`name`),
KEY `idx_user_id` (`user_id`),
KEY `idx_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_api_version
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_api_version`;
CREATE TABLE `tb_service_api_version` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '版本id',
`service_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '服务id',
`api_version` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '版本号',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '版本描述',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_service_id_version` (`api_version`,`service_id`),
KEY `idx_service_id` (`service_id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_config
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_config`;
CREATE TABLE `tb_service_config` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '配置id',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`version_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '版本id',
`name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '配置名称',
`path` varchar(500) COLLATE utf8_bin NOT NULL COMMENT '配置路径',
`content` longblob COMMENT '配置内容',
`md5` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '配置内容md5值',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '配置描述',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`gray_group_id` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_version_id_group_id_name` (`version_id`,`gray_group_id`,`name`) USING BTREE,
KEY `idx_user_id` (`user_id`),
KEY `idx_version_id` (`version_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_config_history
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_config_history`;
CREATE TABLE `tb_service_config_history` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '配置id',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`config_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '配置id',
`content` longblob COMMENT '配置内容',
`md5` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '配置内容md5值',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '配置描述',
`push_version` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '推送版本号',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_config_id` (`config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_config_push_feedback
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_config_push_feedback`;
CREATE TABLE `tb_service_config_push_feedback` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '推送反馈id',
`push_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '推送id',
`project` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '项目名称',
`service_group` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '服务组名称',
`service` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '服务名称',
`version` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '服务版本号',
`config` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '配置名称',
`addr` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '地址',
`update_status` tinyint(4) DEFAULT NULL COMMENT '更新状态',
`load_status` tinyint(4) DEFAULT NULL COMMENT '加载状态',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`load_time` datetime DEFAULT NULL COMMENT '加载时间',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`gray_group_id` varchar(50) COLLATE utf8_bin DEFAULT '0',
`api_version` varchar(20) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_push_id` (`push_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_config_push_history
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_config_push_history`;
CREATE TABLE `tb_service_config_push_history` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '推送id',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`project` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '项目名称',
`service_group` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '服务组名称',
`service` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '服务名称',
`version` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '服务版本号',
`cluster_text` text COLLATE utf8_bin NOT NULL COMMENT '集群',
`service_config_text` text COLLATE utf8_bin NOT NULL COMMENT '服务配置',
`push_time` datetime DEFAULT NULL COMMENT '推送时间',
`gray_group_id` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_discovery_push_feedback
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_discovery_push_feedback`;
CREATE TABLE `tb_service_discovery_push_feedback` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '推送反馈id',
`push_id` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '推送id',
`project` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '项目名称',
`service_group` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '服务组名称',
`consumer_service` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '消费端服务名称',
`consumer_version` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '消费端版本',
`provider_service` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '提供端服务名称',
`provider_version` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '提供端版本',
`addr` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '地址',
`update_status` tinyint(4) DEFAULT NULL COMMENT '更新状态',
`load_status` tinyint(4) DEFAULT NULL COMMENT '加载状态',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`load_time` datetime DEFAULT NULL COMMENT '加载时间',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`type` varchar(1) COLLATE utf8_bin DEFAULT NULL,
`api_version` varchar(20) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_push_id` (`push_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_discovery_push_history
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_discovery_push_history`;
CREATE TABLE `tb_service_discovery_push_history` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '服务发现推送id',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`project` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '项目名称',
`service_group` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '服务组名称',
`service` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '服务名称',
`cluster_text` text COLLATE utf8_bin NOT NULL COMMENT '集群',
`push_time` datetime DEFAULT NULL COMMENT '推送时间',
`version` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_group
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_group`;
CREATE TABLE `tb_service_group` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '唯一标识',
`project_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '项目id',
`name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '服务组名称',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '服务组描述',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_project_id_name` (`project_id`,`name`),
KEY `idx_user_id` (`user_id`),
KEY `idx_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_service_version
-- ----------------------------
DROP TABLE IF EXISTS `tb_service_version`;
CREATE TABLE `tb_service_version` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '版本id',
`service_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '服务id',
`version` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '版本号',
`user_id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户id',
`description` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '版本描述',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_service_id_version` (`version`,`service_id`),
KEY `idx_service_id` (`service_id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '唯一标识',
`account` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '账号',
`password` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '密码',
`user_name` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '用户姓名',
`phone` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '联系方式',
`email` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '邮箱',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`role_type` tinyint(4) NOT NULL DEFAULT '2' COMMENT '角色类型 1.管理员 2.普通用户',
PRIMARY KEY (`id`),
UNIQUE KEY `uq_account` (`account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` varchar(50) COLLATE utf8_bin NOT NULL COMMENT '配置id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

SET FOREIGN_KEY_CHECKS = 1;


/*Data for the table `tb_loadbalance` */

insert into `tb_loadbalance`(`name`,`abbr`) values
('一致性Hash','ConsistentHash'),
('最少活跃调用数','LeastActive'),
('轮循','RoundRobin'),
('随机','Random');

/*Data for the table `tb_role` */

insert into `tb_role`(`role_name`,`role_type`) values
('admin',1),
('user',2);

/*Data for the table `tb_user` */

insert into `tb_user`(`id`,`account`,`password`,`user_name`,`phone`,`email`,`create_time`,`update_time`,`role_type`) values
('3688919024172793856','admin','b301eba23dc7ab9df6b7315de2ac222a','admin','13739263609','xx@iflytek.com','2021-11-10 10:12:07','2021-12-05 05:20:27',1);

insert into `tb_dic` values
('0', '服务配置')
('1', '路由配置')
('2', '实例配置');

Install On K8s

todo