0 Replies - 227 Views - Last Post: 08 September 2018 - 04:08 AM Rate Topic: -----

#1 behnamy   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 22
  • Joined: 02-July 15

ProxySQL in PXC and failing all nodes

Posted 08 September 2018 - 04:08 AM

I'm going to install Percona XtraDB Cluster, and I have two questions about it:

1- Is it the last step? https://www.percona....EST/verify.html

Or installing ProxySQL is mandatory? I have only 3 nodes and not planning to add an extra node only for ProxySQL! And I think I don't even need it, my round-robin load-balancer is sending the requests to these servers randomly (without health controlling).

So if a node is down it can't even read/write to the DB. in a nutshell, my application nodes are the same as my DB nodes, and a load-balancer in front of them, So I think I don't need ProxySQL, Am I?

2- What happens if all 3 nodes are down together, I think if this situation happens in a common Group Replication of MySQL, all the cluster collapses and all nodes are being removed from the cluster and we need to reconfigure the cluster manually again, Is the same problem exists in PXC or not?

Any good tutorial about installing PXC?

Is This A Good Question/Topic? 0
  • +

Page 1 of 1