background: Zabbix Database migration, building master and Slave, the main is 5.6.25, from 5.7.15, streaming backup application Redo.log, change master and reset slave times the following error
mysql> change MASTER to-, master_host= ' 192.168.40.129 ' , -master_user= ' repl ', - > master_password= ' repl_123 ',-- master_port=3306,-- master_log_file= ' Mysql-bin.000005 ', master_log_pos=749, and master_auto_position=0; ERROR 1794 (HY000): Slave is isn't configured or failed to initialize properly. You must at least set--server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.
cause: use Innobackupex Backup from version 5.6.25, application Recovery in 5.7.15, IBD system tables need to be rebuilt
Steps to resolve:
1. IBD Table for Drop backup
Use Mysqldrop table slave_master_info;drop table slave_relay_log_info;drop table Slave_worker_info;drop table Innodb_ Index_stats;drop table innodb_table_stats;
2. Reconstruction
mysql> source/usr/local/mysql/share/mysql_system_tables.sqlquery OK, 0 rows affected, 1 Warning (0.00 sec)
3. Restart the database
[Email protected] data]#/etc/init.d/mysqld restartshutting down MySQL . [ OK ]starting MySQL . [ OK ]
At this point, the problem solved, log in the database, re-master to can!
Zero_gg Source: http://www.cnblogs.com/zero-gg/ If you really feel that the article is well written and helpful to you, then you might as well give a little reward, if the bag is shy, may wish to help "recommend", your "recommendation" and "reward" will be my greatest writing power! This article is copyrighted by the author, welcome reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original link. |
MySQL Cross-version master-slave replication times Error: Error 1794 (HY000): Slave is not configured or failed to initialize properly.