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

learn more… | top users | synonyms

0
votes
0answers
3 views

WSREP galera cluster warning conflict state 7

I have started to use a pxc cluster, after a flow control deadlock I had to kill all but one instance. And now on this single instance I have the below warnings streaming in the log all the time: ...
0
votes
0answers
38 views

Ubuntu 14.04 and Percona 5.6 Server Cluster Setup

Thanks for any help you can provide I seem to be stuck on this error for hours. I am trying to setup a percona 5.6 cluster. I have installed on 14.04 these packages and removed any trace of mysql. ...
0
votes
1answer
47 views

Percona XtraDB Cluster duplicate keys when server taken out of rotation

I have a three node Percona XtraDB Cluster (5.5) setup. Every night, we shut down MySQL on one randomly selected node in order to take backups of the data directory. When our traffic is reasonably ...
1
vote
1answer
195 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
0
votes
0answers
15 views

Percona adding node to cluster safe?

I had a cluster with 3 nodes and 2 of them died, leaving only node 1 working, and this is a production environment that cannot stop. Is it safe to re-add one node to the cluster? Thank you
0
votes
1answer
131 views

Percona on EC2 ephemeral storage (part of XtraDB cluster)

We have a MySQL DB of roughly 100GB and want to move it into EC2. EBS volumes seem fairly slow for running MySQL databases (even with provisioned IOPS) and although we could use RAID10 to improve this ...
-2
votes
1answer
48 views

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 ...
0
votes
0answers
47 views

disconnect and reconnect node from percona xtradb cluster

I have a Percona Xtradb Cluster with 3 nodes. Which is the best way to disconnect and reconnect 1 node from the cluster with the node still working? Some suggestions include clear wsrep_provider or ...
0
votes
2answers
1k views

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 ...
2
votes
1answer
717 views

MariaDB / MySQL galera cluster nodes won't join

I'm setting up a MariaDB Galera cluster and I can’t seem to get the nodes to join each other. They both start up without errors but never seem to join, the status is always disconnected: MariaDB ...
2
votes
2answers
496 views

Ubuntu upgrade process failed

I tried to dist-upgrade my ubuntu server on my percona cluster but it failed with this message The following packages have unmet dependencies: libmysqlclient18 : Depends: libmariadbclient18 (= ...
5
votes
2answers
2k views

MariaDB Cluster vs Percona Cluster for MySQL

What are the advantages and and disadvantages between the two? I've only been able to find information on these two implementations without any specifics on clusters. I'm currently implementing a ...
-1
votes
1answer
137 views

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 ...
2
votes
0answers
264 views

Recurring locks and slowdowns on a Percona XtraDB Cluster

I have 5 dedicated servers (identical machines: 32 cores, 96GB of RAM, SSD drives in RAID and gigabit ethernet link) configured with Percona XtraDB Cluster. There's a recurring problem causing a ...
0
votes
0answers
52 views

Percona XtraDB cluster not replying to queries

Since last month, suddenly our percona cluster started to have connection issues as discussed in Percona Cluster Failed with Haproxy : Connection Limit Exceeded question. As @RolandoMySQLDBA ...
0
votes
2answers
940 views

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 ...
1
vote
1answer
270 views

Percona on 2nd node will not start

I have setup two Vagrant VMs to simulate Percona XtraDB Cluster for our development needs. The first VM comes online just fine, and everything works. However, when I try to start Percona on the 2nd VM ...
1
vote
1answer
100 views

syncing specific tables between two already-replicating MySQL clusters

I have a circularly replicating MySQL cluster, and a newer cluster of Percona XtraDB instances that we're in the process of moving to. During the move, we're running some projects on the old cluster ...
1
vote
4answers
504 views

xinetd 'connection reset by peer'

I'm using percona-clustercheck (which comes with Percona's XtraDB Cluster packages) with xinetd and I'm getting an error when trying to curl the clustercheck service. /usr/bin/clustercheck: ...
0
votes
1answer
214 views

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 ...
0
votes
1answer
643 views

Percona-Cluster: backup and restore procedure

I'm trying to restore a full backup taken from one node of a three-node percona cluster (percona cluster 5.5, galera 2.1, wsrep sst method is rsync, innodb tables only). Backup was taken like this: ...
0
votes
0answers
313 views

Migrate existing mysql server data to percona xtradb cluster

I currently have one server which is a mysql server. I want to get the data from it, into a new 3 node percona xtradb cluster i've set up. I am wondering if there's any alternatives to simply doing a ...
1
vote
1answer
1k views

Trouble setting up a Percona XtraDB cluster on 2 servers

I'm trying to set up a Percona XtraDB cluster on two machines.. but i'm having a terrible time in getting the second machine up and running. I have used this article as a reference, and while it ...
0
votes
0answers
141 views

Import large InnoDB table dump

i've a mysqldump ( 1.5G large ) of a table I need to import. The server i bought, which is clean and not under load, takes > 2hours to import it. I read many tweaks i can use to speed up the import ...
0
votes
1answer
844 views

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 ...
2
votes
1answer
690 views

How to install Percona XtraDB Cluster on x86 server?

I'm going to migrate from MySQL replication to Percona XtraDB Cluster. The problem I'm facing is one node is running on x86, and I cannot install Percona-XtraDB-Cluster-server from the Percona repo ...
1
vote
3answers
352 views

MySQL HA Solutions

I am evaluating the options to build MySQL HA and found the below solutions Percona XtraDB Cluster, Tungsten Replicator, and MySQL Cluster. Could you please help me to choose the best one with ...
2
votes
3answers
2k views

Percona XtraDB Cluster node recovery

I have been reviewing XtraDB clustering and produced a P.o.C. environment on Openstack using 4 instances, which has fallen over during my resilience testing. Per the pxc documentation: ...
1
vote
1answer
541 views

XtraBackup for SST with Xtradb cluster

I'm looking for some instructions/manual to set Percona Xtradb cluster with Xtrabackup for SST. Is there any configuration file where I need to provide login details for Xtrabackup script? Thanks