Comments on: Better high availability: MySQL and Percona XtraDB Cluster with good application design https://www.percona.com/blog/mysql-and-percona-xtradb-cluster-even-higher-availability-with-correct-application-design/ Wed, 07 Aug 2019 13:32:49 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Przemysław Malkowski https://www.percona.com/blog/mysql-and-percona-xtradb-cluster-even-higher-availability-with-correct-application-design/#comment-10967514 Thu, 29 Dec 2016 09:09:45 +0000 https://www.percona.com/blog/?p=32841#comment-10967514 Diep, if you take down one node, other(s) in order to continue accepting queries need quorum. This should not happen if you had at least three nodes. Also, “WSREP has not yet prepared node for application use” does not mean you lost any data – PXC is exactly protecting you from loosing/messing the data in case of split brain. But a better place for such questions is our forum board: http://www.percona.com/forums/

]]> By: diep nguyen https://www.percona.com/blog/mysql-and-percona-xtradb-cluster-even-higher-availability-with-correct-application-design/#comment-10967506 Wed, 28 Dec 2016 05:05:40 +0000 https://www.percona.com/blog/?p=32841#comment-10967506 Hi.
I’m learning about Percona XtraDB Cluster.I read on perconay docs, see: zero data loss…”, but when I suddently shutdown one node, other can not be create database on rest node….and show “WSREP has not yet prepared node for application use”
please help me..thanks.

]]> By: azigui https://www.percona.com/blog/mysql-and-percona-xtradb-cluster-even-higher-availability-with-correct-application-design/#comment-10965828 Thu, 28 Jan 2016 16:12:15 +0000 https://www.percona.com/blog/?p=32841#comment-10965828 Hi Przemysław,

Your article is very interessant.
We have a PXC with 5 nodes.
We have 80% reads vs 20% write.
We have a high traffic in our website.
So we need to know if its interressant to enable wsrep_dirty_reads directive when we have a splitbrain in order to keep website in read only.

Thx for your response

Cordialy

]]>