Stack Overflow
Stack Overflow

Questions tagged [percona]

Percona builds free and open source database software that includes: Percona Server for MySQL®, Percona Server for MongoDB, Percona XtraDB Cluster, Percona XtraBackup, Percona Monitoring and Management, and Percona Toolkit. The widely installed Percona Server for MySQL is a drop in replacement for MySQL, and includes XtraDB, an enhanced version of the InnoDB storage engine.

Percona builds free and open source database software that includes:

  • Percona Server for MySQL® a free, fully compatible, enhanced, open source drop-in replacement for MySQL which includes XtraDB, an enhanced version of the InnoDB storage engine.
  • Percona XtraDB Cluster an active/active high availability and high scalability open source solution for MySQL ® clustering.
  • Percona XtraBackup a free, open source, complete online backup solution for all versions of Percona Server for MySQL, MySQL ® and MariaDB®.
  • Percona Monitoring and Management a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance.
  • Percona Toolkit a collection of advanced open source command-line tools that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually.
  • Percona Server for MongoDB a free, enhanced, fully compatible, open source, drop-in replacement for the MongoDB® Community Server that includes enterprise-grade features and functionality
647 questions
4
votes
1 answer

pt-query-digest filtering by database and user and datetime

I have a very large slow query log (~220GB), using pt-query-digest, how do I filter an event/query by: database or databases AND datetime range (I only have access to the timestamp here) AND database user I understand a slow query of this size…
stampkick
  • 47
  • 2
  • 8
4
votes
2 answers

Remove block-comments from a file with a bash script

There is a way to remove from a file all rows wrapped between /* and */ using a bash script? I use percona to generate a sql script to syncronize two databases, a development one to a production one. Percona generates a well formatted SQL script but…
Marco Piccinni
  • 67
  • 1
  • 6
4
votes
2 answers

Dependencies for chef_gem

I am currently updating the community MySQL cookbook so that it can be used to install Percona, which is a drop in replacement for stock MySQL but has some added functionality to easily enable HA and clustering. All my additions have worked well…
Russell Seymour
  • 1,333
  • 1
  • 16
  • 35
3
votes
1 answer

Difference between Percona XtraDB Cluster and MySQL Cluster

How does the newly released Percona XtraDB Cluster compare with MySQL Cluster? http://www.mysqlperformanceblog.com/2012/01/09/announcement-of-percona-xtradb-cluster-alpha-release/
archmeta
  • 1,107
  • 4
  • 17
  • 29
3
votes
1 answer

percona nosql vs other nosql

I am evaluating nosql stores for storing key/value pairs (for a part of application), and came across percona which offers native key/value within mysql world. It seems a good solution as it allows the storage to remain at a single place (since rest…
142857
  • 435
  • 3
  • 14
3
votes
0 answers

Can we can configure grpc_pass and proxy_pass on single nginx conf for the same location(/)?

I am trying to configure Percona PMM along with my proxy servers so that my client servers can securely connect to PMM server. Attaching the current setup here. Also providing the nginx conf I am using now. server { listen 443 ssl…
maktoob
  • 31
  • 1
3
votes
1 answer

Totally bizzare: deleting a MySQL user allows me to still login as that user with an empty password

Using MySQL 5.5 on Arch Linux, when I create a localhost user with a password and give it all privileges to all tables and then delete that user, I can still login as that user without typing in a password. Steps to reproduce: # mysql -u root -h…
OCDev
  • 2,280
  • 3
  • 26
  • 37
3
votes
0 answers

Anyway to use Percona's keyring_vault.so with MySQL Community Edition

Percona Distro of MySQL has a plugin keyring_vault.so that enables InnoDB's encryption to stay on Hashi Vault and can be rotated periodically writing the new encryption key to the Vault. MySQL Enterprise has HashiCorp Keyring plug-in which comes…
FairDinkum82
  • 167
  • 2
  • 11
3
votes
1 answer

xtrabackup restore a single database?

Percona XtraBackup gets a lot of praise, from what I can see, but I find it incredibly frustrating. I'm using: root@GR-00258:~# xtrabackup --version xtrabackup version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4) I…
j4nd3r53n
  • 680
  • 2
  • 11
  • 26
3
votes
1 answer

Which version of percona db package should i install in ubuntu Natty Narwhal?

I am new to both percona & Ubuntu. According to this page percona is only available for * etch * hardy * lenny * lucid * maverick * squeeze But i am using 11.04 (Natty). Can someone recommend me which version should i choose?
RameshVel
  • 64,778
  • 30
  • 169
  • 213
3
votes
2 answers

Why MySQL optimizer doesn't use all columns index?

Percona MySQL 5.7 table scheeme: CREATE TABLE Developer.Rate ( ID bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, TIME datetime NOT NULL, BASE varchar(3) NOT NULL, QUOTE varchar(3) NOT NULL, BID double NOT NULL, ASK double NOT NULL, …
mr_blond
  • 1,586
  • 2
  • 20
  • 52
3
votes
1 answer

Percona replication not sync

we use percona cluster 5.7.20 my wsrep configuration. max_connections = 10000 open_files_limit =…
ureyni
  • 71
  • 6
3
votes
0 answers

PDO does not throw an Exception for MAX_STATEMENT_TIME

We are running Percona Server 5.6.36-82.1-log and PHP 7.0.19. The database is setup using max_statement_time to automatically timeout queries after 10 seconds. And when running (very) slow queries in PHPMyAdmin they timeout with the proper mysql…
Bram
  • 53
  • 5
3
votes
1 answer

Restoring database to new cluster

we are using Percona 5.7.16-10 server. I would like to expand current solution with XtraDB cluster. So meanwhile I created other machines and started cluster (running on 5.7.17-11-57 Percona XtraDB Cluster version) and I did some testing there…
Radim
  • 164
  • 1
  • 4
  • 18
3
votes
2 answers

Getting a very bad performance with galera as compared to a standalone mariaDB server

I am getting an unacceptable low performance with the galera setup i created. In my setup there are 2 nodes in active-active and i am doing read/writes on both the nodes in a round robin fashion using HA-proxy load balancer. I was easily able to…
LakshayK
  • 162
  • 2
  • 8
1 2 3
…
43 44