Stack Overflow
Stack Overflow

Questions tagged [xtradb]

50 questions
26
votes
2 answers

xtradb vs innodb

I was asked to check Mariadb as Centos does not provider MySQL 5.5 for the moment. I have read that xtradb servers as a drop in for innodb. What are the advantages of using one or the other because if they were equal, they would not have been…
thedethfox
  • 1,651
  • 2
  • 20
  • 38
6
votes
1 answer

MySQL replication Tungsten vs. Galera

Which is better? In sum of these aspects: performance + scalability stability easy of use + config + maintain Thanks you!
tunggad
  • 285
  • 2
  • 13
5
votes
1 answer

is there a mutex around 'checking permissions' and 'open tables' code in mysql 5.1/xtradb 6?

question comes up from some behavior i'm seeing. we're using mysql 5.1.36, xtradb release 6 on an 8 core box. when dropping a database with a lot of tables, mysql takes a long time to check permissions for each table before dropping them. i…
Evan Pon
  • 1,496
  • 1
  • 13
  • 22
4
votes
3 answers

Percona Xtradbcluster: Error while getting data from donor node

I've a problem in joining new node to percona xtradbcluster. here is my log : I tested the test_sstuser working on honor without any problem . but in new nodes I get these errors : 2014-05-31 04:01:40 2391 [Warning] WSREP: Failed to prepare for…
a.fti
  • 39
  • 1
  • 6
3
votes
1 answer

Restoring database to new cluster

we are using Percona 5.7.16-10 server. I would like to expand current solution with XtraDB cluster. So meanwhile I created other machines and started cluster (running on 5.7.17-11-57 Percona XtraDB Cluster version) and I did some testing there…
Radim
  • 164
  • 1
  • 4
  • 18
3
votes
1 answer

How to use XtraDB and TokuDB in Percona?

After trying several times, I finally installed Percona on my Macbook using Homebrew and successfully connected to it via MySQL Workbench, but when I want to create XtraDB tables: Operation failed: There was an error while applying the SQL script to…
user5483434
  • 492
  • 7
  • 17
2
votes
1 answer

Is there a noticable difference between innodb and XtraDB?

Today on serverfault I read about XtraDB. I read that it was a fork of innoDB and was woundering how big are the differences? Would I notice the change or do you think its just wasted time if I would try it out?
Thomaschaaf
  • 17,847
  • 32
  • 94
  • 128
2
votes
2 answers

Why MariaDB 10.2 uses again InnoDB instead of Percona XtraDB?

MariaDB homepage says that they use Percona XtraDB until 10.1 and from 10.2 on they are going to use normal InnoDB again (https://mariadb.com/kb/en/mariadb/xtradb-and-innodb/). This does not seem reasonable to me, because XtraDB seems to be the…
Stefan
  • 157
  • 1
  • 7
2
votes
1 answer

Recover Percona Xtradb in container

I have Percona Xtradb Cluster running on container. I stopped the container and then started it. I have error: 2017-02-11T13:12:00.423566Z 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and…
Roman Cherepanov
  • 1,639
  • 2
  • 24
  • 44
2
votes
1 answer

How to set up Percona Xtradb cluster with Amazon AutoScaling?

I want to make a cluster of 3 Percona Xtradb+application servers in ec2 using AutoScaling groups, so that if some server fails for some reason, it can be shut down and ASG would then restart the server getting all the current data from the other 2…
Fluffy
  • 27,504
  • 41
  • 151
  • 234
2
votes
1 answer

MySQL / MariaDB InnoDB indexes stops working

I am experiencing weird behaviour from my MySQL/MariaDB InnoDB/XtraDB. Recently switched to MariaDB 5.5. The switch made the server overall more performent, but I still have this problem. One particular tables index seems to break every now and…
Erik Ellis
  • 61
  • 2
  • 7
1
vote
1 answer

Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon

I am using MySQL Percona XtraDB Cluster with 3 node and MySQL service in one node did not work because of disk full. after fix the issue we try to start MySQL on this node but the following error occur: (before this issue all node had been working…
Benyamin
  • 11
  • 1
  • 3
1
vote
0 answers

Can't drop or rename a table in MySQL

Working with MySQL 5.7 and after a power outage everything seems ok. Then I must rename a table. So, easy-peasy: RENAME TABLE MYTABLE TO MY_REAL_TABLE >Table MY_REAL_TABLE already exists. So I try to drop the mentioned table: DROP TABLE…
Forge
  • 1,587
  • 1
  • 15
  • 36
1
vote
1 answer

Percona murmur_hash, fnv_64 and fnv1a_64 functions

Can somebody help me understand the use and benefits of these three functions that Percona suggests right after installation? * Percona XtraDB Cluster is distributed with several useful UDF (User Defined Function) from Percona Toolkit. * Run the…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
1
vote
0 answers

Unable to locate package percona-clustercheck

When i try to remove percona-pxc from my Ubuntu 14.04 using the command: sudo apt-get update sudo apt-get remove -y percona* I get the following errors: E: Unable to locate package percona-clustercheck E: Unable to locate package…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
1
2 3 4