环境准备
模式:主-从
主机ip:192.168.1.120
从机ip:192.168.1.121
GBase版本:Gbase8s_华为鲲鹏
分别在主机和从机上创建数据库test和表格tb_mobile
Create database test;
Use test;
Create table tb_mobile(mobile VARCHAR(20) , time timestamp DEFAULT now());
一、主机设置
进入主服务器master,为从服务器创建链接账户
create user ‘user’@‘192.168.1.121’ identified by ‘user’;
grant replication slave on . to ‘user’@‘192.168.1.121’;
flush privileges;
创建完