Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Mysql is the master and slave relay-log problem

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

It turns out that there is a database that is also a slave database, but the configuration file has not changed.

Dba: (none) > start slave

ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

Solution:

one

Reset master

And then at change master

② modifies the relay_log=/var/lib/mysql/msql-relay.log of my.conf 's configuration file

You can change it to another name (relay_log=/var/lib/mysql/msql-salve-relay.log) or modify the directory

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report