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

learn more… | top users | synonyms

0
votes
0answers
32 views

Percona Cluster - Single node crashed and could not join the cluster back again

I started a percona cluster with 3 nodes in docker containers. I use version 5.6.24. The cluster worked fine. After this I had the below observations. i) When I uninstalled all the nodes, and ...
0
votes
1answer
24 views

Galera cluster implementation questions

I've just successfully created my first Galera cluster using MariaDB 10.0.20 between three servers. I have a few questions regarding my implementation: 1. what will happen if one server becomes ...
1
vote
0answers
250 views

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository ...
0
votes
1answer
41 views

How to hold specific package version?

I have Percona XtraDB Cluster 5.6 installed on my Ubuntu server. Recently, when i tried to update my system using apt i see some new version of percona, but with an older version. The following ...
1
vote
1answer
90 views

Does hardware RAID1 offer significant advantages to S/W RAID in a computer cluster that's highly redundant?

I'm about to set up a Linux cluster of 5 physical server nodes (more nodes to be added later, probably). the cluster will be managed by Proxmox (and yes, it works in software RAID) shared storage ...
1
vote
2answers
1k views

Automatic MySQL shutdown is RHEL7

When I execute systemctl start mysql it starts MySQL but I don't get command prompt back, it just stays like that. Database starts normally. After couple of minutes database automatically shutdowns ...
0
votes
0answers
109 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: ...
1
vote
1answer
235 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
488 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
1answer
275 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
92 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
2answers
2k 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 ...
4
votes
1answer
2k 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
921 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 (= ...
6
votes
2answers
5k 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
539 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
456 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
2answers
2k 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
893 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
207 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
995 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
468 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 ...
1
vote
2answers
1k 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
561 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
2k 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
190 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
1k 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
785 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
420 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
3k 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
718 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