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
3
votes
1 answer

Error loading MySQLdb module: /usr/lib64/libperconaserverclient.so.18: version `libperconaserverclient_16' not found

I'm suddenly getting the following error on my hosted Django website: django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: /usr/lib64/libperconaserverclient.so.18: version `libperconaserverclient_16' not found (required by…
combatdave
  • 765
  • 7
  • 17
3
votes
1 answer

Deadlock on MTS replication

Situation: we have a master-master-replication using GTIDs on Percona MySQL 5.6.32-78.1. On server, there are about 10 databases and we've set slave_parallel_workers=5. One server is used for frontend handling and one for backend. Two or three times…
rabudde
  • 7,498
  • 6
  • 53
  • 91
3
votes
3 answers

Prometheus - getsockopt: connection refused

In the targets page of Prometheus, I'm getting the following error: I'm using it in Linux host Prometheus Version: prometheus, version 1.1.2 (branch: master, revision: 36fbdcc30fd13ad796381dc934742c559feeb1b5) build user: root@a74d279a0d22 …
tesla747
  • 145
  • 1
  • 8
3
votes
1 answer

How to use XtraDB and TokuDB in Percona?

After trying several times, I finally installed Percona on my Macbook using Homebrew and successfully connected to it via MySQL Workbench, but when I want to create XtraDB tables: Operation failed: There was an error while applying the SQL script to…
user5483434
  • 492
  • 7
  • 17
3
votes
3 answers

Unattended Percona Server 5.7 install on Debian Jessie

I'm trying to do an unattended install of Percona Server 5.7 from Percona's repository on Debian Jessie. I don't really care what root password I end up with, if any. That's secondary. So far I have been unsuccesful, ending up with three different…
jficz
  • 271
  • 3
  • 8
3
votes
5 answers

how to speed up query when using count and group by

I have two tables named seller and item. They are connected through a third table (seller_item) using a "n" to "m" foreign key relation. Now I a try to answer the requirement: "I as a seller want a list of my competitors with a count of items I am…
mostart
  • 105
  • 1
  • 2
  • 13
3
votes
2 answers

Percona Server for MongoDB fails to start when engine is set to rocksdb (MongoRocks)

My understanding is that Percona Server for MongoDB (latest version) is already compiled with the rocksdb engine. Yet, when I set the flag to use it, the service fails to start. It exits with code 100 (uncaught exception), and there is no journal…
Lee3
  • 2,882
  • 1
  • 11
  • 19
3
votes
1 answer

What does pt-online-schema-change tool do if it aborts?

I am planning to use pt-online-schema-change tool for a table alter on a production server in a replication environment. Wanted to understand what steps are executed when pt-online-schema-change tool aborts due to server tool. Is it possible to…
user3778226
  • 41
  • 1
  • 5
3
votes
1 answer

Error trying to convert tables to InnoDB

I have a Percona 5.1 server in production that uses MyISAM tables in our production database. To support DB transactions I need to update the tables to InnoDB. We're currently using MySQL 5.5 in development and the migration script runs fine with…
DaveO
  • 1,909
  • 4
  • 33
  • 63
3
votes
1 answer

percona timestamp default 0 not null

I have used Brew to install percona-server on my mac for local development ┌─(veilig@Jamies-MacBook-Air:s018)──────────────(~/api.foo.com)─┐ └─(13:25:%)── brew info percona-server ──(Wed,Sep03 -…
veilig
  • 5,085
  • 10
  • 48
  • 86
3
votes
2 answers

With pt-online-schema-change is it possible to pause at the "swap" stage for codebase deploy?

I'm investigating using pt-online-schema-change to assist in certain migrations where an ALTER TABLE command would cause a long maintenance window. I understand that pt-online-schema-change will create an empty copy of the table to perform the ALTER…
asolberg
  • 6,638
  • 9
  • 33
  • 46
3
votes
1 answer

Percona Toolkit Online Schema Change: Possible to add multiple columns all at once?

Does anyone know if it is possible to add multiple columns at one time using Percona's pt-online-schema-change for MySQL? I have tried literally every variant I can think of in order to add multiple columns at one time. It seems like something you…
Evan Volgas
  • 2,900
  • 3
  • 19
  • 30
3
votes
3 answers

innobackupex restoring changes root and debian-sys-maint password. mysql restart failed

I have to set up a backup strategy. I choosed innobackupex to do so running on Debian 6 Squeeze. There are two servers, The production server and a backup server (that should work if the production server crashes). There is no replication, I use…
Mirza Selimovic
  • 1,669
  • 15
  • 18
3
votes
4 answers

Mysql Innodb does not return the last row on select with desc order

We have a table scheme like following: CREATE TABLE IF NOT EXISTS `offers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `price` double NOT NULL, `ip` varchar(15) NOT NULL, `cdate`…
intacto
  • 451
  • 4
  • 12
3
votes
1 answer

MySQL Trigger with transaction insert or update

i'm using mysql db & java, so in my application i need to use trigger, but i need to make it save while inserting or updating. when insering new record in table A, trigger will do the work to insert some information in another table B. also when…
Motasem
  • 599
  • 1
  • 6
  • 13
1 2 3
…
43 44