Percona : MySQL open source fork with performance improvements
2
votes
3answers
56 views
Find which mysql is running
I have installed mysql 5.5 and percona 5.5 in the same machine. I am not able to identify wheather the running db is mysql or percona. IS there is any way to identify the difference.
1
vote
1answer
47 views
Percona on 2nd node will not start
I have setup two Vagrant VMs to simulate Percona XtraDB Cluster for our development needs. The first VM comes online just fine, and everything works. However, when I try to start Percona on the 2nd VM ...
0
votes
0answers
19 views
How does pt-kill remove queries?
I am asking this question because I have a system that has problems when a connection is forcibly killed within mysql with the KILL CONNECTION [id]; syntax.* These closed connections may continue to ...
0
votes
1answer
54 views
MySQL to Percona page load time increase?
Page Time: 0.0915s
Memory: 5.0191 MB (Peak: 5.4852 MB)
Queries (10, time: 0.0037s, 4.1%)
After doing a change from MySQL to Percona my Page Time actually increased. Is that just because it lessens ...
1
vote
1answer
39 views
Percona xtradb cluster with asynch slaves
I have a Percona xtradb cluster set up with 3 nodes. Node 1 is also set up as a master with an asynchronous slave. When I make an update to Node 1, it is replicated to the cluster as well as the ...
0
votes
1answer
117 views
Percona-Cluster: backup and restore procedure
I'm trying to restore a full backup taken from one node of a three-node percona cluster (percona cluster 5.5, galera 2.1, wsrep sst method is rsync, innodb tables only).
Backup was taken like this:
...
0
votes
1answer
201 views
Trouble setting up a Percona XtraDB cluster on 2 servers
I'm trying to set up a Percona XtraDB cluster on two machines.. but i'm having a terrible time in getting the second machine up and running.
I have used this article as a reference, and while it ...
1
vote
4answers
116 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
269 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
90 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
77 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
0answers
286 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
96 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 ...
1
vote
0answers
21 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
525 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
71 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
279 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
1k 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
80 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
138 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
1k 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: ...
5
votes
5answers
3k 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
3answers
404 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
177 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
127 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
202 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
407 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
6k 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
1k 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
1k 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
2k 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
1answer
270 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). ...
