Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Percona is a company that features their compilation of MySQL with emphasis on performance. That MySQL software is best known as Percona Server. They have downloads for MySQL 5.5, 5.1, 5.0, and MariaDB.

162 questions
1
vote
1 answer

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 Percona data with a second data center so that we…
user209180
  • 87
  • 1
  • 2
  • 6
1
vote
4 answers

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 physical server as well as my mysql server to a percona…
Trent
  • 133
  • 1
  • 3
1
vote
1 answer

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 (or Amazon RDS) I was really hoping to make use…
cates
  • 11
  • 1
1
vote
1 answer

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 try to yum install that dependency, it tells me…
Martin
  • 177
  • 2
  • 10
1
vote
2 answers

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 automatically started. If I run "/etc/init.d/mysql…
Inukshuk
  • 165
  • 1
  • 2
  • 10
1
vote
1 answer

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 we get errors when requesting state…
user169871
1
vote
1 answer

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 slave. However, when I make an update to Node 2 or…
Francis Snipe
  • 165
  • 5
1
vote
2 answers

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. Is someone able to help me find where the logs…
GoldieNZ
  • 25
  • 1
  • 4
1
vote
2 answers

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: rm -rf /tmp/backup/mysqldb innobackupex…
Hank
  • 379
  • 3
  • 15
1
vote
1 answer

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 seems to be almost working, there's probably something…
GoldieNZ
  • 25
  • 1
  • 4
1
vote
4 answers

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…
shantanuo
  • 3,579
  • 8
  • 49
  • 66
1
vote
2 answers

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. Both the Percona servers and the HAproxy servers…
rottmanj
  • 213
  • 1
  • 3
  • 6
1
vote
1 answer

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 phpinfo() I notice that under the MySQL and mysqli…
William Jamieson
  • 13
  • 3
1
vote
1 answer

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 conflicting slave values as well? I want to see if I can…
SecondThought
  • 409
  • 1
  • 4
  • 11
1
vote
0 answers

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 combined with the following code in my theme…
KodeFor.Me
  • 209
  • 3
  • 5
  • 14
1 2 3
…
10 11