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
-1
votes
2 answers

mysql differential/incremental backup in windows

I have done different type of backup a lot many times before, but I did everything in LINUX, because thats what people use normally :P. This time its a new app and it runs on client system independently and its windows. So xtrabackup/percona of no…
Koushik Paul
  • 995
  • 9
  • 13
-1
votes
1 answer

MySQL incorrect ordering

I have a table for example: id | name | date_add With content: 1| Mark | 2018-02-01 10:00:00 2| Andrew | 2018-02-01 10:00:00 When I try to do this request: select * from table order by date_add I get rows in the next order: 2, 1 It occurs in…
user3169724
  • 39
  • 7
-1
votes
2 answers

pt-table-checksum does't work with multi source (mariadb) Edit

pt-checksum is getting to never ending loop in multi-source (channel based) replication : A multi source replication in my environment n1 -> n2 (created n1 as channel replication) n2 -> n3 n1 -> n3 (n3 will replicate from both n1 and n2…
naveen_sfx
  • 727
  • 2
  • 9
  • 18
-1
votes
1 answer

Cannot use MySQL my.cnf file on Ubuntu 16.04 for mysql-5.7

I have installed percona-xtradb-cluster-server-5.7 on an Ubuntu 16.04 server, and mysql is running fine with the default config our of the box. However, when i try edit the my.cnf file, i get errors that the variables are unknown, e.g.,: mysql:…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
-1
votes
1 answer

Running Read heavy queries on Percona XtraDB cluster

I am creating a new 3 node Percona XtraDB cluster from scratch for a brand new application. Part of the application will generate read heavy queries which we intend to loadbalance across the cluster. Previously in a Master slave setup those read…
Lamp Consultants
  • 1
  • 1
-1
votes
1 answer

How to manage tablespace file size for a 1TB table?

Question 1. Is it possible to control the size of the IBD file serving huge tables such as 1 TB tables? Question 2. Is it possible to make the 1 TB table served by more than 1 *IBD files?
Jason Walsh
  • 1
-1
votes
1 answer

creating a trigger that executes sql statement over ssh in mysql

I have 2 (th and ct) servers that are completely separated each with it's own database I want to sync a table(et) in th with ct I want if new inserts are done in table th a trigger will fire a ssh connection to ct server and insert the new rows…
Hady Rashwan
  • 356
  • 1
  • 6
  • 21
-1
votes
1 answer

Preventing fedora from installing mariadb

I'm running Fedora 24, with kde plasma, having recently decided to try it after mostly being on Ubuntu. This morning while trying to update, I ran into a conflict between mariadb and percona. I had installed percona from rpms (since I couldn't…
FOOM
  • 426
  • 5
  • 13
-1
votes
1 answer

Delete from table is too slow Mysql Percona

Please suggest I have to low speed for delete records from DB For example: for InnoDB table with 2 000 000 records Command "DELETE FROM mytable; take over 2 minutes. I thinks it is too low. Have any idea how to fix it and speed up ? Server…
Ali
  • 1
-1
votes
3 answers

Archive mysql 6 months old data to other table

I am running a shopping website and there is a lot of data in order table. Now I want to archive 6 months old data in a separate table like order_archive. But my problem is that if I am doing so I have to change all my queries where order table is…
AvMishra
  • 1,365
  • 3
  • 14
  • 25
-1
votes
1 answer

Find the nodes in the percona cluster

How do I find the number of nodes and node ip addresses in the Percona XtraDB cluster from inside a Python application? I know the IP address of one node in the cluster.
srs
  • 516
  • 1
  • 4
  • 20
-1
votes
1 answer

Are Percona Server and MySQL versions tied?

I am new to Percona Server. There's one thing that I still don't have clear after reading several pages: Are Percona Server and MySQL tied by version? In other words, is every version of Percona Server like a fork of the same version of MySQL, and…
Francisco Zarabozo
  • 3,676
  • 2
  • 28
  • 54
-1
votes
1 answer

MySQL (After changing to Percona) numeric ordering changed

Sorry for the rubbish title. I've just installed Percona DB replacing MySQL DB on my VPS Ubuntu 12.10 lamp stack (PHP 5.5.8, Apache2). The problem is, category ordering has become slightly messed up. In that 11 is considered a lower number than…
i-CONICA
  • 2,361
  • 9
  • 30
  • 45
-2
votes
1 answer

MySQL: Duplicate Key Error 1022 for non duplicate key

I'm trying to create a table with different foreign key constraints but mysql complains about this DDL: CREATE TABLE tasks ( id INTEGER NOT NULL AUTO_INCREMENT, `createdAt` DATETIME NOT NULL DEFAULT now(), `updatedAt`…
Sebi2020
  • 1,966
  • 1
  • 23
  • 40
-2
votes
3 answers

Select SQL Query Not Working With Simple Where clouse

Thee is one table Mysql Table On which simple sql where date = 'Some date' is not working Have checked logs. Reload the tables several times & tried. This is proof that record exists :- select * from TRN_RP_CONSUMPTION_DAILY limit…
Punit
  • 39
  • 7
1 2 3
…
43
44