Enterprise case "Troubleshooting" MySQL master-Slave fault resolution process

Source: Internet
Author: User

Due to the configuration of Zabbix monitoring, a day received Zabbix monitoring master-Slave Alarm, view the MySQL status,

Showslave status \g;

SLAVE replication status is incorrect, slave_sql_running is no,

Then look at the following error message, prompting for a table to insert data, indicating that the table does not exist,

Then check the library from the library that the table, found all stored, just wonder.

And then back to the newspaper wrong there is a new discovery, the hint is uppercase, I just checked the lowercase,

OK, again into the database from the use of Uppercase query table, sure enough error, it appears that the case is caused by the problem.

Data found MySQL parameters have ignored case-sensitive parameters Lower_case_table_names=1

Decisive changes in the [MYSQLD] block added This parameter is, at the same time there is a heart to see the configuration of the main library, found that the main library has this configuration

Should be the problem here, this time restart from the library, view slave status, found the error hour, both states are yes, continue to copy operations.

Summarize:

Final summary reason: slave-end MY.CNF configuration is missing Lower_case_table_names=1 caused. Therefore, the master-slave configuration must pay attention to configuration parameters.

Enterprise case "Troubleshooting" MySQL master-Slave fault resolution process

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.