# Two Nodes Disappear from the Cluster

**URL:** <https://forums.percona.com/t/two-nodes-disappear-from-the-cluster/19755>\
**Category:** Uncategorized\
**Created:** [January 24, 2023, 1:48pm UTC](https://forums.percona.com/t/two-nodes-disappear-from-the-cluster/19755 "2023-01-24T13:48:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kfarrahe](https://avatars.discourse-cdn.com/v4/letter/k/ed8c4c/32.png) [@kfarrahe](https://forums.percona.com/u/kfarrahe)\
**Post date:** [January 24, 2023, 1:48pm UTC](https://forums.percona.com/t/two-nodes-disappear-from-the-cluster/19755/1 "2023-01-24T13:48:10Z")

</div>

I have Two nodes, that are not available (they was in on Esx2 and Esx2 was down) and the remaining node (node 3 in ESX1) is not able to form the quorum alone. The cluster has to switch to a non-primary mode, where MySQL refuses to serve any SQL queries. In this state, the “mysqld” process on node 3 is still running and can be connected to, but any statement related to data fails with an error.

what i see  
Reads are possible until node 3 decides that it cannot access node 1 and node 2. New writes are forbidden.

My question:  
If node 2 and node 1 are not available, how i can automaticaly that node 3 continue te works

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [January 24, 2023, 3:09pm UTC](https://forums.percona.com/t/two-nodes-disappear-from-the-cluster/19755/2 "2023-01-24T15:09:49Z")

</div>

Hi @kfarrahe , welcome back to the Percona forums!

If you would like to operate a PXC cluster with just one node, you can manually set node3 to `PRIMARY` state by executing:

```auto
SET GLOBAL wsrep_provider_options='pc.bootstrap=YES';

```

> **[Resetting the Quorum — Galera Cluster Documentation](https://galeracluster.com/library/documentation/quorum-reset.html)**
>
> "Provides an explanation of how determine if a cluster needs to be restarted and how to do it."

[https://galeracluster.com/library/documentation/mysql-wsrep-options.html#wsrep-provider-options](https://galeracluster.com/library/documentation/mysql-wsrep-options.html#wsrep-provider-options)  
[https://galeracluster.com/library/documentation/galera-parameters.html#pc-bootstrap](https://galeracluster.com/library/documentation/galera-parameters.html#pc-bootstrap)