mysql5.7安装以及数据库主从迁移
rpm -qamariadb*yum removemariadb-libs-5.5.56-2.el7.x86_64-yrpm -ivh mysql-community-common-5.7.9-1.el7.x86_64.rpmrpm-ivhmysql-community-libs-5.7.9-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-compat-5.7.9-1.el7.x86_64.rpmrpm -ivhmysql-community-devel-5.7.9-1.el7.x86_64.rpmrpm -ivh mysql-community-client-5.7.9-1.el7.x86_64.rpm错误：# rpm -ivh mysql-community-server-5.7.9-1.el7.x86_64.rpm警告：mysql-community-server-5.7.9-1.el7.x86_64.rpm:头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY错误：依赖检测失败： net-tools 被mysql-community-server-5.7.9-1.el7.x86_64 需要#解决办法：yum -yinstallnet-toolsrpm-ivhmysql-community-server-5.7.9-1.el7.x86_64.rpm问题:unblock with'mysqladmin flush-hosts'Connection closed by foreign host解决办法：http://www.cnblogs.com/susuyu/archive/2013/05/28/3104249.html
mysql>start slave;ERROR1872 (HY000): Slave failed to initialize relay log info structure from therepository解决办法：重新做主从stopslave;resetslave;changemaster tomaster_host='masterip',master_user='slave',master_password='123456',master_port=3306,master_log_file='mysql-bin.000145',master_log_pos=193963694;
showslave status \G 报错 Got fatal error 1236 from master when readingdata from binary log: 'A slave with the same server_uuid as this slavehas connected to the master; the first event 'mysql-bin.000155' at193963604, the last event read from './mysql-bin.000155' at 123, the last byteread from './mysql-bin.000155' at 193963604.'
showvariables like 'server_id';mvdatadir/auto.cnf/tmpsystemctlrestart mysqld
主要是拷贝auto.cnf重复
页:
[1]