Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

1
vote
2answers
306 views

Percona 5.6 not starting automatically after server reboot on Ubuntu with Virtualmin

I've got a new install of Ubuntu 12.04 + Virtualmin. I've upgraded from the default mysql 5.5 to Percona 5.6. Everything works except for one problem: when the server reboots, Percona is not ...
1
vote
0answers
179 views

How to compile MySQL (Percona) with jemalloc installed under custom prefix?

My jemalloc is installed under /opt/jemalloc, how to compile MySQL/Percona with the support of jemalloc? The standard option is cmake . -DCMAKE_EXE_LINKER_FLAGS='-ljemalloc' -DWITH_SAFEMALLOC=OFF ...
0
votes
1answer
41 views

Dev mysql node with Percona

I have been tasked with creating a Development mysql instance, We currently have a 7 node Xtradb cluster, is there any way to have this node a few hours behind, or not allow replication back to the ...
2
votes
1answer
482 views

Percona: Got an error writing communication packets

Since a few days, two of our php-applications (symfony2) are reporting the following errors in mysql-logs: [Warning] Aborted connection 253 to db: '$appname' user: '$appname' host: 'localhost' (Got ...
0
votes
1answer
303 views

mysqld: unrecognized service after installing Percona mySQL

Fresh cloud server running Centos6. Trying to install latest Percona $ sudo rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm $ sudo yum install ...
3
votes
1answer
2k views

MariaDB / MySQL galera cluster nodes won't join

I'm setting up a MariaDB Galera cluster and I can’t seem to get the nodes to join each other. They both start up without errors but never seem to join, the status is always disconnected: MariaDB ...
6
votes
2answers
4k views

MariaDB Cluster vs Percona Cluster for MySQL

What are the advantages and and disadvantages between the two? I've only been able to find information on these two implementations without any specifics on clusters. I'm currently implementing a ...
0
votes
1answer
924 views

PHP fails to load MySQL modules - “libmysqlclient.so.18” error

I'm installing a new CentOS 6.4 box, to move my websites over from my current 5.9 box. I've ended up with Apache 2.2.4, PHP 5.4.16 (via "powerstack" repo), and Percona 5.6.13 (via percona's own ...
-1
votes
1answer
449 views

installing Percona XtraDB Cluster on Ubuntu 13.04

So, a bit of explanation of the big picture: I am trying to get multiple PXC instances running on a single machine, replicating via Galera to each other. I am running Ubuntu Server 13.04 amd64 in a ...
2
votes
0answers
420 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 ...
-3
votes
1answer
459 views

syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('

I have many messages like the following in /var/log/mysqld.log What does it mean? ...
0
votes
0answers
2k views

/usr/lib/libmysqlclient.so.18: no version information available (required by /usr/bin/searchd)

Recently I have a problem with sphinxsearch and mysql: Restarting sphinxsearch: /usr/bin/searchd: /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/bin/searchd) ...
-1
votes
1answer
227 views

Backup/Recovery like barman for MySQL [closed]

I'd like to have a Backup/Recovery tool for MySQL (MariaDB/Percona) servers which has somehow the same features as barman has for postgresql take full backups on a regular basis (xtrabackup, but ...
2
votes
1answer
254 views

Percona and MySQL audit

I am trying to audit MySQL commands for users on Percona. Current version of Percona is 55-5.5.22-rel25.2.237.rhel5. The following URL gives guidance, however I do not know how to get it working. ...
0
votes
1answer
315 views

MySQL high memory consumption with poor performance for queries, which settings to tweak?

I have a scenario with a rather large database. It is about 3GB and I'm hitting some walls with system resources. For example, here is an example of htop output: You can observe that there are a ...
0
votes
2answers
5k views

Percona MySQL unable to start - ERROR! The server quit without updating PID file

BACKGROUND: I installed Percona Server on a fresh Centos 6.4 minimal. Prior to this, I have never installed MySQL (though I'm not sure if Centos 6.4 minimal came with MySQL?) Anyway, here are the ...
2
votes
3answers
126 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
692 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
1answer
70 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
109 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 ...
1
vote
2answers
95 views

How do I see which queries are running slow

I'm running Ubuntu 12.04.2 LTS (GNU/Linux 3.2.0-24-virtual x86_64) and Percona's mysql server. I know im getting slow queries, but im not sure where I find what they are so I can try to remedy them. ...
0
votes
2answers
1k 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: ...
1
vote
1answer
2k 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
420 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
434 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
177 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
2answers
1k 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. ...
6
votes
4answers
3k views

Percona-server time out on /etc/init.d/mysql start

Every time I start mysql, using /etc/init.d/mysql start or service mysql start, it always times out. * Starting MySQL (Percona Server) database server mysqld [fail] However, I ...
0
votes
1answer
586 views

Fresh 12.04 Install - mySQL not starting

I have a freshly installed Ubuntu 12.04 x64 server and I installed Percona server from their official repositories. Trouble is it will not start! mysql-error.log shows nothing obvious. 121129 ...
2
votes
2answers
4k views

What can I really do with percona toolkit's pt-table-sync?

I have been looking for a tool to synchronize tables from 2 different databases and found pt-table-sync. I read the documentation and got confused: they mostly use examples referring to a replicated ...
1
vote
1answer
364 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
761 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
95 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
1k 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 ...
0
votes
2answers
339 views

Shorter alias for domain name

I need to create a shorter name for my Mysql database endpoint to be accessed from linux box. Clearly said, my mysql end point is rdsbench.c2wfqsdsqd.us-east-1.rds.amazonaws.com and I would like to ...
1
vote
1answer
68 views

Find mysql replications diffs patterns

I'm using pt-table-checksum and pt-table-sync to check for differences in my replicas. when I use pt-table-sync with the -print option, I can only see the master values. How can I show the ...
1
vote
0answers
107 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
246 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: ...
7
votes
5answers
14k 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
1k 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 ...
9
votes
1answer
8k views

MariaDB vs Percona server - main differences?

I'm running Mysql in production today but are planning to switch to either MariaDB or Percona server when I move to new servers. The main reason for the switch is to distance us from Oracle, but also ...
1
vote
1answer
315 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
184 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
300 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
585 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
15k 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 ...