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

= case 1

Session1:

Session2:

Session3:

Conclusion:

When PXC is performing DDL, in order to ensure the consistency of node data, the whole cluster rejects write operations. Note that all table write operations in the cluster cannot provide write services, but read operations can proceed normally.

= case 2

Session1:

Session2

Session3

Conclusion:

When PXC DDL adds columns and other operations online, the online DDL operation cannot be used, and other threads cannot write data to the table.

Try go-ost as a tool later:

Https://www.cnblogs.com/zhoujinyi/p/9187421.html

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.