Stack Overflow
Stack Overflow

Questions tagged [xtradb]

50 questions
0
votes
0 answers

Percona cluster automatic fail-over not working

I'm deploying Percona Xtradb-Cluster and get stuck at automatic fail-over. When I stop node 2 in database not auto update status. This is log: 2017-06-23 23:37:29 MySQL_Monitor.cpp:1126:monitor_ping(): [ERROR] Server 192.168.1.11:3306 missed 3…
Zerosk
  • 1
  • 1
0
votes
0 answers

How to run Percona XtraDB Cluster with external data directory?

When I run Percona XtraDB Cluster with external data directory (I try to restore from backup made with Percona XtraBackup), I have error: --initialize specified but the data directory has files in it. Aborting. How can I fix it? Docker…
Roman Cherepanov
  • 1,639
  • 2
  • 24
  • 44
0
votes
1 answer

Amazon RDS Maria DB "Unknown storage engine 'XtraDB'"

I'm using the free tier of Amazon RDS with Maria DB; all as basic configuration as it offers while I get to grips with RDS. I'm getting the following error from the MariaDB instance when I try to use the XtraDB engine: [2017-03-09 09:08:42]…
Lewis
  • 624
  • 9
  • 16
0
votes
2 answers

How can I create Percona XtraDB cluster with Docker?

I need to create Percona XtraDB cluster with "star" topology: with one master node (where I insert data) and two slave nodes (changes in master must be applied to slaves) Also I need to use Docker for this. What do I do: I use Docker image from…
Roman Cherepanov
  • 1,639
  • 2
  • 24
  • 44
0
votes
0 answers

Percona native AIO fails to start

In my my.cnf, I currently have the following innodb-write-io-threads = 32 innodb-read-io-threads = 32 When I try to increase that to 48, native AIO fails to start up. 2016-08-22T05:02:35.933600Z 0 [Note] /usr/sbin/mysqld (mysqld…
Daniel Varnai
  • 1
  • 1
0
votes
2 answers

innodb table level lock

We face the table level lock issues, almost every day on our test servers. TRANSACTION 0, not started mysql tables in use 97, locked 97 MySQL thread id 429, OS thread handle 0x2aff6ff59700, query id 24900 ec2-*-*-*-*.compute-1.amazonaws.com *.*.*.*…
user160108
  • 930
  • 3
  • 8
  • 38
0
votes
1 answer

Percona XtraDB Cluster multi-node writing and unexpected deadlocks outside of transaction?

I am having trouble finding an answer to this using google or Stack Overflow, so perhaps people familiar with Percona XtraDB can help answer this. I fully understand how unexpected deadlocks can occur as outlined in this article, and the solution is…
Kendall Bennett
  • 2,353
  • 1
  • 17
  • 18
0
votes
1 answer

Percona XtraDB Cluster 5.6 does not start

All the good days. I want to run for test purposes Percona XtraDb Cluster on ubuntu 14.04. The basis here took these two articles https://habrahabr.ru/post/152969/ https://www.percona.com/doc/percona-xtradb-cluster/5.6/manual/bootstrap.html I came…
dlarchikov
  • 288
  • 2
  • 11
0
votes
2 answers

Bootstraping Percona Xtradb Cluster in Docker gives the error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

My goal is to get a Percona XtraDB Installation running in a Docker Container. For this i wrote up the following configuration. Dockerfile: FROM ubuntu:wily ENV DEBIAN_FRONTEND noninteractive # # ENVIRONMENT INSTALL # RUN apt-get update && apt-get…
Octavia Kitsune
  • 55
  • 6
0
votes
1 answer

MySQL query sometimes run slow, sometimes fast

I am having problem with this simple MySQL query: select sender as id from message where status=1 and recipient=1 where sender table has multi millions of rows. When I run this on SequelPro, it runs really slow for the first time, ~4 seconds or…
zangetsKid
  • 27
  • 3
  • 12
0
votes
1 answer

Is 3 nodes a recommended minimum for a Galera cluster?

I intend to run a Point of Sale software in a galera cluster (percona xtradb). Each POS terminal would be its own cluster and then there will be an Amazon EC2 in addition to help avoid split-brain scenarios. Is the above setup an ideal cluster…
user1615573
  • 315
  • 5
  • 18
0
votes
1 answer

Percona Xtradb cluster crashing

We have a Percona Xtradb cluster with 5 nodes and an arbitrator. One of our Php developers ran a bad query on the cluster, crashing all the nodes. After the crash, we could not collect any error log to tell us what really went wrong as the entire…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
0
votes
1 answer

Does XtraDB in MariaDB craate large files the way InnoDB does in MySQL?

I have been using MySQL but, as many people have painfully found out, the InnoDB engine is creating large and unshrinkable ibdata1 files. Activating innodb_file_per_table helps but does not solve the problem. I was thinking of moving to MariaDB and…
jdrew
  • 15
  • 4
0
votes
1 answer

percona cluster 2nd node not starting

When I start mysql service in ubuntu. error.log keep looping at following message. 150223 23:23:55 [Note] WSREP: Read nil XID from storage engines, skipping position init 150223 23:23:55 [Note] WSREP: wsrep_load(): loading provider library…
conandor
  • 3,637
  • 6
  • 29
  • 36
0
votes
1 answer

Percona XtraDB Cluster SST not working using rsync: wsrep_sst_rsync

I'm sure there is a simple fix for this, but forgive me I'm new at PXC. I'm using rsync to transfer state of the bootstrapping node to node2. node2 is the node I am joining to the cluster. I originally tried Xtrabackup, but ran into problems which I…
stampkick
  • 47
  • 2
  • 8
1 2
3
4