Questions tagged [xtradb-cluster]
Percona XtraDB Cluster : Synchronous Replication Cluster for MySQL
0
votes
0answers
30 views
Percona XtraDB Cluster 5.6 commit slow
I'm running Percona-XtraDB-Cluster-server-56 with Version : 5.6.39 Release : 26.25.1.el6. with 2 node PXC + 1 Garbd monitor.
Sometime commit command is slow, it affect to all commit command at that ...
0
votes
1answer
50 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 ...
0
votes
0answers
30 views
Orphaned foreign keys in mysql table
I'm running a Percona XtraDB Cluster with MySQL 5.7.12, which (amongst others) contains two tables like the following:
Create Table: CREATE TABLE `t1` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
...
1
vote
1answer
15 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 ...
1
vote
1answer
16 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 ...
1
vote
2answers
332 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 ...
1
vote
2answers
168 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 ...
0
votes
2answers
154 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 ...
2
votes
1answer
503 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 ...
0
votes
1answer
1k 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:
/...
0
votes
0answers
180 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 ...
1
vote
1answer
259 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 ...
0
votes
0answers
61 views
slave replication from XtraDB three nodes cluster
We have business requirement to replicate databases from XtraDB three nodes cluster to a single slave Percona, questions:
Is this document suitable to setup slave replication from XtraDB cluster? ...
1
vote
1answer
28 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 (...
1
vote
1answer
192 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 ...
0
votes
1answer
167 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 ...
0
votes
0answers
357 views
MySQL replication from 5.7 master to 5.5 slave
Currently I am running Percona XtraDB Cluster 5.5. To switch smoothly to 5.7, I need to set up two-directions replication between one of cluster nodes and standalone PXC 5.7 node. So that I can switch ...
0
votes
1answer
89 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 ...
1
vote
1answer
1k 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="...
0
votes
1answer
1k 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)).
...
0
votes
0answers
45 views
IGNORE_SERVER_IDS in config file
can we add IGNORE_SERVER_IDS variable to /etc/my.cnf configuration file in percona xtradb cluster or mysql server. i am forgetting every time while issuing change master to command while setting up ...
0
votes
1answer
323 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 ...
1
vote
0answers
37 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 ...
4
votes
1answer
925 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.
...
0
votes
1answer
25 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 ...
1
vote
1answer
160 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 ...
1
vote
3answers
841 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 ...
0
votes
1answer
85 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?
0
votes
1answer
175 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---- ...
0
votes
1answer
542 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.
...
5
votes
2answers
1k 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 '...
1
vote
0answers
488 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 ...
2
votes
3answers
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
votes
1answer
300 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 ...
1
vote
1answer
48 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 ...
2
votes
3answers
702 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 ...
2
votes
1answer
330 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 ...
2
votes
2answers
3k 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/...
2
votes
1answer
891 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 ...
1
vote
1answer
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 ...
0
votes
0answers
105 views
Migrate from Percona Cluster to MariaDB Cluster
We are at present running latest version (5.6) of Percona Cluster. Since 5.6 upgrade we are having major stability problems and all minor updates are getting worse.
Is there any possibility of ...
5
votes
1answer
3k 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 ...
0
votes
0answers
1k 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
...
1
vote
1answer
962 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
vote
1answer
1k 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:...
11
votes
2answers
6k 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 ...
1
vote
2answers
29k 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 ...
0
votes
2answers
4k views
Percona Xtradb Cluster : How to speed up insert?
I recently installed a 3 full master node cluster based on Percona Xtradb (very easy install). But now i need to make some tuning to increase INSERT/UPDATE requests. Actually, i made around 100 ...
1
vote
1answer
1k views
Percona Cluster Failed with Haproxy : Connection Limit Exceeded
We have 3 node PXC cluster setup on amazon ec2. Its been working fine for around 4-5 months. Since last week, every node starting to fail due to MySQL connection limit exceeded error. we increased the ...
1
vote
0answers
379 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 ...
