Questions tagged [xtradb]
The xtradb tag has no usage guidance.
13
questions
1
vote
0
answers
119
views
What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3
So we have been using Debian 9 with MariaDB 10.1. For faster backups (total DB size across three DBs is > 1TB) we have enabled innodb_track_changed_pages. However, that feature has gone away on ...
- 732
2
votes
1
answer
2k
views
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-...
- 121
2
votes
1
answer
567
views
Over 100% of stage done during DROP COLUMN
I'm running a DROP COLUMN on the primary key column (I know, it's terrible but I had to do it). There's a progress indicator:
Stage: 1 of 2 'copy to tmp table' 107% of stage done
I haven't been ...
- 155
1
vote
1
answer
498
views
Percona on EC2 ephemeral storage (part of XtraDB cluster)
We have a MySQL DB of roughly 100GB and want to move it into EC2.
EBS volumes seem fairly slow for running MySQL databases (even with provisioned IOPS) and although we could use RAID10 to improve this ...
- 11
2
votes
0
answers
686
views
Recurring locks and slowdowns on a Percona XtraDB Cluster
I have 5 dedicated servers (identical machines: 32 cores, 96GB of RAM, SSD drives in RAID and gigabit ethernet link) configured with Percona XtraDB Cluster.
There's a recurring problem causing a ...
4
votes
2
answers
3k
views
Migrating from MyISAM to XtraDB
Just a few questions that I just can't find anywhere about migrating to XtraDB.
My group has been using MyISAM dbs for production and was wondering how hard is it to migrate to Percona's XtraDB and ...
- 55
0
votes
1
answer
3k
views
MySQL too many connections during normal conditions (Percona, InnoDB)
We're getting too many connections errors in normal conditions, so I'm assuming it's a configuration issue. Four webservers, not using persistant connections partly because that triggers to the too ...
- 282
2
votes
3
answers
5k
views
Percona XtraDB Cluster node recovery
I have been reviewing XtraDB clustering and produced a P.o.C. environment on Openstack using 4 instances, which has fallen over during my resilience testing.
Per the pxc documentation: http://www....
- 2,063
6
votes
2
answers
4k
views
Way to avoid server downtime when creating Master - Slave relationship?
I am preparing for setting up a MySQL master-slave or master-master relationship. Right now I have a single MySQL production server, and of course I don't want a lot of downtime while I connect the ...
- 302
4
votes
4
answers
5k
views
How to migrate from regular MySQL to Percona Server in production?
I'm running MySQL 5.0 in production on CentOS. How do I migrate to Percona Server 5.1 safely?
The documentation of Percona Server doesn't include any information on migrating. Any help is greatly ...
- 3,130
1
vote
2
answers
269
views
What is the easiest way to get XtraDB for MySQL running on CentOS 5
I'm having a lot of issues with a dedicated MySQL server and it seems like upgrading to the XtraDB version of InnoDB will probably have a positive effect, but I'm hesitant to get involved with it ...
- 213
3
votes
1
answer
2k
views
What are the pros & cons of these MySQL engines for OLTP -- XtraDB, PBXT, or TokuDB?
I'm working on a social website with an approximate read/write split of 90/10. Trying to decide on a MySQL engine. The ones I'm interested in are:
XtraDB
PBXT
TokuDB
What are the pros and cons of ...
- 3,130
3
votes
3
answers
938
views
Is XtraDB stable enough for production? [closed]
Is anyone using XtraDB (a MySQL build) from Percona?
The features & benchmark data looks nice. I wondered if it's stable enough for production.
What is your experience?
- 3,130