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.

156 questions
16
votes
2 answers

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 packages, not only the ones listed in the original…
user2643870
  • 283
  • 1
  • 3
  • 8
12
votes
5 answers

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 users, i.e.: You need nc on the server. Some versions…
HTTP500
  • 4,827
  • 4
  • 22
  • 31
11
votes
1 answer

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 to get better performance and new features. It…
Chrille
  • 463
  • 2
  • 5
  • 10
7
votes
3 answers

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 compare checksums on the two tables and do inserts,…
Anirudh
  • 223
  • 2
  • 3
  • 7
6
votes
1 answer

mysqldump: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled

When I try to run mysqldump on a Percona Server 5.7.17-12, I get this error: # mysqldump -u backups -pxxxx -h 127.0.0.1 --single-transaction --quick dbname mysqldump: [Warning] Using a password on the command line interface can be insecure. -- MySQL…
the_nuts
  • 412
  • 6
  • 18
6
votes
2 answers

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 Percona Cluster but my only concern currently is with…
6
votes
4 answers

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 can get into mysql. Just wanted to know if there is…
ks_1010
  • 121
  • 1
  • 2
  • 8
6
votes
2 answers

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 slave. Is there no way I can make connect an empty…
Prof. Falken
  • 292
  • 7
  • 16
5
votes
2 answers

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 [(none)]> show status like…
bwizzy
  • 1,265
  • 4
  • 14
  • 17
4
votes
3 answers

Entire proxmox Xen Node has grey question marks + database container gone

Firstly, i've recently taken on the management of a proxmox cluster which I have had no experience managing previously (i'm completely new to cluster management, but not too bad at linux). pve-manager/5.1-46/ae8241d4 (running kernel:…
David
  • 829
  • 3
  • 13
  • 30
4
votes
2 answers

centos yum remove mysql will remove core components

Centos 7 x64, mysql-community 5.7 is installed from mysql57-community repo. I am in the process of switching from mysql to percona. However, the first step is scary when I try to uninstall mysql. Yum is removing system components such as crontabs…
Reed
  • 287
  • 1
  • 3
  • 10
4
votes
1 answer

Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots

Basically what I'm looking for is a way to tell mysql (percona-flavored) to take the following steps: Flush all committed transactions to the filesystem Start buffering all transactions (keep the filesystem in a coherent state) Wait for me to do…
HonoredMule
  • 187
  • 11
4
votes
2 answers

99% disk IO spikes with Percona

So we have a server that has seemingly random spikes in disk I/O, going up to 99.x% at random times and for no obvious reason, staying high for a while, and then going back down. This didn't use to be an issue, but recently the disk I/O has been…
user284587
4
votes
2 answers

Can I run Percona xtrabackup on my desktop?

I have successfull running xtracbackup on the db server, but I really want to run the backup on the other machine (not the machine that have the MySQL running). I try to run the xtrabackup tool on my desktop given the host/port options but getting…
nvcnvn
  • 257
  • 1
  • 2
  • 7
4
votes
1 answer

Percona Xtrabackup incremental backup based on prepared full backup

I want to create an hourly backup of our MySQL database to a staging system using Percona XtraBackup. Is it possible to prepare the $BACKUPBASE and then use this prepared backupbase as base for the following incremental backup (using the…
PaulSmecker
  • 43
  • 1
  • 5
1
2 3
10 11