Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [xtradb-cluster]

Percona XtraDB Cluster : Synchronous Replication Cluster for MySQL

Percona XtraDB Cluster (PXC) is a MySQL Clustering product created by Percona that features

  • High Availability
  • Synchronous Replication
  • MultiMaster Support
  • Cluster-Wide Transaction Support for InnoDB/XtraDB
  • Limited Support for MyISAM
  • Ability to Add and Remove Nodes

PXC uses WriteSet Replication (created by Codership as MySQL Galera). The Galera library is already embedded at installation time in the Percona Server binaries.

Adding Nodes requires setting up wsrep_sst_method. It can use

once a new node is introduced.

PXC adds the New node to the Database Cluster using Quorom Selection as follows:

  • PXC chooses a node to volunteer as a DONOR
  • DONOR goes offline
  • PXC has DONOR execute the wsrep_sst_method to copy data to new Node
  • DONOR comes back online
  • New Node comes online

Documentation gives your limitations and gotchas, so please read documentation well.

59 questions
16
votes
2 answers

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then why isn't Galera cluster as common?
Sam
  • 344
  • 1
  • 2
  • 12
8
votes
3 answers

How to run OPTIMIZE TABLE on a 3-node cluster?

I've my hands on a 3-node Percona XtraDB Cluster where, according to mysqlcheck, some tables are corrupted (some indexes contain the wrong number of entries): mydb.mytable Warning : InnoDB: Index 'foo' contains 1393929 entries, should be…
dr_
  • 1,334
  • 4
  • 19
  • 40
6
votes
2 answers

Scaling Percona datacenters: setup and replication

Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you. We have already scaled alot of our application stack: we offloaded our high read/write tables for temporary…
tnosaj
  • 300
  • 3
  • 7
5
votes
1 answer

Does it make sense to run a cluster of database servers in docker containers?

I'm currently looking into setting up a database cluster (MySQL Galera or Percona) but I have only 2 machines. However, according to many sources I've read (This article from the Mariadb KB), the minimal node size in the cluster should be 3, to…
patatepartie
  • 53
  • 1
  • 3
4
votes
2 answers

Percona XtraDB Cluster and MySQL Replication

I've setup a 3-node multi master replication with percona xtradb cluster, it works perfectly. Now I've tried to add some read-only slaves setting up replication as usual but it seems the binlog doesn't include the new inserts, I've set binlog_do_db…
alex88
  • 143
  • 1
  • 5
4
votes
1 answer

How to clear gcache pages in Percona PXC

I have a 4 node cluster(percona PXC) and one of the nodes have more than 150 gcache disk files each of size ~128 MB. I would like to purge or flush them so that the server user fresh gcache disk file. I am not sure if the node restart will do it for…
Uday
  • 814
  • 3
  • 13
  • 27
3
votes
1 answer

Percona Node fails to join: Operation not permitted

Joining a new Percona node fails with: 130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (7ff38373-c1d1-11e2-0800-d595d1800e6a):…
Gajus
  • 1,334
  • 16
  • 29
3
votes
2 answers

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 keys and their corresponding indexes. Output of…
Anne Douwe
  • 81
  • 3
3
votes
1 answer

Does this make my XtraDB Cluster hang?

After seeing the following in the error log on the second node: 121003 7:16:06 [Note] WSREP: Member 0 (joiner) synced with group. 121003 7:16:06 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) 121003 7:16:06 [Note] WSREP: Synchronized with group,…
quanta
  • 1,006
  • 9
  • 22
  • 36
3
votes
1 answer

How to perform backup on quite active 500G+ MariaDB Galera Cluster?

what would be your preferred method to perform backup on quite active 500G+ MariaDB Galera Cluster? Using mariabackup/innobackupex (fork of Percona Xtrabackup) with throttle. You must think about FLUSH TABLES WITH READ LOCK which can cause problems…
Marko Sutic
  • 31
  • 1
  • 3
2
votes
1 answer

Will large inserts crash a 3-node MySQL database cluster?

We have a 3 node MySQL database cluster than runs on Percona. I have a stored procedure that inserts a lot of rows in one hit, potentially over a million rows. I've been warned (by our DBA) this might cause the cluster to crash, but I can't find…
Ashley
  • 123
  • 5
2
votes
2 answers

node unable to join a galera cluster; it fails during state transfer

It looks like the node is joining the cluster and then it fails… I have tried with both rsync and xtrabackup and it fails during state transfer. I seems to me that I am missing something real simple and I am not able to put a finger on it.. Any help…
nimesh
  • 21
  • 1
  • 1
  • 2
2
votes
2 answers

Percona XtraDB Cluster - do I add arbiter IP in gcomm://?

I'm configuring Percona XtraDB Cluster 8 on two nodes, and use a 3rd node to act as an arbiter. I cannot make up out of the docs whether to add the IP of the arbiter in the galera nodes addresses of the arbiter’s configuration. # A comma-separated…
Kevin C
  • 113
  • 8
2
votes
1 answer

Percona XtraDB Cluster: How to skip SST when starting?

Is there a way to skip State Snapshot Transfer (SST) at startup on Percona XtraDB Cluster Server? wsrep_sst_mode=skip doesn't work: 121003 6:49:55 Percona XtraDB (http://www.percona.com) 1.1.8-rel28.1 started; log sequence number…
quanta
  • 1,006
  • 9
  • 22
  • 36
2
votes
1 answer

Sync mysql database between 2 geo locations (datacenters)

We have a database cluster built on Percona MySQL. We are going to extend our redundancy with another database cluster with a new data center located in another GEO location. So that in case of failures in one location, we can switch the service to…
Muneer
  • 146
  • 1
  • 6
1
2 3 4