Stack Overflow
Stack Overflow

Questions tagged [percona-xtradb-cluster]

For questions related to Percona XtraDB Cluster software. Generic Galera-based topics welcomed as well.

60 questions
0
votes
0 answers

Percona xtradb cluster a node can't join server

My node can't join the cluster. I'm installed both servers in Linux Debian 10, the server bootsrap ok, but the node can't join the server. I tried several settings and follow the guide, but without success. My server configuration is this: #…
mneu
  • 427
  • 3
  • 14
0
votes
1 answer

Percona Server MongoDB on Linux - How to resolve installation conflict with mongodb-org?

May I seek help, I am trying to install Percona Server for MongoDB on a linux machine. However I am encountering this error. The server has an existing mongodb and I am trying to install percona-server-mongodb via sudo yum install…
apelidoko
  • 782
  • 1
  • 7
  • 23
0
votes
1 answer

MySQL Percona cluster WSREP on INSERT

I have a problem with WSREP errors that I don't understand. I'd be glad if someone explained what's happening and how to fix it. My app has an endpoint for account creation. In the endpoint there are several requests to DB checking if account…
Alex K.
  • 835
  • 6
  • 15
0
votes
1 answer

Connection denied while trying to clone data (XtraBackup) from mysql-master (Kubernetes)

Friends, I trying run a replicated Mysql database with the help of XtraBackup and when it gets to the point when the second node tries to clone data from the master, I'm getting the following error (ERROR 1045 (28000): Access denied for user…
marcelo
  • 373
  • 6
  • 16
0
votes
0 answers

How to get Docker Image locally in Kubernetes

I have K8S cluster on machine(CentOS) which is not connected to internet, I mostly get docker images from the online machines and load like docker load -i myimages.tar.gz and add imagePullPolicy: IfNotPresent in manifest.yaml. It works fine. Now i…
ImranRazaKhan
  • 1,955
  • 5
  • 33
  • 74
0
votes
1 answer

xtrabackup does not write gtid information in xtrabackup_binlog_info

Software versions: xtrabackup 8.0.12 percona-xtradb-cluster-server 8.0.18-9 I am running xtrabackup with this options: --defaults-file=/etc/mysql/my.cnf --backup --user=backup --password=**** --parallel=4 --no-timestamp…
Selivanov Pavel
  • 338
  • 2
  • 11
  • 25
0
votes
1 answer

Getting "cannot find -lmysqlclient" when trying to install python mysqlclient

I'm trying to install the mysqlclient module in a virtual environment on RHEL with Percona clustering running a Mysql db. Each time it exits with this error gcc -pthread -shared -Wl,-z,relro -g build/temp.linux-x86_64-3.6/MySQLdb/_mysql.o…
timh
  • 35
  • 1
  • 7
0
votes
0 answers

Laravel conflicts with Percona DB because of tables without Primary Keys

Laravel has 2 tables (migration, password_resets) that don't have PK and is causing problems with Percona DB. My current fix to this is to set Percona into: SET GLOBAL pxc_strict_mode=PERMISSIVE; Error: SQLSTATE[HY000]: General error: 1105…
magicianiam
  • 1,474
  • 7
  • 33
  • 70
0
votes
1 answer

Docker Compose : Percona XtraDB Cluster Bootstrapping

I need some help. How can I bootstrap a Percona XtraDB Cluster on a docker-compose as 1st node? I have this my.cnf…
rkevx21
  • 2,441
  • 5
  • 19
  • 40
0
votes
1 answer

How does changing of isolation level affects on Galera Cluster

I'm currently playing with Percona XtraDB Cluster which is based on Galera Cluster. In Galera docs I saw the following: Warning: When using Galera Cluster in master-slave mode, all four levels are available to you, to the extend that MySQL supports…
Roman Proshin
  • 830
  • 2
  • 9
  • 18
0
votes
1 answer

Buffer length is less than expected payload length in mysql percona cluster

I am trying to setup a percona cluster (mysql) in corda for achieving high availability,I configured everything else and while trying to bring the corda node(notary) I am getting below error: …
Neenu Sunny
  • 15
  • 4
0
votes
1 answer

Capturing Xtrabackup metrics through MySQL DB

Have anyone worked on gathering insights related to Xtrabackup process? I would like to analyse the various Xtrabackup performance metrics. I know that for monitoring MySQL services itself, we use the information available in tables across…
Balajee Venkatesh
  • 1,041
  • 2
  • 18
  • 39
0
votes
1 answer

Galera mysql cluster fails to start in Kubernetes

Okay so I'm using a modified version of this repo: https://github.com/CaptTofu/mysql_replication_kubernetes/tree/master/galera_sync_replication modified files are: service: apiVersion: v1 kind: Service metadata: name: ro-db labels: unit:…
paltaa
  • 2,985
  • 13
  • 28
0
votes
1 answer

SQL root password lost on XtradbCluster Percona, how to reset?

I have a big problem. I have crash my PC, so I lost the ROOT password to access a Perconna Xtradbcluster Databases. I have access on the Centos ROOT user on clusters servers. (so not too bad) How can i change or reset the password without crashing…
Ouimaisnon Toiy
  • 25
  • 1
  • 7
0
votes
1 answer

Mysql 5.6 (Percona): How to Improve Query Performance of UPDATE and INSERT?

I'm running a Percona 5.6 cluster (3 nodes) on lxc containers. Each nodes hardware is as follows: 4 x Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz (2 Sockets) 16GB RAM 130GB HD My database is just under 4GB in size. I've managed to tweak the config…
David
  • 16,246
  • 34
  • 103
  • 162
1 2
3
4