Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

1
vote
4answers
345 views

quick rpm install

I am trying to install percona server. This is a test machine and installed packages do not really matter. What all I need to do is install percona mysql server. ...
0
votes
1answer
1k views

Percona server won't restar after datadir change

I installed percona from percona repository on a ubuntu 12.04 server which has a solid state drive. I thought i would rather put the datadir on the Solid state drive and put partition on normal sata ...
-2
votes
1answer
331 views

installing percona mysql on centos [closed]

From where will I get the mysqldump file from /usr/bin of percona mysql server (32 bit centos 5)? Is it available on the web without installing the software? In other words I am collecting all ...
0
votes
0answers
153 views

Import large InnoDB table dump

i've a mysqldump ( 1.5G large ) of a table I need to import. The server i bought, which is clean and not under load, takes > 2hours to import it. I read many tweaks i can use to speed up the import ...
0
votes
1answer
901 views

HAProxy + Percona XtraDB Cluster

I am attempting to setup HAproxy in conjunction with Percona XtraDB Cluster on a series of 3 EC2 instances. I have found a few tutorials online dealing with this specific issue, but I am a bit stuck. ...
1
vote
1answer
279 views

Does the mysql Client API Library version have to match the installed MySQL/Percona server version?

I'm running Scientific Linux 6.3 (binary compaible with Redhat/CentOS/etc..) as a LAMP stack. I've installed Percona server and client v5.5 from the Percona yum repository. However when I run ...
2
votes
0answers
25 views

Percona backup to different database name [duplicate]

Possible Duplicate: MySQL: How to backup and restore using different schema name using xtrabackup I'm using percona backup tool Xtrabackup for backing up different MySQL server, right now I ...
2
votes
1answer
708 views

How to install Percona XtraDB Cluster on x86 server?

I'm going to migrate from MySQL replication to Percona XtraDB Cluster. The problem I'm facing is one node is running on x86, and I cannot install Percona-XtraDB-Cluster-server from the Percona repo ...
0
votes
1answer
92 views

Which repo and version of Percona for Natty?

I'm wanting to drop in Percona instead of MySQL (5.1) on my Natty ubuntu server. I've added the keys and the repos. I've added a natty repo, even though it's not supposed to exist and it seems to be ...
0
votes
1answer
840 views

MySQL slow query log logging all queries

We have a MySQL 5.1.52 Percona Server 11.6 instance that suddenly started logging every single query to the slow query log. The long_query_time configuration is set to 1, yet, suddenly we're seeing ...
0
votes
1answer
2k 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 ...
1
vote
0answers
101 views

Really slow execution

I own a wordpress installation, and Updated to 3.4.1. After the upgrade, I got a very strange slowdown to my wordpress. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
1
vote
2answers
228 views

Installed Percona mySQL on CPanel but getting an error

I installed Percona mySQL on my fresh CPanel server (no databases yet) according to: http://www.ecommy.com/linux/install-...el-environment Everything seemed to be OK and the server also starts fine, ...
2
votes
3answers
2k 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: ...
6
votes
5answers
10k views

Netcat (nc) traditional package for RHEL 6.x?

I'm trying to use the Percona Apache Monitoring [Cacti] Template for Memcached. They do indeed warn that you can't use the openbsd version of the package and provide a solution for Ubuntu/Debian ...
0
votes
4answers
971 views

Percona-xtrabackup hot backup issue with MyIsam Engine

We are running with the MyIsam Engine and Percona-xtrabackup is throwing the following error as the inndb engine is skipped [ my.cnf skip-innodb]. How could I resolve this issue with out enabling the ...
1
vote
1answer
271 views

Issue with percona-xtrabackup-2.0.0 hotbackup on MyIsam tables

I am trying to implement hot backup for MyIsam tables with "percona-xtrabackup-2.0.0" and getting the following error? As the all tables are MyIsam I doubt am I using the correct package ? Backup ...
1
vote
1answer
173 views

Is it safe to use MySQL 5.1 clients with Percona server 5.5?

For a number of our websites we are using Ubuntu LTS 10.04 with MySQL 5.1. We are looking into consolidating the SQL databases onto a single server and have been testing Percona 5.5 for this purpose. ...
1
vote
1answer
283 views

Percona XtraDB Cluster with GlusterFS

We are deploying a GlusterFS cluster with 4 nodes, and we want to deploy the Percona XtraDB Cluster on top of it with 4 nodes, each node will have a mounted folder from the GlusterFS, each mount will ...
1
vote
1answer
555 views

Error updating Percona Server

I'm getting errors doing a regular aptitude safe-upgrade of percona-server-server-5.5, I'm already running a version of percona server 5.5 Setting up libmysqlclient18 (5.5.20-rel24.1-217.squeeze) ...
3
votes
2answers
12k views

How to sync two MySQL tables (on demand or via cron)

I have seen Cron sync mysql tables . But I cannot use replication. I used to use percona-toolkit and it worked perfectly. I could run the sync command on demand or just run it via cron. It would ...
1
vote
2answers
2k views

CentOS - Percona MySQL - Not Reading /etc/my.cnf

I've compiled Percona 5.5 on my CentOS 6.1 server and it starts fine, however it doesn't appear to be reading my /etc/my.cnf file. # In /etc/my.cnf character_set_server = utf8 collation_server = ...
3
votes
1answer
2k views

How to upgrade percona mysql on debian squeeze

Was running an apt upgrade and The following packages have been kept back: libmysqlclient18 percona-server-client-5.5 percona-server-server-5.5 I'm currently running percona mysql 5.5.15-55-log ...
5
votes
2answers
3k 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 ...
1
vote
0answers
416 views

MySQL Enterprise Backup GUI (or a live backup alternative)

I am looking into MySQL Enterprise backup solution. I am interested in a non-blocking mysql backup (live and incremental). MySQL Enterprise provides this solution (we have the subscription already). ...