读写分离 sharding

把读和写放在不同的数据库，缓解数据库压力 

 

systemctl status mysqld 查看linux下mysql运行状态

 

 

 

GRANT REPLICATION SLAVE ON *.* to 'xiaoming'@'%' identified by 'Root@123456';
 

从库配置

 

 

 

 change master to master_host="192.168.65.132", master_user='xiaoming',master_password='Root@123456',master_log_file='mysql-bin.000003',master_log_pos=441