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
6
votes
2 answers

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 Percona Cluster but my only concern currently is with…
5
votes
2 answers

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 [(none)]> show status like…
bwizzy
  • 1,265
  • 4
  • 14
  • 17
3
votes
4 answers

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: #!/bin/bash # # Script to make a proxy (ie HAProxy)…
ceejayoz
  • 32,469
  • 7
  • 81
  • 105
2
votes
1 answer

CentOS 7: Failed to restart mysql.service: Unit not found

I had installed and started Percona XtraDB Cluster 5.7 on 3 nodes. Everything went fine, until I had rebooted my first node. From then mysql.service couldn't be (re)started normally: [root@percona1]# systemctl restart mysql.service Failed to restart…
Sevak
  • 21
  • 1
  • 1
  • 5
2
votes
1 answer

Decreased performance of Mysql after superior hardware upgrade

I am quite new to Percona/database servers and i dont know how to approach the following issue. Couple of days ago i upgraded the hardware of a percona cluster (3 nodes) servers with a much more superior one. Specs of prevous hardware: Vendor: OEM …
giomanda
  • 1,644
  • 4
  • 20
  • 30
2
votes
2 answers

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 and systemctl reports failure. I have also tried…
Jai
  • 141
  • 3
  • 14
2
votes
2 answers

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.5.33a+maria-1~precise) but it is not installable And…
Spin0us
  • 123
  • 4
2
votes
0 answers

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 severe slowdown of the cluster for usually about 30 to…
2
votes
1 answer

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 due to the depsolving problems: ... --> Finished…
quanta
  • 50,327
  • 19
  • 152
  • 213
2
votes
3 answers

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:…
Oneiroi
  • 2,008
  • 1
  • 15
  • 28
2
votes
1 answer

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
HTF
  • 3,050
  • 14
  • 49
  • 78
1
vote
0 answers

Ignore a node while backup is active (GLB)

I'm building a HA cluster with CentOS 6 I have n number of database nodes (using percona xtradb cluster), and when backup process starts, I change the "wsrep_desync" to ON, this way locks caused by the backup tool doesn't affect to the other nodes.…
1
vote
0 answers

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 for installing these. For local development of our…
Derek
  • 111
  • 4
1
vote
1 answer

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 will be implemented with Gluster in redundant setup…
Udo G
  • 423
  • 4
  • 9
  • 19
1
vote
2 answers

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 busy, this causes a couple (2-4) error alerts along…
ceejayoz
  • 32,469
  • 7
  • 81
  • 105
1
2 3