Questions tagged [xtradb-cluster]

Percona XtraDB Cluster : Synchronous Replication Cluster for MySQL

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
2 answers
92 views

Different Percona XtraDB nodes use different indexes for the same query

We have three Percona XtraDB nodes arranged in a master-master replication topology. One of our databases contains a heavily utilized table. This table has multiple indexes, as well as a few foreign ...
Anne Douwe's user avatar
2 votes
1 answer
253 views

Replicating into a Percona XtraDB Cluster

We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It has it's own database called archive but it is also the replication slave for a database called ...
phil-lavin's user avatar
1 vote
1 answer
234 views

Does wsrep_cluster_address only accept the intranet IPs?

I was installing Percona XtraDB Cluster with 3 nodes. Each node has a unique Internet IP address. Following the docs Quick Start Guide for Percona XtraDB Cluster, I got the first node running but ...
jungle's user avatar
  • 11
1 vote
0 answers
65 views

New percona xtradb node shuts itself down shortly after launch

We currently have a 3 node percona xtradb cluster running on premises. We are trying to add a 4th, remote node ( Obviously split-brain is a concern in this situation but it is only temporary while we ...
Flibx's user avatar
  • 11
1 vote
0 answers
990 views

What causes the creation of such a large number of Galera cache files?

I manage a Percona XtraDB 3-node cluster. Recently the MySQL datadir of one of the nodes (not the one from which the cluster has been bootstrapped) started being filled up with gcache.page.00nnnn ...
dr_'s user avatar
  • 1,314
1 vote
0 answers
532 views

Percona XtraDB Cluster With Async slaves

I have set up a 3 node percona cluster in amazon ec2. As our client required, i also had to set up an asynchronous slaves in another datacenter as well. Each async slave pointed to single percona ...
adinindu's user avatar
0 votes
0 answers
77 views

Page cleaner took ms to flush pages/WSREP has not yet prepared node for application use

I am running percona xtradb cluster 8.0. One of my nodes went down, when I try to bring it up. The log says the transfer is complete and joined. 0.0 (DB404): State transfer from 3.0 (DB403) complete....
user3525290's user avatar
0 votes
1 answer
3k views

Error: ERROR 1047 (08S01) at line 6955: WSREP has not yet prepared node for application use

While restoring a dump from a CloudSQL instance into a node of a Percona xtradb cluster, I am getting this error. The line 6955 in the .sql dump file is in bold below: DROP TABLE IF EXISTS `...
user5594148's user avatar
0 votes
1 answer
1k views

InnoDB Buffer causing a lot of deadlocks and connection/client timeouts

I have a PXC cluster (5.7) with three nodes running on CentOS 7 VMs, each with the following system info: mysql_db# free total used free shared buff/cache ...
The Georgia's user avatar
0 votes
0 answers
356 views

PXC duplicate entry issue

We have a Percona PXC with three nodes. last week, we had a third node, db-node-3, go down with an error: 2017-03-12T10:41:22.070396+08:00 30 [ERROR] Slave SQL: Could not execute Write_rows event on ...
The Georgia's user avatar
0 votes
1 answer
169 views

Backing up a single node Percona XtraDB Cluster

I have a single node percona XtraDB Cluster. Version: Server version: 5.6.15-56 Percona XtraDB Cluster (GPL), Release 25.5, Revision 759, wsrep_25.5.r4061 All tables in the DB are using InnoDB ...
Iokanaan Iokan's user avatar
0 votes
1 answer
111 views

Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?
dotcom's user avatar
  • 11
0 votes
0 answers
2k views

Why Percona MySQL is crashing again and again

We have Percona MySQL Cluster running with three nodes on CentOS. Server : Percona-XtraDB-Cluster-server-56-5.6.19-25.6.824.el6.x86_64 One node is crashing repeatedly. Thread pointer: 0x18910ba30 ...
Jai's user avatar
  • 133
0 votes
1 answer
1k views

How to change the replication State Transfer SST to IST in Galera Config

I would like to migrate 700GB data to galera cluster(2node+1arbitrator). I found that IST is the best method for huge DBs.So how to forecfully change the replication from SST to IST in Galera Config. ...
Rameez Raja's user avatar