MySQL Cross-version master-slave replication times Error: Error 1794 (HY000): Slave is not configured or failed to initialize properly.

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.