192.168.20.10 | Mysql-master | nacos |
---|---|---|
192.168.20.11 | mysql-slave | nacos |
192.168.20.12 | mysql-slave | nacos |
[root@localhost ~]# vim /etc/my.cnf
[mysqld]
log-bin=mysql-bin # 非必需
server-id=1 # 必需
master的server-id为1 那么slave1的server-id就是2 然后以此类推
[root@localhost ~]# systemctl restart mysqld
# 此操作在master进行
[root@localhost ~]# mysql -u root -p
mysql> CREATE USER 'repl'@'192.168.20.%' IDENTIFIED BY '123.comA'; /IP段写自己的
mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.20.%';
mysql> FLUSH PRIVILEGES;
mysql> show master status\G //查看master状态
*************************** 1. row ***************************
File: mysql-bin.000001
Position: 875
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.00 sec)
// 此操作在从服务器上执行
[root@bogon ~]# mysql -u root -p
change master to master_host='192.168.20.10', master_user='repl', master_password='123.comA', master_log_file='mysql-bin.000001', master_log_pos=875;
mysql> start slave; //开启从数据同步
mysql> show slave status\G //查看从服务器状态
*************************** 1. row ***************************
如果都是yes的话就表示成功,如果一个yes一个no就查看报错信息,主从排错我就不多说了
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
# 主服务器上创建一个数据库
mysql> create database nacos;
# 从服务器上进行查询
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| nacos |
+--------------------+
5 rows in set (0.04 sec) # 查询到有nacos库即同步成功
grant all privileges on nacos to 'root'@'%' identified by '123.comA';
[root@localhost ~]# tar -zxf nacos-server-1.3.2.tar.gz
[root@localhost ~]# mv nacos /usr/local/nacos
[root@localhost ~]# mv nacos /usr/local/nacos1
[root@localhost ~]# mv nacos /usr/local/nacos2
# 默认不用修改nacos 直接修改nacos1和nacos2
[root@localhost bin]# vim /usr/local/nacos1/conf/application.properties
server.port=8849 # 更改为8849
[root@localhost bin]# vim /usr/local/nacos2/conf/application.properties
server.port=8850 # 更改为8850
[root@localhost nacos]# cd /usr/local/nacos/conf/
[root@localhost conf]# cp cluster.conf.example cluster.conf // 三台机器都这么执行
[root@localhost conf]# vim cluster.conf
# 采用这种不同端口号来充当nacos实例
192.168.20.10:8848
192.168.20.10:8849
192.168.20.10:8850
[root@bogon bin]# vim /usr/local/nacos/bin/startup.sh
JAVA_OPT="${JAVA_OPT} -server -Xms1g -Xmx1g # 修改启动内存为
[root@localhost conf]# cd /usr/local/nacos/bin/
sh startup.sh -p embedded //三个配置全部启动
# -p embedded # 表示采用内置数据源
[root@localhost bin]# tail -f ../logs/nacos.log
# 启动成功提示
2020-10-18 22:13:26,644 INFO Nacos started successfully in cluster mode. use embedded storage
访问:http://192.168.20.10:8848/nacos/index.html
# 三台全部修改cluster.conf配置文件
192.168.20.10:8848
192.168.20.21:8848
192.168.20.22:8848
sh startup.sh -p embedded # 启动
http://192.168.20.21:8848/nacos/index.html
# 三台配置文件都修改
[root@bogon nacos]# vim conf/application.properties
spring.datasource.platform=mysql
db.num=1 # 数据库个数
db.url.0=jdbc:mysql://192.168.20.22:3306/nacos_config?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC # 此处填写mysql的ip
db.user=root # 用户
db.password=xxx # 此为mysql的密码
mysql> CREATE DATABASE nacos_config; # 先进入mysql创建一个库
[root@bogon conf]# mysql -u root -p nacos_config < nacos-mysql.sql //把nacos的表结构导入进去
[root@bogon bin]# ./startup.sh 启动nacos
然后访问nacos新建一个测试的数据
然后停止掉nacos
[root@bogon bin]# ./shutdown.sh
进入mysql查询数据
mysql> use nacos_config
mysql> select * from config_info\G
*************************** 1. row ***************************
id: 1
data_id: 1
group_id: DEFAULT_GROUP
content: test
md5: 098f6bcd4621d373cade4e832627b4f6
gmt_create: 2020-10-19 07:54:39
gmt_modified: 2020-10-19 07:54:39
src_user: NULL
src_ip: 192.168.20.1
app_name:
tenant_id:
c_desc: NULL
c_use: NULL
effect: NULL
type: text
c_schema: NULL
1 row in set (0.00 sec)