Questions tagged [xtradb-cluster]

Percona XtraDB Cluster : Synchronous Replication Cluster for MySQL

Filter by
Sorted by
Tagged with
1 vote
0 answers
19 views
+50

Percona XtraDB Cluster: State transfer failed: -13 (Permission denied)

I have started the first node with the bootstrap option, and it is running well and serving queries. sudo service mysql@bootstrap start However, when I try to add the 2nd and 3rd nodes, they both ...
Cyril Graze's user avatar
3 votes
2 answers
88 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
0 votes
1 answer
30 views

command: apply_migration, originalError: Error 1845: LOCK=NONE is not supported for this operation. Try LOCK=SHARED

I've got this error during app schema migration {"timestamp":"2023-01-11 11:53:09.043 Z","level":"fatal","msg":"Failed to apply database ...
laimison's user avatar
  • 113
0 votes
0 answers
70 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
2k views

"Percona-XtraDB-Cluster prohibits use of ALTER command on a table (<example>) that resides in non-transactional storage engine"

I installed a Percona XtraDB cluster with pxc_strict_mode set to ENFORCING, and am trying to import databases from non-Galera MariaDB servers. This works fine for some databases, by dumping them via ...
gecko's user avatar
  • 3
0 votes
1 answer
67 views

Percona xtradb cluster 5.7 solution on AWS and on premise. Not all nodes are connected to

We have 3 nodes cluster. 2 in virginia and 1 in ohio. The cluster is working fine we do not have any issues. But nothing pop out when we started doing extensive monitoring using datadog. It shows that ...
black sensei's user avatar
2 votes
2 answers
164 views

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 ...
Kevin C's user avatar
  • 113
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
2 answers
1k views

Percona Xtradb cluster 56 node 2 rejoin cluster failed

I have following DB cluster: Node 1: Percona-XtraDB-Cluster-56-5.6.39-26.25.1 Node 2: Percona-XtraDB-Cluster-56-5.6.39-26.25.1 Node 3: Percona-XtraDB-Cluster-56-5.6.41-28.28.1 I start in order ...
Viet's user avatar
  • 103
0 votes
0 answers
1k views

Is ProxySQL Suitable for Connection Pooling Apps?

I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up? I've found ...
Hexodus'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
2 votes
1 answer
788 views

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 ...
Muneer's user avatar
  • 146
1 vote
1 answer
228 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
2 answers
2k views

ProxySQL user not connecting - XtraDB

I'm trying to set up a xtraDB Cluster consisting of 3 nodes. Now i've got the cluster up and running and per the instructions i'm trying to set up ProxySQL for load balancing. So i've installed ...
Jdeboer's user avatar
  • 31
1 vote
2 answers
650 views

MySQL XtraDB/Galera Cluster High Availability RamDisk *SuperFast*

Ok, So this is going to be a speculative question, mostly design oriented and a rather long one. I'd grab a cuppa' covfefe, if I were you. Preface: So I have been researching into databases and ...
Mohd Abdul Mujib's user avatar
0 votes
2 answers
872 views

Percona XtraDb cluster auto increment

Help me please clarify a very important question on which I can't find the answer. It only can be proven with tests. Let's say we have XtraDB Cluster (or Galera Cluster) with three nodes. We have ...
Taggart Comet's user avatar
3 votes
1 answer
3k views

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 ...
Marko Sutic's user avatar
2 votes
2 answers
10k views

Percona - Unable to start mysql after restart

I just configured a percona xtradb cluster in ubuntu with 2 node. This is what I did. launched 2 new servers. Installed percona cluster on both nodes. Stopped mysql on both nodes. On server1: /...
TheDataGuy's user avatar
  • 1,900
0 votes
0 answers
352 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
1 vote
1 answer
639 views

Transfer data from standard mysql server to Percona XtraDB Cluster

My old mysql 5.5 server is having some hardware issue, so now I'm going to setup a new Percona 5.7, two node cluster in my environment and connect my app into it. Now the problem is, How should I ...
Lakal Malimage's user avatar
1 vote
1 answer
66 views

Fragmentation with PXC setup using an ordered UUID as PK

I am looking to implement a table which will accessable via a Percona XtraDB cluster of 3+ nodes. I am expecting it to grow at about 1mil rows per month and the data will be kept for about 2 years (...
justacodemonkey's user avatar
1 vote
1 answer
499 views

Inconsistency in Tables - Mariadb Galera Cluster

MariaDB cluster Version : mysql Ver 15.1 Distrib 10.0.24-MariaDB, I have a two node + arbitrator cluster which is live and replicating data across nodes. Unfortunately we found some inconsistency in ...
Rameez's user avatar
  • 121
0 votes
1 answer
273 views

How to sync two or more collocation database server?

I can't tell if mysql clustering could be a solution(I am thinking about galera or xtradb clustering). But my biggest problem is about the unstable internet connection. Actually it is planned as ...
zer09's user avatar
  • 453
0 votes
1 answer
168 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
1 vote
1 answer
2k views

Percona Xtradb Cluster 5.5: node can't join cluster - SST fails with auth problem

I have 3-nodes PXC 5.5 cluster. Settings on node03 in my.cnf [mysqld] section: wsrep_cluster_address=gcomm://<ip_node1>,<ip_node2> wsrep_cluster_name=cluster wsrep_provider_options="...
Selivanov Pavel's user avatar
0 votes
1 answer
2k views

Can't add a node to PXC due to SST error

I've successfully bootstrap a Cluster (mysqld Ver 5.6.30-76.3-56 for debian-linux-gnu on x86_64 (Percona XtraDB Cluster (GPL), Release rel76.3, Revision aa929cb, WSREP version 25.16, wsrep_25.16)). ...
s.meissner's user avatar
0 votes
1 answer
733 views

how to change wsrep_cluster_size in Percona XtraDB Cluste?

I am trying to setup Percona XtraDB Cluster according to their doc When I run show status like 'wsrep%'; it's show wsrep_cluster_size is 1 in every node(2 node for me). Actually it should be 1 for ...
pico's user avatar
  • 15
1 vote
0 answers
64 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
4 votes
1 answer
3k views

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. ...
Uday's user avatar
  • 794
0 votes
1 answer
41 views

Failed transaction replicated and thrown errors on remaining Percona XtraDB cluster nodes

I am using Percona XtraDB cluster 5.5.37. I have run one alter command (to add unique constraint) on node1. But due to duplicate keys,alter command failed on it. But that failed statement passed to ...
kasi's user avatar
  • 419
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
2 votes
3 answers
2k views

Scaling for MariaDB / Percona / Galera Scaling

I ventured into the world of NoSQL database and as great as they are the lack of true ACID compliance has been a nightmare resulting in a lot of bad data so I am looking into relational databases. I ...
user2924127'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
2 votes
2 answers
1k views

Suddenly a massive amount of binlog files

I've seen a sudden increase of binlog files, very large in number and size, in all three nodes of a Percona XtraDB cluster: -rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:11 binlog-32.000001 -rw-rw---- ...
dr_'s user avatar
  • 1,304
0 votes
1 answer
980 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
8 votes
3 answers
5k views

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 '...
dr_'s user avatar
  • 1,304
1 vote
0 answers
979 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,304
2 votes
3 answers
2k views

Percona XtraDB - Random deadlock

Randomly my database gets locked completely and queries hang and they pile up until it gets "Too many connections". Below is my mysql log file, I couldn't find anything related to the error system ...
Erico's user avatar
  • 368
2 votes
1 answer
487 views

Split brain scenario - RAC and PXC

Even though split brain scenario occurs in both Oracle RAC and Percona's XtraDB Cluster, a two node cluster is allowed and split brain scenario is resolved in RAC but a two node is not recommended in ...
tesla747's user avatar
  • 1,866
1 vote
1 answer
52 views

MariaDB cluster and external data feed

I've just finished setting up the 3 nodes mariadb (galera) cluster (let's call the nodes node1, node2 and node3). In order to have the cluster up to date with currently working mariadb database (let's ...
szymon's user avatar
  • 11
2 votes
3 answers
1k views

9 node percona xtradb cluster

We are looking to launch a 9 node percona xtradb cluster on Amazon where each ec2 node uses 20k iops disks. I was afraid if a 9 node cluster will work and mostly what I see is 3 node clusters. We ...
roger moore's user avatar
2 votes
1 answer
473 views

Innobackupex apply-log should be done before emergency restore or after each backup?

Basically Percona Innobackupex consist with three steps: 1. Backup 2. Apply log 3. Copy back restore during emergency My question: When should I do apply log? Is it after each backup or before ...
Thomas G. Lau's user avatar
2 votes
2 answers
4k views

Percona xtradb cluster node2 won't start

I have configured Percona Xtradb cluster 5.6. The first node starts fine when bootstrapped, but the second node seems to have an issue with this variable setting: wsrep_provider=/usr/lib/...
The Georgia's user avatar
2 votes
1 answer
2k views

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 ...
Ashley's user avatar
  • 123
1 vote
1 answer
2k views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
IGGt's user avatar
  • 2,066
5 votes
1 answer
4k views

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 ...
patatepartie's user avatar
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
1 vote
1 answer
1k views

Percona cluster + Wordpress blogs, low performance

We currently run ~ 900 WordPress blogs on several machines so was decided to move to load balanced environment with clustered db. I followed instructions from http://www.percona.com/doc/percona-...
Jhon's user avatar
  • 111
1 vote
1 answer
2k views

Cannot execute statement: impossible to write to binary log?

When I try to create a user story/issue in my my percona xtradb cluster I am getting below error. How to fix it? Error creating issue: Could not create workflow instance: root cause: while inserting:...
user3706807's user avatar
15 votes
2 answers
9k views

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 ...
Sam's user avatar
  • 334