Questions tagged [percona-xtradb-cluster]
Percona XtraDB Cluster is a high availability and high scalability solution for MySQL users.
40
questions
0
votes
1
answer
331
views
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 ...
- 1
0
votes
1
answer
245
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 ...
0
votes
0
answers
694
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 ...
- 101
0
votes
1
answer
184
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 ...
- 125
2
votes
1
answer
14k
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]# ...
- 21
0
votes
4
answers
2k
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 ...
- 740
0
votes
1
answer
819
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'...
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 ...
- 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 ...
- 11
0
votes
2
answers
664
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:
...
- 11
2
votes
1
answer
262
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 ...
- 1,724
0
votes
0
answers
361
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 ...
0
votes
0
answers
35
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 ...
- 203
0
votes
1
answer
103
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 ...
- 107
1
vote
0
answers
615
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 ...
- 111
0
votes
1
answer
314
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 ...
- 123
1
vote
1
answer
215
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 ...
- 443
2
votes
2
answers
5k
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 ...
- 141
1
vote
2
answers
663
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 ...
- 32.8k
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 ...
- 87
1
vote
1
answer
492
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 ...
- 11
-2
votes
1
answer
243
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 ...
- 463
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 ...
- 32.8k
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 [(...
- 1,295
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....
- 123
6
votes
2
answers
11k
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 ...
- 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 ...
2
votes
0
answers
666
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
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'...
- 619
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 ...
user169871
1
vote
1
answer
531
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 ...
- 32.8k
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/...
- 32.8k
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 ...
- 189
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:
...
- 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 ...
- 25
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 ...
- 272
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 ...
- 51.2k
1
vote
3
answers
549
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 ...
- 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....
- 2,063
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
- 3,108