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
5
votes
3 answers

InnoDB: The innodb_system data file 'ibdata1' must be writable

I'm trying to run percona xtradb cluster. The output from the percona server is as followings: mysqld: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored. 2019-06-10T07:24:28.000875Z 0 [Warning] TIMESTAMP with implicit DEFAULT value…
Shudipta Sharma
  • 5,178
  • 3
  • 19
  • 33
3
votes
2 answers

Unable to restart MySQL server

I restarted MySQL server in one of the nodes in Percona Cluster. Since the restart took much time, I interrupted the process. I tried restarting the MySQL server again. I got the following error: Stale sst_in_progress file in datadir I followed…
Shriram Balakrishnan
  • 439
  • 5
  • 15
2
votes
1 answer

Second node of PXC dont join to cluster

Im trying to setup PXC with 3 nodes, 1st node was bootstrapped succesfully but when trying to start second node it cant get SST. Logfile from 2nd node: 2020-10-07T13:17:16.480905Z 0 [Note] [MY-000000] [WSREP] Initiating SST/IST transfer on JOINER…
Kirill K
  • 21
  • 3
2
votes
0 answers

Percona XtraDB Cluster Operator - mount additional storage (INFILE)

We have Percona XtraDB Cluster Operator setup on Kubernetes. In main configuration of cluster we have set persistentVolumeClaim option for pxc and proxysql. This is the query, we would like to execute on our Percona Cluster: LOAD DATA LOCAL INFILE…
Jakub Sakač
  • 21
  • 2
2
votes
2 answers

Is it necessary to duplicate user credentials when using proxysql in front of a database cluster?

I've set up a Percona Xtradb Cluster with 5 nodes on a network that also has a ProxySQL server. I have ProxySQL working, I can log in to the admin interface on port 6032 and administer it and I can also log in through port 6033, connecting to the…
jrebs
  • 413
  • 1
  • 3
  • 10
2
votes
1 answer

Does Debezium work with Percona Server and/or Percona XtraDB Cluster?

As a "drop in replacement" for MySQL, with I believe the same binlog and replication semantics, I assume anywhere in the Debezium docs it says "mysql" I could replace it with "percona" (or for that matter MariaDB), but I wanted to confirm before I…
jdowdell
  • 1,578
  • 12
  • 24
1
vote
0 answers

PHP Not able to capture MySQL binlog events on Percona Cluster

I'm working with this package here: https://github.com/krowinski/php-mysql-replication I've been able to test a very simple application on my local mysql database, with it working as expected. However, once I moved my testing to our production…
Chewy
  • 196
  • 1
  • 12
1
vote
0 answers

Does Docker Swarm have IPVS (IP fail-over) available?

Recently we have been investigating running Percona cluster with ProxySQL on Docker Swarm, the following guide for reference: https://www.percona.com/blog/2016/06/14/scaling-percona-xtradb-cluster-proxysql-docker-swarm/ Since ProxySQL is SQL load…
Thomas G. Lau
  • 226
  • 3
  • 14
1
vote
1 answer

Unable to delete perconaxtradbclusters which are in errored state

I've installed Percona XtraDB on kubernetes using 1.3.0 operator. After using it, I wanted to delete the namespace. So I deleted them in the order which I applied them. Everything is deleted and nothing is visible in svc, pods but there are two…
Pardha
  • 27
  • 4
1
vote
1 answer

Nomad Template : Folder is created instead of file

Why is it that when checking the container test.cnf is a directory instead of a file based on the templete stanza, can you check it please config { image = "percona/percona-xtradb-cluster:5.7" volumes =…
rkevx21
  • 2,441
  • 5
  • 19
  • 40
1
vote
1 answer

Cannot connect to MySQL: DBI connect(';host=1;mysql_read_default_group=client','dbops_usr',...) failed

pt-online schema unable to connect slave servers to monitor replica lags, Using below command and getting errors. pt-online-schema-change D=Percona,t=abcd_data_Jan,h=dbops.com,u=dbops_usr \ --ask-pass \ --max-lag 120 \ --check-slave-lag 1 \ …
Bharath
  • 21
  • 3
1
vote
0 answers

HAProxy Stats UI "Current Sessions" incorrect

I'm running HAProxy 1.5.18 to front a MySQL Percona XtraDB Cluster with everything setup as per guidelines on Percona website. I'm seeing that the "Current Sessions" statistic is not updating as I would expect for a backend that has gone down then…
Neil Billett
  • 11
  • 1
1
vote
1 answer

Percona install failing

After installing percona server so many times without issue it seems I've hit a unique one. # yum list installed | grep -i perc percona-release.noarch 0.1-10 @percona-release-noarch As you can see I only…
Logan Best
  • 501
  • 3
  • 7
  • 21
1
vote
0 answers

Galera 'Deadlock found when trying to get lock' on commit when a node drops

I'm seeing 'Deadlock found when trying to get lock' when issuing a COMMIT while a different node in the WAN Galera cluster has recently had connectivity issues (at virtually the same time as the COMMIT). In this particular situation I'm inserting…
human79
  • 11
  • 2
1
vote
1 answer

Starting a dead node of Percona XTradb cluster

We have a Xtradb cluster with three nodes. There is one node, which was not properly stopped and won't start. The other two nodes are correctly working and responding. The only thing in logs is this: -- Unit mysql.service has begun starting up. Aug…
Vojtěch
  • 11,312
  • 31
  • 103
  • 173
1
2 3 4