Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [percona-xtradb-cluster]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
27 views

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 ...
user avatar
0 votes
0 answers
18 views

mysql not being pushed to the background after restart

The mysql service is not being pushed to the background after startup. I start the service with sudo systemctl start mysql.service it starts up. I can connect send queries. But the the command stays ...
user avatar
0 votes
0 answers
237 views

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 ...
user avatar
0 votes
1 answer
100 views

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 ...
user avatar
  • 113
2 votes
1 answer
11k views

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]# ...
user avatar
  • 21
0 votes
4 answers
1k views

mysql (Perconadb) Galera/Xtrabackup cluster join fails with "Invalid Argument"

I have a MySQL Galera cluster, using Perconadb and Xtrabackup. The nodes can start stand-alone, or can join the cluster if only an IST is required. However, if an SST is required, then this runs to ...
user avatar
0 votes
1 answer
770 views

Initial Xtradb Cluster setup -- each node comes up isolated

I'm setting up a percona-xtradb-cluster-57 (3 nodes) on Ubuntu 16.04. They are to communicate using a private network, 10.254.10.101 through 10.254.10.103. When I follow the instructions on Percona'...
user avatar
0 votes
1 answer
2k views

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database. I would like to perform 'hot backups' simply using mysqldump on one of ...
user avatar
  • 133
1 vote
0 answers
65 views

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 ...
user avatar
0 votes
2 answers
647 views

Percona mysql-server on ubuntu 16.04

Issue: Can't install Percona mysql server. Platform: Ubuntu 16.04 x64 Server is an Openvz container. Memory: 1.5GB installation method apt-get install percona-xtradb-cluster-server-5.6 Source: ...
user avatar
2 votes
1 answer
248 views

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 ...
user avatar
  • 1,595
0 votes
0 answers
302 views

Do I need binlogs with a Percona xtradb cluster?

If I am running an XtraDB cluster, with no replication, do I need binlogs? They're enabled and chewing up disk space. I'm aware I can restrict their number using max_binlog_files, but I'm not sure if ...
user avatar
0 votes
0 answers
34 views

What is an efficient means to serve a dynamic website globally, in terms of latency? [duplicate]

We're using Amazon's AWS infrastructure. At one time, we did have a load-balanced setup across geographic regions, and our database cluster was divided between those regions. To reduce costs for the ...
user avatar
  • 183
0 votes
1 answer
89 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 ...
user avatar
  • 97
1 vote
0 answers
610 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 ...
user avatar
  • 111
0 votes
1 answer
280 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 ...
user avatar
  • 123
1 vote
1 answer
204 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 ...
user avatar
  • 423
2 votes
2 answers
4k 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 ...
user avatar
  • 141
1 vote
2 answers
631 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 ...
user avatar
  • 32.1k
1 vote
1 answer
1k 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 ...
user avatar
1 vote
1 answer
481 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 ...
user avatar
  • 11
-2 votes
1 answer
231 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 ...
user avatar
  • 453
0 votes
2 answers
4k 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 ...
user avatar
  • 32.1k
5 votes
2 answers
13k 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 [(...
user avatar
  • 1,245
2 votes
2 answers
1k 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.5....
user avatar
  • 123
6 votes
2 answers
10k 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 ...
user avatar
  • 63
-1 votes
1 answer
1k 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 ...
user avatar
2 votes
0 answers
648 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 ...
user avatar
0 votes
2 answers
4k 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 I'...
user avatar
  • 539
1 vote
1 answer
3k 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 ...
user avatar
1 vote
1 answer
528 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 ...
user avatar
  • 32.1k
3 votes
4 answers
3k 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: #!/bin/...
user avatar
  • 32.1k
0 votes
1 answer
3k 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 ...
user avatar
1 vote
2 answers
3k 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: ...
user avatar
  • 379
1 vote
1 answer
4k 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 ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
2 votes
1 answer
930 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 ...
user avatar
  • 50k
1 vote
3 answers
546 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 ...
user avatar
  • 247
2 votes
3 answers
5k 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: http://www....
user avatar
  • 1,978
2 votes
1 answer
1k 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
user avatar
  • 3,010