Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

0
votes
1answer
14 views

MySQL backups/Replication using xtrabackup and Native Mysql Replication

This aspect of using Percona Xtrabackup over Native Replication has been in my head for sometime now and I just cant seem to find an answer to this, I am posting this as a last resort seeking advice ...
0
votes
1answer
16 views

Percona Server & MySQL server on the same server on different ports

I have MySQL installed from ports, running and listening on port 3306. On the same server I have Percona Server compiled from sources, running and listening on port 3307. Here are the process list ...
1
vote
2answers
104 views

Automatic MySQL shutdown is RHEL7

When I execute systemctl start mysql it starts MySQL but I don't get command prompt back, it just stays like that. Database starts normally. After couple of minutes database automatically shutdowns ...
0
votes
0answers
21 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
0
votes
1answer
59 views

New nagios/cacti monitoring setup, should I use a dedicated VM?

Currently we have 4 bare metal servers and one small VM server (all running centos6) and I'm looking at setting up monitoring for the Percona MySQL db server and replication slave (bare metal), as ...
0
votes
1answer
94 views

Percona slave crashes with “unexpected PLT reloc type”

I have 2 data centers each with a master/slave database running Percona server 5.5.23. For some reason, one of the slave databases crashed with this error: 03:00:40 UTC - mysqld got signal 11 ; ...
0
votes
0answers
32 views

WSREP galera cluster warning conflict state 7

I have started to use a pxc cluster, after a flow control deadlock I had to kill all but one instance. And now on this single instance I have the below warnings streaming in the log all the time: ...
0
votes
1answer
126 views

Percona startup fails: mysql can't access directory for file creation

I found a few questions and suggestions for similiar problem, unfortunately nothing seems to work for me, so please excuse me if this is double (and point to right source)... Server is Fedora Beefy ...
0
votes
0answers
47 views

Percona MySQL LDAP authentication fails through .NET MySQL connector

Basically, MySQL uses its native authentication, where usernames and passwords are stored in mysql.user table. MySQL authenticates user against the credentials stored in mysql.user table. Our ...
0
votes
0answers
35 views

remote connect to percona is slow

SOLVED This is the age old mysql issue of skip-name-resolve. Works like a charm. Must have been in my old my.cnf and I forgot about it. I had a fairly large MySql Database and figured I would ...
0
votes
0answers
48 views

Mixing percona and mariadb in a galera cluster

Assuming both percona and mariadb runs the same engine (innoDB), can i use them interchangeably in a galera cluster? If it is possible, is there anything I should know before doing it?
2
votes
2answers
2k views

can't install mysql-devel on centos 6.5

I need mysql-devel package to be installed on my CentOS 6.5 running Percona 5.5 (already installed & running). When I try to install the devel package like this: yum --enablerepo=remi install ...
1
vote
0answers
52 views

PHP-FPM slowlog and Mysql lost connection

I was having an issue with PHP-FPM and mysql. When I needed to process an input file that would generate several selects/inserts/updates for each line, it would stop after approximately 60s with ...
0
votes
0answers
198 views

my.cnf doesn't work in my server

now i am using percona server 5.6 on CentOS 6.5. I wanna change query cache setting. I tried to change setting /etc/my.cnf. but it didn't applied. To investigate whether my.cnf is read correctly,all ...
0
votes
1answer
350 views

How can I resolve libmysql with Percona now that they've caused a yum conflict with their packages?

A script I wrote a few months ago has provisioned probably 100 or more virtual servers with a LAPP stack (Linux Apache Percona PHP). Recently, the following line is failing because yum has ...
1
vote
0answers
57 views

MySQL SSL Problems

I need to configure SSL for a MySQL server. I've read all of the directions for doing self-signed certs but it's preferred that I sign and use the certs from a different CA running AD Certificate ...
0
votes
1answer
74 views

Percona UDF - FUNCTION MURMUR_HASH does not exist

We have a 5.5.28-29.3-log mysql master that has the percona UDFs installed including murmur_hash. We installed mysql on new host but I can't seem to find where to get the UDFs from. This doc suggests ...
1
vote
0answers
68 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
1
vote
1answer
313 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
1
vote
1answer
779 views

MySQL Socket configuration issue in my.cnf

I've got an issue that's causing very long "time in database" in my application. The DB is Percona MySQL 5.5.35. The application works perfectly, and can read/write from the database just fine. The ...
0
votes
1answer
117 views

Cannot open './/ib_buffer_pool' for reading: No such file or directory

I've realised that my Percona DB which has several InnoDB tables doesn't actually have InnoDB buffer pool running as it wasn't specified in the my.cnf. I had a buffer pool size specified of 256MB, ...
0
votes
3answers
107 views

What could cause these (see graph) spikes in DB response times?

I've a LAMP stack running Percona MySQL. Via New Relic, I'm monitoring/tweaking/tuning my new server ready for it to be used live. Something that's irritating me though, is that I get periodic ...
0
votes
0answers
117 views

Force execution of a chef script before the first one finishes

Following is section of code that is creating the problem for me. Everything works fine but then in order to upgrade percona, I need to run the 'mysql_upgrade' step while the 'mysql_safe' step is ...
1
vote
4answers
528 views

Heavy production MySQL/Percona Database in openvz container

So I'm currently running a MySQL 5.1 database, with the following specs: Proc: Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz RAM: 64 Go disks: 2x 100 Go SSD (RaidSoft) I'm planning to migrate my ...
0
votes
0answers
21 views

Percona adding node to cluster safe?

I had a cluster with 3 nodes and 2 of them died, leaving only node 1 working, and this is a production environment that cannot stop. Is it safe to re-add one node to the cluster? Thank you
0
votes
1answer
169 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 ...
1
vote
0answers
77 views

mysql - measure amount of write

System : Centos 6.4, PerconaDb/MySQL 5.5.31 Im running relatively small mysql database with some 30 databases, total amount of 12Gb, but heavy on reads, updates and writes (texts, posts, user data ...
1
vote
1answer
695 views

installing XtraBackup with libmysqlclient.so.18

Current situation I'd like to install XtraBackup on my VPS (Centos 5) where my main database is running. During the rpm install it told me that it misses a dependency called perl(DBD::mysql). When I ...
0
votes
2answers
1k views

new Percona XtraDB nodes unable to join cluster

I have a four node Percona XtraDB cluster. Each night, one node shuts down for a backup and subsequently rejoins the cluster. This has run fine for quite some time now. Last night, the backup node ...
8
votes
2answers
5k views

Installing a third party application package on CentOS 6.4 fails due to missing dependencies libcrypto.so.10 and libssl.so.10

This is a Canonical Question about OpenSSL binary compatibility issues between Red Hat Enterprise Linux (and its derivatives) 6.4 and 6.5. This issue applies to a wide variety of third party ...
3
votes
1answer
426 views

MySQL memory usage - Periodically need to run FLUSH TABLES or memory usage keeps growing with large-pages turned on

After switching our rather memory + physical core rich database server to large-pages, we have noticed a small issue. The memory usage almost looks like there is some sort of memory leak. But ...
1
vote
2answers
231 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
139 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
40 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
325 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
282 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 ...
2
votes
1answer
1k 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
3k 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
746 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
210 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
330 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
299 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? ...
-1
votes
1answer
158 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
198 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
258 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 ...
2
votes
3answers
99 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
389 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
68 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
94 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
777 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: ...