Percona : MySQL open source fork with performance improvements
1
vote
1answer
10 views
Percona xtrabackup Prepare Fails
I made a backup and according to Percona it completed successfully. Now I'm trying to prepare it and having the following issue:
./xtrabackup_55 --defaults-file="/etc/my.cnf" ...
2
votes
1answer
22 views
Percona Node fails to join: Operation not permitted
Joining a new Percona node fails with:
130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group ...
0
votes
0answers
17 views
Percona Xtradb cluster only replicating DDL statements
I'm having a hard time with percona xtradb cluster. The cluster has 3 nodes, and is up and running (all tip top according to wsrep status indicators).
It did the SST perfectly fine from one node to ...
1
vote
1answer
24 views
xtrabackup backup grants?
I'm using MySQL 5.5 + Opensuse 12.3 .
After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution.
I found the xtrabackup from ...
0
votes
0answers
18 views
Can i use XAMMP mysql server with Percona Xtradb cluster?
I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster.
Can I just change the my.cnf config file on XAMPP with the ...
0
votes
0answers
26 views
Many databases - Which MySQL Clustering to use? [closed]
Our intention is not to host one big database but to host many small databases (~30k databases).
MySQL Cluster 7.3/7.2
By default auto sharding based on primary key of table.
Reference : ...
1
vote
1answer
39 views
Archive partition before delete it?
I have manage to create an event and with the following scripts could both create and delete the partition. The issue now I need help on how to save the partition before its deleted? Should I use ...
1
vote
2answers
143 views
Ubuntu / MySQL / Percona XtraBackup gives error “sh: 1: xtrabackup_55: not found”
Hello I installed Ubuntu 12.04.2 LTS on a fresh box.
This installed MySQL 5.5.29.
I installed percona-xtrabackup-2.0.6-521.tar.gz, and moved the executables to /usr/bin/
But innobackupex is ...
0
votes
1answer
113 views
Is using the alpha version of Percona 5.6 safe? [closed]
I'm really sorry if my question is kind of very basic, but is something that is really making me thinking a lot about it for a long time. As Percona has a lot of lines of optimizing codes, I run it ...
2
votes
1answer
405 views
query_cache_type = 0 vs query_cache_type = 1
Recently, I moved from standard MySQL to Percona, and used the Percona Wizard to generate my.cnf.
However, I can see that, by default, the generated settings for my.cnf use query_cache_type = 0. ...
1
vote
0answers
49 views
pt-table-checksum generates no output
I've been using pt-table-checksum on our staging server successfully, but when I run
./pt-table-checksum h=localhost,u=user --ask-pass --lock-wait-time=50 --databases prod
It just sits there. No ...
1
vote
1answer
287 views
Should a MySQL replication slave be set to read only?
I've got replication running on Percona Server 5.5 by following this guide and wondered if I should add read-only=1 to my slave's my.cnf to make it read only?
The guide sets up replication for the ...
3
votes
1answer
83 views
Backup and off-site restore setup
I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one.
Our current situation is ~100 GB of InnoDB and MySAM data in ...
1
vote
1answer
494 views
Why default character_set_server is latin1?
I am using MySQL 5.5 and when I show variables about charset, I have
+--------------------------+----------------------------+
| Variable_name | Value |
...
2
votes
1answer
97 views
innobackupex is failing while exporting backup
I am using perl script which is working fine in one of my other box which used to take individual schema backups & finally take all schema together using percona innobackupex.
I have following ...
2
votes
1answer
140 views
Does this make my XtraDB Cluster hang?
After seeing the following in the error log on the second node:
121003 7:16:06 [Note] WSREP: Member 0 (joiner) synced with group.
121003 7:16:06 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
...
2
votes
1answer
180 views
Percona XtraDB Cluster: How to skip SST when starting?
Is there a way to skip State Snapshot Transfer (SST) at startup on Percona XtraDB Cluster Server?
wsrep_sst_mode=skip doesn't work:
121003 6:49:55 Percona XtraDB (http://www.percona.com) ...
3
votes
0answers
204 views
XtraDB Cluster Error : “IST first seqno 7 not found from cache, falling back to SST” in replication
I have a problem with MySQL clustering. My systems consist of:
xtrabackup: version 2.0.2
MySQL: version 5.5.27
Distro: CentOS 5.7 64-bit
my.cnf on the donor:
[mysqld]
binlog_format=ROW
...
3
votes
3answers
193 views
Is it possible to pass parameters to pt-table-checksum using an options file?
We're using Percona's pt-table-checksum for MySQL replication integrity check.
Is it possible to pass some or all of the options using some sort of configuration file?
For instance, can we write the ...
2
votes
1answer
189 views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
4
votes
2answers
1k views
Scaling Percona datacenters: setup and replication
Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you.
We have already scaled alot of our application stack: we offloaded ...
2
votes
1answer
162 views
Why are my queries getting really slow?
I own a WordPress installation, and Updated to 3.4.1.
After the upgrade, I experienced a very strange slow-down.
After all, I used the
define('SAVEQUERIES', true);
in my wp-config.php with ...
0
votes
1answer
275 views
percona mysql crashing at innodb initialization
i have a slave percona db setup that also maintains few of it's own tables
it started crashing with this in error.log:
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: ...
3
votes
1answer
427 views
MySQL Handler_read_rnd_next == tablescans without indexes?
I am in the process of tuning our Percona 5.5 server, and have been using percona's tools to plot our database's performance.
In the MySQL Handlers Plot, i have been noticing alot of ...
6
votes
2answers
402 views
Investigate peak in MySQL throughput
Recently one of our servers has ran out of memory and crashed. After reviewing the munin graphs, it appears that the only metric (other than memory usage) that peaked just before the crash was the ...
3
votes
2answers
2k views
Percona vs MySQL
What is Percona?
How does it differ from MySQL?
When should we consider switching (or upgrading) from stock MySQL to Percona?
To add some specifics in our situation we almost exclusively use ...
0
votes
1answer
533 views
Problem with Error: InnoDB: page … log sequence … number is in the future!
i know this question was asked before, but i am at a point where i am really stuck and do not know how to continue with this problem and i would really like to know, what causes this error to come up.
...
1
vote
1answer
140 views
xtrabackup “failed to read metadata” [closed]
Doing a staging run setting up a new xtrabackup restore script I'm running into a somewhat cryptic error I can't readily google a solution for.
I'm working with an incremental backup design. During ...
3
votes
1answer
3k views
Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working
I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands:
$ pt-table-checksum h=master,u=user,p=password ...
2
votes
2answers
291 views
What is an “empty query” in information_schema.CLIENT_STATISTICS?
The client stats table has an "empty queries" column. What does that mean? Simple googling just tells me "The number of times this client's connections sent empty queries to the server." /facepalm
12
votes
2answers
3k views
How do I properly perform a MySQL bake-off?
I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better ...
4
votes
1answer
994 views
What is the difference between XtraBackup and rsync?
Yes, I'm going to run strace on them both... However, I would like to know ...
What is XtraBackup is doing over and above rsync -ac src dest ?
What's so special about XtraBbackup ?
How is XtraBackup ...
