Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.

learn more… | top users | synonyms

1
vote
1answer
216 views

Integrity constraint violation in Percona XtraDB Cluster

We have a PHP application that uses AWS Load Balancer that connects to 3 Percona Servers. Before we used a single standard Percona Server and that never happened. The cluster starts throwing Primary ...
0
votes
1answer
45 views

Moved database (percona mysql) to larger disk, now everything is missing (though the files exist)

I dont know anything about databases or MySQL beyond the absolute basics so lets start with that. I moved the /var/lib/mysql from the / to a mounted volume which I remounted as /var/lib/mysql after ...
0
votes
1answer
22 views

Automatic slave reconfiguration after updating master

I have development mysql master and slave servers and a prod server. I need to set up regular (once a week) syncronization of dev and prod databases. It would be easy for me to use prod# mysqldump > ...
0
votes
1answer
878 views

slow writes on percona / mariadb server only when replication is running

Hi I am trying to migrate to percona server from mysql 5.6 on windows. In my development machine for percona is running of centos 6.5 which is installed on vmware 5.5 sphere. Our business ...
0
votes
1answer
420 views

Strange Locking issues while playing back logs via percona playback

Problem while replaying logs I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior: As described here i: Created a dump (innobackupex ftw) ...
0
votes
0answers
11 views

Insert in PXC Cluster are not equally distributed

I have another query with regards to pxc cluster i have 4 nodes in pxc cluster all nodes have the same cnf file and one server as haproxy. Config File Detail [mysqld] datadir=/var/lib/mysql ...
0
votes
0answers
35 views

Percona Cluster 5.6 (PXC) and replication filters

I wanted to double confirm the following information: Percona Cluster 5.6 implements Galera for syncromnous replicatrion. Does Galera replication support any replication filtering rules? such as: ...
0
votes
0answers
27 views

Percona and MariaDB-10.0 ignoring not null on table fields

On the percona-5.6 and MariaDB-10.0 servers, the NOT NULL declared on table field are being ignored. I am able to leave fields declared as NOT NULL empty when inserting data and the servers are not ...
0
votes
0answers
48 views

Very slow IO on mysql percona server

Our site goes down because the IO on our database servers is too slow. Troubleshooting this we found that mysql is really really slow. It's constantly reading from disk and I think not using enough ...
0
votes
0answers
37 views

Never ending count(*) on a table after upgrading to Percona 5.6.16

I had a 5.5 instance I was upgrading to 5.6.16. That went seemingly with out issue, take a mysqldump from the 5.5 version and source into the 5.6.16. It starts up with out error in the error log. ...