nacos学习记录

一.nacos下载安装

1.下载

nacos官网:https://nacos.io

nacos下载地址:https://github.com/alibaba/nacos/releases

在这里插入图片描述
下载tar.gz包或者zip包

2.安装

  1. 将安装包上传到linux系统
    解压:tar -zxvf nacos-server-1.1.4.tar.gz
    或者:gzip -d nacos-server-1.1.4.zip
    目录结构
    目录结构如上图 安装完成

3.更改配置

  1. 更改配置(集群模式)
    cd conf
    cp cluster.conf.example cluster.conf
    文件中加入配置(集群的IP地址)
    10.10.94.201
    10.10.94.202
    10.10.94.203
    保存
    3.更改application.properties
    vim application.properties
    新增配置(数据库)用于保存nacos的用户信息等:
    db.num=1
    db.url.0=jdbc:mysql://10.10.94.202:3306/nacos_config?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true
    db.user=root
    db.password=root
  2. 建表
    在mysql执行如下建表语句:

SET FOREIGN_KEY_CHECKS=0;


– Table structure for config_info


DROP TABLE IF EXISTS config_info;
CREATE TABLE config_info (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
data_id varchar(255) COLLATE utf8_bin NOT NULL COMMENT ‘data_id’,
group_id varchar(255) COLLATE utf8_bin DEFAULT NULL,
content longtext COLLATE utf8_bin NOT NULL COMMENT ‘content’,
md5 varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT ‘md5’,
gmt_create datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘创建时间’,
gmt_modified datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘修改时间’,
src_user text COLLATE utf8_bin COMMENT ‘source user’,
src_ip varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT ‘source ip’,
app_name varchar(128) COLLATE utf8_bin DEFAULT NULL,
tenant_id varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘租户字段’,
c_desc varchar(256) COLLATE utf8_bin DEFAULT NULL,
c_use varchar(64) COLLATE utf8_bin DEFAULT NULL,
effect varchar(64) COLLATE utf8_bin DEFAULT NULL,
type varchar(64) COLLATE utf8_bin DEFAULT NULL,
c_schema text COLLATE utf8_bin,
PRIMARY KEY (id),
UNIQUE KEY uk_configinfo_datagrouptenant (data_id,group_id,tenant_id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘config_info’;


– Table structure for config_info_aggr


DROP TABLE IF EXISTS config_info_aggr;
CREATE TABLE config_info_aggr (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
data_id varchar(255) COLLATE utf8_bin NOT NULL COMMENT ‘data_id’,
group_id varchar(255) COLLATE utf8_bin NOT NULL COMMENT ‘group_id’,
datum_id varchar(255) COLLATE utf8_bin NOT NULL COMMENT ‘datum_id’,
content longtext COLLATE utf8_bin NOT NULL COMMENT ‘内容’,
gmt_modified datetime NOT NULL COMMENT ‘修改时间’,
app_name varchar(128) COLLATE utf8_bin DEFAULT NULL,
tenant_id varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘租户字段’,
PRIMARY KEY (id),
UNIQUE KEY uk_configinfoaggr_datagrouptenantdatum (data_id,group_id,tenant_id,datum_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘增加租户字段’;


– Table structure for config_info_beta


DROP TABLE IF EXISTS config_info_beta;
CREATE TABLE config_info_beta (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
data_id varchar(255) COLLATE utf8_bin NOT NULL COMMENT ‘data_id’,
group_id varchar(128) COLLATE utf8_bin NOT NULL COMMENT ‘group_id’,
app_name varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT ‘app_name’,
content longtext COLLATE utf8_bin NOT NULL COMMENT ‘content’,
beta_ips varchar(1024) COLLATE utf8_bin DEFAULT NULL COMMENT ‘betaIps’,
md5 varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT ‘md5’,
gmt_create datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘创建时间’,
gmt_modified datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘修改时间’,
src_user text COLLATE utf8_bin COMMENT ‘source user’,
src_ip varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT ‘source ip’,
tenant_id varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘租户字段’,
PRIMARY KEY (id),
UNIQUE KEY uk_configinfobeta_datagrouptenant (data_id,group_id,tenant_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘config_info_beta’;


– Table structure for config_info_tag


DROP TABLE IF EXISTS config_info_tag;
CREATE TABLE config_info_tag (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
data_id varchar(255) COLLATE utf8_bin NOT NULL COMMENT ‘data_id’,
group_id varchar(128) COLLATE utf8_bin NOT NULL COMMENT ‘group_id’,
tenant_id varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘tenant_id’,
tag_id varchar(128) COLLATE utf8_bin NOT NULL COMMENT ‘tag_id’,
app_name varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT ‘app_name’,
content longtext COLLATE utf8_bin NOT NULL COMMENT ‘content’,
md5 varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT ‘md5’,
gmt_create datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘创建时间’,
gmt_modified datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘修改时间’,
src_user text COLLATE utf8_bin COMMENT ‘source user’,
src_ip varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT ‘source ip’,
PRIMARY KEY (id),
UNIQUE KEY uk_configinfotag_datagrouptenanttag (data_id,group_id,tenant_id,tag_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘config_info_tag’;


– Table structure for config_tags_relation


DROP TABLE IF EXISTS config_tags_relation;
CREATE TABLE config_tags_relation (
id bigint(20) NOT NULL COMMENT ‘id’,
tag_name varchar(128) COLLATE utf8_bin NOT NULL COMMENT ‘tag_name’,
tag_type varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT ‘tag_type’,
data_id varchar(255) COLLATE utf8_bin NOT NULL COMMENT ‘data_id’,
group_id varchar(128) COLLATE utf8_bin NOT NULL COMMENT ‘group_id’,
tenant_id varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘tenant_id’,
nid bigint(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (nid),
UNIQUE KEY uk_configtagrelation_configidtag (id,tag_name,tag_type),
KEY idx_tenant_id (tenant_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘config_tag_relation’;


– Table structure for group_capacity


DROP TABLE IF EXISTS group_capacity;
CREATE TABLE group_capacity (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
group_id varchar(128) COLLATE utf8_bin NOT NULL DEFAULT ‘’ COMMENT ‘Group ID,空字符表示整个集群’,
quota int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘配额,0表示使用默认值’,
usage int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘使用量’,
max_size int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘单个配置大小上限,单位为字节,0表示使用默认值’,
max_aggr_count int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘聚合子配置最大个数,,0表示使用默认值’,
max_aggr_size int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值’,
max_history_count int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘最大变更历史数量’,
gmt_create datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘创建时间’,
gmt_modified datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘修改时间’,
PRIMARY KEY (id),
UNIQUE KEY uk_group_id (group_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘集群、各Group容量信息表’;


– Table structure for his_config_info


DROP TABLE IF EXISTS his_config_info;
CREATE TABLE his_config_info (
id bigint(64) unsigned NOT NULL,
nid bigint(20) unsigned NOT NULL AUTO_INCREMENT,
data_id varchar(255) COLLATE utf8_bin NOT NULL,
group_id varchar(128) COLLATE utf8_bin NOT NULL,
app_name varchar(128) COLLATE utf8_bin DEFAULT NULL COMMENT ‘app_name’,
content longtext COLLATE utf8_bin NOT NULL,
md5 varchar(32) COLLATE utf8_bin DEFAULT NULL,
gmt_create datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’,
gmt_modified datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’,
src_user text COLLATE utf8_bin,
src_ip varchar(20) COLLATE utf8_bin DEFAULT NULL,
op_type char(10) COLLATE utf8_bin DEFAULT NULL,
tenant_id varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘租户字段’,
PRIMARY KEY (nid),
KEY idx_gmt_create (gmt_create),
KEY idx_gmt_modified (gmt_modified),
KEY idx_did (data_id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘多租户改造’;


– Table structure for roles


DROP TABLE IF EXISTS roles;
CREATE TABLE roles (
username varchar(50) NOT NULL,
role varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


– Table structure for tenant_capacity


DROP TABLE IF EXISTS tenant_capacity;
CREATE TABLE tenant_capacity (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘主键ID’,
tenant_id varchar(128) COLLATE utf8_bin NOT NULL DEFAULT ‘’ COMMENT ‘Tenant ID’,
quota int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘配额,0表示使用默认值’,
usage int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘使用量’,
max_size int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘单个配置大小上限,单位为字节,0表示使用默认值’,
max_aggr_count int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘聚合子配置最大个数’,
max_aggr_size int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘单个聚合数据的子配置大小上限,单位为字节,0表示使用默认值’,
max_history_count int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘最大变更历史数量’,
gmt_create datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘创建时间’,
gmt_modified datetime NOT NULL DEFAULT ‘2010-05-05 00:00:00’ COMMENT ‘修改时间’,
PRIMARY KEY (id),
UNIQUE KEY uk_tenant_id (tenant_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘租户容量信息表’;


– Table structure for tenant_info


DROP TABLE IF EXISTS tenant_info;
CREATE TABLE tenant_info (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
kp varchar(128) COLLATE utf8_bin NOT NULL COMMENT ‘kp’,
tenant_id varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘tenant_id’,
tenant_name varchar(128) COLLATE utf8_bin DEFAULT ‘’ COMMENT ‘tenant_name’,
tenant_desc varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT ‘tenant_desc’,
create_source varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT ‘create_source’,
gmt_create bigint(20) NOT NULL COMMENT ‘创建时间’,
gmt_modified bigint(20) NOT NULL COMMENT ‘修改时间’,
PRIMARY KEY (id),
UNIQUE KEY uk_tenant_info_kptenantid (kp,tenant_id),
KEY idx_tenant_id (tenant_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘tenant_info’;


– Table structure for users


DROP TABLE IF EXISTS users;
CREATE TABLE users (
username varchar(50) NOT NULL,
password varchar(500) NOT NULL,
enabled tinyint(1) NOT NULL,
PRIMARY KEY (username)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

至此,nacos基本配置就完成了
打开浏览器,访问:http://10.10.94.202:8848/nacos
在这里插入图片描述

4.用户名密码配置

  1. 数据库插入如下语句:
    INSERT INTO nacos_config.users (username, password, enabled) VALUES (‘nacos’, ‘$2a 10 10 10NJMHBO/0vlGPjiYEYE5H3OTvb946LCCYsHvU5aBLBztukJqE04Sba’, ‘1’);
    用户名:nacos
    密码:123456
    登入成功后如图:
    在这里插入图片描述
  2. 更改密码
    引入maven依赖
    <dependency>
           <groupId>org.springframework.boot</groupId>
           <artifactId>spring-boot-starter-security</artifactId>
    </dependency>
    
    写一个main方法,用下面方法生成密码,update到数据库users表
    
    
    
    public class PasswordEncoderUtil {
 
    public static void main(String[] args) {
        System.out.println(new BCryptPasswordEncoder().encode("nacos"));
    }
}

** 下一篇学nacos服务注册发现,配置文件的管理**

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值