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

This article mainly introduces "what are the shortcomings of PXC". In daily operation, I believe that many people have doubts about the shortcomings of PXC. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubts about "what are the shortcomings of PXC?" Next, please follow the editor to study!

1. It works on InnoDB engine tables by default, and supports other engine tables poorly or even not at all, so don't consider using MyISAM or other storage engines on PXC.

two。 All tables must have a primary key, otherwise creating a table will report an error

3. Lock operations such as Lock/Unlock tables and lock functions are not supported

4.query log logs can only be saved in files.

5. Clustering is based on optimistic concurrency control (optimistic concurrency control), and transaction conflicts may occur during the commit commit phase.

6. Distributed transaction XA is not supported

7. The throughput and performance of the entire cluster depend on the slowest node

8. It is recommended that the minimum number of nodes in the cluster is 3, otherwise the problem of brain fissure is easy to occur.

9. Adding a new node is expensive and needs to synchronize all data

10. Can not effectively solve the write scaling problem, all write operations take place on all nodes

At this point, the study of "what are the shortcomings of PXC" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.