mysql集群主从安装总结

msyql 主从安装
初始化数据 mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data/data3306 --explicit_defaults_for_timestamp 
#查看数据库状态  
mysqld_multi --defaults-extra-file=/etc/mysqld_multi.cnf report  
#启动  
mysqld_multi --defaults-extra-file=/etc/my.cnf start  

查看线程
show processlist;

启动master
mysql -h127.0.0.1 -uroot -p -P3306 cfca1234
GRANT replication slave ON *.* TO 'slave'@'127.0.0.1' IDENTIFIED BY 'cfca1234';
      复制权限                     账号 
flush privileges;
show master status\G

slave
change master to master_host='127.0.0.1', master_port=3306, master_user='slave', master_password='cfca1234', master_log_file='mysql-bin.000003', master_log_pos=487;
start slave;
show slave status\G
mysql -h127.0.0.1 -uslave -pcfca1234 在从库对主库访问


MySQL数据备份复制
lock table  表名  read;
unlock table;


mysql集群安装