Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the role of relay_log_info_repository and sync_relay_log_info in MySQL". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Realy_log_info_repository is used to determine where the location information for slave synchronization is recorded, and there are also two parameters. If relay_log_info_repository=file, a realy-log.info is created, and if relay_log_info_repository=table, a mysql.slave_relay_info table is created to record the synchronized location information.

The sync_relay_log_info parameter is used to control the refresh mode of the slave synchronization location, which is affected by the relay_log_info_repository parameter.

1) relay_log_info_repository=file,sync_relay_log_info=N, if N > 0, synchronize realy_info.info files to disk using the fdatasync () method after N transactions. If Number0, then Mysql does not synchronize realy_log.info files to disk, but lets the operating system decide.

2) relay_log_info_repository=table, if the table is a transaction-enabled table, slave updates the table after each transaction, ignoring the sync_relay_log_info parameter. If the table is a non-transactional table, sync_log_info=N, when N > 0, slave updates the table after every N event, and when Number0, the table is never updated.

This is the end of the content of "what is the role of relay_log_info_repository and sync_relay_log_info in MySQL". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.