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
1
vote
2 answers

Designing XtraDB cluster

We have an application which consists of microservices all connected to the same Percona DB instance. Currently it is just one instance with 16 cores/32 GB memory without replication. One of our issues is that sometimes one of our microservices…
Vojtěch
  • 11,312
  • 31
  • 103
  • 173
1
vote
2 answers

Master-Master Replication [Percona]

Please forgive my ignorance but I do not have a ton of experience with MySQL. I am a web developer but overall I have pretty much just installed MySQL or spun up an RDS instance, connected to it and everything just works. However I am currently…
CMOS
  • 2,727
  • 8
  • 47
  • 83
1
vote
2 answers

How can I replicate containers inside docker service when I restart docker daemon?

I created docker service for the image percona XtraDB cluster with 3 replicas using the following command docker service create \ --name mysql-galera \ --replicas 3 \ -p 3306:3306 \ --network mynet \ --env MYSQL_ROOT_PASSWORD=mypassword \ --env…
Manjunath PV
  • 326
  • 1
  • 2
  • 13
1
vote
1 answer

PXC cluster across datacenter

I am a fresh about PXC. I wonder if I can deploy a cluster across three datacenters. For example: Node A in data center 1 Node B in data center 2 Node C in data center 3 The latency between data center 1 and data center 2 is low because they are…
xinxu wang
  • 11
  • 2
1
vote
2 answers

How to recovery cluster when all nodes down?

If all nodes in a 3-nodes Percona Cluster have shutdown (gracefully shutdown or crash), from this blog, it says that when the nodes could reach each other, the cluster could recover automatically. However, starting the nodes in such a situation…
flyer
  • 9,280
  • 11
  • 46
  • 62
1
vote
1 answer

How to connect to ProxySQL from application

I have Percona XtraDB Cluster running in 3 nodes (node1, node2, node3). I've configured ProxySQL in the 4th node (admin). I have an python application code trying to access the cluster. While connecting to 3306 port of node1, I'm able to…
Anju
  • 631
  • 2
  • 9
  • 25
0
votes
0 answers

Mysql on k8s for developers from external xtrabackup backup

The company has a production mysql cluster on the servers and need to place 10-15 environments for developers with their own database, as well as periodically update this database with the sale. My idea was to use mysql operator, deploy conditional…
Allanian Shade
  • 37
  • 1
  • 5
0
votes
0 answers

Mysql Slave not showing updates

I have a 3 node Percona XtraDB Mysql Cluster (PXC) , and separately a 1 node Async slave. I recently upgraded the Percona cluter to Mysql 8.0.29 from 5.7. I used Percona's xtrabackup to transfer the data to the slave (I have done this dozens of…
Meir W
  • 1
  • 2
0
votes
0 answers

Partitioning problem after Percona XtraDB cluster upgrading

Problem After upgrading Percona XtraDB cluster from 5 version to 8 version (8.0.28-19.1) I have some problems with the cluster in prod environment: Time of partition updating was increased 5 times. (before average time was about 2 sec, now it is…
Maksym Fedorov
  • 6,383
  • 2
  • 11
  • 31
0
votes
0 answers

Percona xtradb mysql backup process resume from the point of failure

I need to take full backup of xtradb mysql cluster setup. Consider that backup process got failed almost at the end of it and if we start again from starting point it would cost more in terms of money as well as time. Any ways to handle this…
SSHanga
  • 27
  • 3
0
votes
1 answer

how to take mysql xtrabackup to a remote server

I have a server running with mysql with huge db of 1 TB. Now, I want to take full backup through percona xtra backup, because incremental backup is easy with percona xtrabackup. Now,if I initiate taking backup in that server,storage is getting…
Ravi Teja RVN
  • 61
  • 6
0
votes
1 answer

mysql transaction loct stuck

I am updating a table and I seem to have a lock and it will not release. If i am reading this correctly the transaction 2 has been rolled back, but transaction 1 is still locking my table. Is there a way to force kill the transaction and roll it…
user3525290
  • 1,557
  • 2
  • 20
  • 47
0
votes
1 answer

Percona client installation failed in linux server with aarch64 architecture

I am trying to install Percona client on two different Linux servers with the same ubuntu version (20.04.2 LTS), but with different architecture. The percona client got successfully installed in the server with x86_64(amd64) architecture but failing…
Surya Jai
  • 11
  • 1
0
votes
1 answer

MySQL database with wrong character set and LONGTEXT's with binary data

I have Percona XtraDB 5.6 server with very old database with charset set to utf8 and data encoded in different charset (probably latin1). I tried to migrate the database to new Percona 8.0 server but after importing the SQL file, all diacritic marks…
conelbst
  • 1
0
votes
0 answers

How to connect 2 Percona Clusters in two data centers

I have been trying to figure this out the pass couple of weeks. We used to have a 5 host Percona cluster at different providers. When it started acting up I read that it is a bad idea to have synchronous replication across data centers. Now we have…
Les
  • 33
  • 3
1
2
3 4