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

What are the requirements and restrictions for MySQL 5.7group replication

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

Share

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

In this issue, the editor will bring you what are the requirements and restrictions on the replication of MySQL 5.7. the article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.

Restrictions and requirements:

1. All the data involved must occur in the table of the InnoDB storage engine.

two。 All tables must have a clear primary key definition.

3. Network addresses only support IPv4.

4. A network with low latency and high bandwidth is required.

5. Currently, a maximum of 9 nodes are allowed in the cluster.

6. Binlog must be enabled.

7. Binlog format must be row format.

8. Gtid mode must be turned on.

9. Replication-related information must be stored using a table.

10. The transaction write set (Transaction write set extraction) must be open. (this currently conflicts with savepoint, which is the reason why mysqldump cannot back up GR instances.)

11. Log slave updates must be opened.

12. Binlog's checksum is not currently supported.

13. Savepoint cannot be used due to interference with transaction write sets.

14. The SERIALIZABLE isolation level is not currently supported.

15. For the same object, it is feasible to execute DDL (even conflicting DDL) in parallel on different instances in the cluster, but it will lead to errors such as data consistency. At this stage, it is not supported to execute the DDL of the same object on multiple nodes at the same time.

16. The current implementation of cascading constraint operations for foreign keys is not fully supported and is not recommended.

These are the requirements and restrictions of MySQL Group 5.7 replication shared by the editor. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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: 203

*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