6

Chaos Testing Leads to More Stable Percona XtraDB Cluster

 3 years ago
source link: https://www.percona.com/blog/2021/06/17/chaos-testing-leads-to-more-stable-percona-xtradb-cluster/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

Chaos Testing Leads to More Stable Percona XtraDB Cluster

Chaos Testing Leads to More Stable Percona XtraDB ClusterIn my talk at Percona Live 2021, “Creating Chaos in Databases”, I discussed how creating a controlled interruption in available resources (I used primary pod and network interruptions) allows us to test the stability of a database, and in our case, Percona XtraDB Cluster.

I also mentioned in the talk that my testing led to diagnosing a few unpleasant bugs, namely:

  • PXC-3437: Node fails to join in the endless loop
  • PXC-3580: Aggressive network outages on one node makes the whole cluster unusable
  • PXC-3596: Node stuck in aborting SST

Currently, I am happy to report these bugs are fixed in Percona XtraDB Cluster 8.0.23 and this version will provide you with a much better and stable experience, especially when used in a combination with our Percona Distribution for MySQL Operator.

I am not able to break Percona XtraDB Cluster 8.0.23 as I was able to in previous releases. It seems I need to be more creative to find more network-related bugs, so we will see how it goes.

As a side note, I would like to mention that our fixes are available to everybody who would like to improve the stability of their products based on the Galera library. We do not hide our source code behind “Enterprise” paywalls or hide them in combined .tar.gz source code dumps.

For example, a bug fix for bug https://jira.percona.com/browse/PXC-3580 is available in the pull request https://github.com/percona/galera/pull/214/files. Percona is committed to providing you with a real Open Source experience.

Happy Clustering!

STAY UP-TO-DATE With Percona!

p

Join 33,000+ of your fellow open-source enthusiasts! Our newsletter provides updates on Percona open source software releases, technical resources, and valuable MySQL, MariaDB, PostgreSQL, and MongoDB-related articles. Get information about Percona Live, our technical webinars, and upcoming events and meetups where you can talk with our experts.

Enter your work email address:*

By submitting my information I agree that Percona may use my personal data in send communication to me about Percona services. I understand that I can unsubscribe from the communication at any time in accordance with the Percona Privacy Policy.

Author

Vadim Tkachenko

Vadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. Vadim leads Percona Labs, which focuses on technology research and performance evaluations of Percona’s and third-party products. Percona Labs designs no-gimmick tests of hardware, filesystems, storage engines, and databases that surpass the standard performance and functionality scenario benchmarks.

Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. Oracle Corporation and its predecessors have incorporated Vadim’s source code patches into the mainstream MySQL and InnoDB products.

He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition.


Leave a Reply Cancel reply


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK