Questions tagged [xtradb-cluster]
Percona XtraDB Cluster : Synchronous Replication Cluster for MySQL
57
questions
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 ...
CommunityBot
- 1
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 ...
- 1
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 `...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
0
votes
1
answer
32
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 ...
- 113
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....
- 77k
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 ...
CommunityBot
- 1
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---- ...
CommunityBot
- 1
1
vote
1
answer
515
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 ...
CommunityBot
- 1
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?
CommunityBot
- 1
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 ...
- 83k
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 ...
- 77k
2
votes
2
answers
11k
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:
/...
- 11
2
votes
1
answer
799
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 ...
CommunityBot
- 1
0
votes
1
answer
69
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 ...
- 268
2
votes
2
answers
170
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 ...
- 727
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 '...
- 182k
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 ...
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 ...
CommunityBot
- 1
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 ...
- 141
0
votes
1
answer
742
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 ...
CommunityBot
- 1
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 ...
- 31
1
vote
2
answers
656
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 ...
CommunityBot
- 1
0
votes
2
answers
894
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 ...
- 16
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/...
CommunityBot
- 1
1
vote
1
answer
661
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 ...
- 77k
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 ...
- 333
3
votes
1
answer
2k
views
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)
...
CommunityBot
- 1
2
votes
1
answer
643
views
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-...
- 182k
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 ...
CommunityBot
- 1
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 (...
- 77k
0
votes
1
answer
275
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 ...
- 77k
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.
...
CommunityBot
- 1
2
votes
2
answers
38k
views
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 ...
- 111
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="...
- 121
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)).
...
- 161
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 ...
- 2,078
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.
...
CommunityBot
- 1
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 ...
- 11
0
votes
1
answer
44
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 ...
- 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 ...
- 1,314
2
votes
1
answer
502
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 ...
CommunityBot
- 1
1
vote
1
answer
53
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 ...
- 5,080
2
votes
1
answer
477
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 ...
CommunityBot
- 1
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 ...
- 14.8k
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 ...
CommunityBot
- 1
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:...
CommunityBot
- 1
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-...
- 1
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 ...
- 14.8k