Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [percona-xtradb-cluster]

Percona XtraDB Cluster is a high availability and high scalability solution for MySQL users.

Percona XtraDB Cluster is a high availability and high scalability solution for MySQL users. XtraDB Cluster integrates Percona Server with the Galera library of high availability solutions in a single product package. XtraDB Cluster enables users to save money through:

  • Less downtime and higher availability
  • Reduced investment in high availability architectures
  • Lower DBA training and education costs
  • No investment in third-party,high availability solutions

Percona XtraDB Cluster features include:

  • Synchronous replication
  • Multi-master replication support
  • Parallel replication Automatic node provisioning

The focus for Percona XtraDB Cluster is data consistency at a significantly lower total cost than existing high availability solutions. XtraDB Cluster may be especially useful if your organization currently:

Uses MySQL replication to ensure high availability Needs a high availability solution for MySQL deployed in the cloud Is looking for a new, novel way to address previously impossible high availability challenges.

40 questions
0
votes
2 answers

new Percona XtraDB nodes unable to join cluster

I have a four node Percona XtraDB cluster. Each night, one node shuts down for a backup and subsequently rejoins the cluster. This has run fine for quite some time now. Last night, the backup node refused to rejoin the cluster. The other three nodes…
ceejayoz
  • 32,910
  • 7
  • 82
  • 106
0
votes
2 answers

Curl Failure when receiving data from peer using Percona XtraDB Cluster Check

I'm having a similar issue to the one mentioned here: xinetd 'connection reset by peer' I've setup percona-clustercheck (which comes with Percona's XtraDB Cluster packages) with xinetd and I'm getting an error when trying to curl clustercheck…
Brad
  • 619
  • 1
  • 10
  • 28
0
votes
1 answer

WSREP: Failed to prepare for 'rsync' SST. Unrecoverable

I ma using Percona Xtradb Cluster with 5 nodes. I used mysqld --console to trace and see this error WSREP: Failed to prepare for 'rsync' SST. Unrecoverable. Quote: 130320 18:49:37 [Warning] You need to use --log-bin to make --log-slave-updates…
Kevin Nguyen
  • 189
  • 1
  • 2
  • 8
0
votes
1 answer

Percona XtraDB Cluster - Node Won't Join

I am trying to add a node to a new cluster but am met with the following log entries: 120915 16:47:32 [Warning] WSREP: error executing 'SET GLOBAL innodb_disallow_writes=1': 1193 (Unknown system variable 'innodb_disallow_writes'). Was mysqld built…
Mike Mackintosh
  • 272
  • 3
  • 12
0
votes
1 answer

RHEL8.4 with Percona8.0.29 - Cluster fails error code 7

I have installed 3 x RHEL 8.4 Servers and have also installed the latest version of Percona XtraDB Cluster. I have left the my.cnf file pretty basic, wsrep also basic with just the required changes to node name, gcomm addressing and cluster…
CliveG
  • 1
  • 1
0
votes
1 answer

how to take mysql xtrabackup to a remote server

I have a server running with mysql with huge db of 1 TB. Now, I want to take full backup through percona xtra backup, because incremental backup is easy with percona xtrabackup. Now,if I initiate taking backup in that server,storage is getting…
Ravi Teja RVN
  • 1
  • 3
0
votes
0 answers

Removing a node from Galera Cluster

I have to update the os on a few servers and I need to remove a db from the cluster. wsrep_cluster_address='gcomm://192.168.2.59,192.168.2.60,192.168.2.61,192.168.2.62,192.168.2.63' Do I remove the ip adress from the cluster line then restart each…
user3525290
  • 101
  • 1
0
votes
1 answer

Can not stop mysqld after database upgrade

I have an old Galera cluster (MySQL 5.5) that I am upgrading to Percona XtraDB (MySQL 5.7) on Ubuntu 18.04 LTS. I have successfully imported the database with xtrabackup and synced the cluster - so far so good. My problem is that I can not stop the…
koenig
  • 125
  • 8
-1
votes
1 answer

installing Percona XtraDB Cluster on Ubuntu 13.04

So, a bit of explanation of the big picture: I am trying to get multiple PXC instances running on a single machine, replicating via Galera to each other. I am running Ubuntu Server 13.04 amd64 in a VirtualBox OSE virtual machine. I installed the…
lord_nullset
  • 1
  • 2
-2
votes
1 answer

Does Galera Arbitrator require a SST?

Does Galera Arbitrator require a SST? It says it's stateless but it's not clear if a SST i required. The reason for asking is that I'm having a large database and would like to skip the SST if possible.
Chrille
  • 463
  • 2
  • 5
  • 10
1 2
3