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

percona pt-table-checksum - Waiting to check replicas for differences

I have encountered a problem with Percona checksum.. The database contains about 70 tables and the checksum always stucks at the same table? If the table is dropped the checksum is completed like it should without any problems.. Have tried to empty…
clarkk
  • 27,151
  • 72
  • 200
  • 340
2
votes
1 answer

Percona Toolkit Vs. Openark Kit. Schema change

I tried to add unique index to 2 columns of an RDS DB table with pt-online-schema-change and it failed with the error like: DBD::mysql::db do failed: Access denied; you need (at least one of) the SUPER privilege(s) for this operation [for Statement…
Roman Newaza
  • 11,405
  • 11
  • 58
  • 89
2
votes
0 answers

Percona Mongodb- Socket exception

Getting below socket exception while trying to connect to mongodb sharding environment. "ctx":"js","msg":"Asio socket.set_option failed with std::system_error","attr":{"note":"connect (sync) TCP fast open","option":{"level":6,"name":30,"data":"01…
Karthiknathan.C
  • 105
  • 6
2
votes
0 answers

pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue

The version, mysql is InnoDB 5.6.10-log, pt-online-schema-change 3.1.0. table info is `email` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hotel_brand_id` int(11) DEFAULT…
Ilake Chang
  • 1,542
  • 1
  • 14
  • 19
2
votes
1 answer

AWS EC2 with MySQL not using anywhere near the resources available (Big INSERT..SELECT)

I have an EC2 (r5.2Xlarge) with MySql 8.0.22 installed and have 2 schemas with each around 1.3 TB. Tables contain between 300 million and 2 billion rows. For disks I use GP3 with 16,000 IOPS and 1000 MB/s. So this is quite good I would assume. All…
Thomas Miller
  • 79
  • 2
  • 8
2
votes
0 answers

CloudSQL "pg_hba.conf rejects connection for host" pmm-agent

I'm trying to setup a pmm-agent to monitor my db at GCP but I'm getting this error: pg_hba.conf rejects connection for host The user is postgres and I can connect trhough psql, but when I'm using it trought a service in machine, this fails. Already…
Anderson
  • 21
  • 5
2
votes
1 answer

What's the difference between `percona` and `percona/percona-server` docker images?

There're two docker images: https://hub.docker.com/_/percona/ and https://hub.docker.com/r/percona/percona-server Both seem to be maintained by Percona and have links to Percona's github. Why are there two of them? What is the difference between…
Eduard Sukharev
  • 1,188
  • 2
  • 15
  • 37
2
votes
2 answers

Create integer only table with a default charset, bad idea?

When I create a table, even if it's using integers only, I set the default charset to utf8 (because I copy paste the code and because in case I introduce a string column in the future). Example: CREATE TABLE IF NOT EXISTS `articles` ( `id`…
Barbz_YHOOL
  • 589
  • 4
  • 15
2
votes
0 answers

Galera cluster not working use wsrep_sst_method=xtrabackup (-v2) until first use rsync

I'm trying to setup a galera cluster, with MariaDB 10.2, and percona-xtrabackup-2.3.10-1.el7.x86_64. If bootstrap the donor by wsrep_sst_method=xtrabackup or xtrabackup-v2, the joiner will be unable to join in the cluster, and the error message…
James
  • 1,373
  • 3
  • 13
  • 27
2
votes
0 answers

Self signed OpenSSL certificate with same subject with PHP and Percona 8

I've seen a behaviour that I can't explain myself, so I hope anyone could help me understanding what is happening. Setup I'm using PHP 7.4 on Debian to connect to a Percona 8 (8.0.20-11) Server (also Debian) remotely, where OpenSSL 1.1.1d is…
Code.Working
  • 81
  • 3
2
votes
1 answer

RDS Monitoring using PMM2, Missing Host Metrics for Postgres

I am using PMM2 for monitoring all my RDS instances. I added Postgres as a remote database, But by adding a database as remote in PMM2 we miss host-level metrics like CPU, Memory etc. What is the recommended way of adding Postgres (RDS) or a way to…
xrage
  • 4,690
  • 4
  • 25
  • 31
2
votes
1 answer

percona xtrabackup considering local mysql socket as default even when host parameter is passed

Trying to take a full back up of MySQL database which is in network. I have pass the host param but still it is taking backup of database in my local machine using local mysql socket at /var/lib/mysql/mysql.sock When i am trying execute below…
Nandan Rana
  • 539
  • 3
  • 12
2
votes
2 answers

How do you monitor MariaDB SSL expiration for both replication and client certificates?

There are a number of tools for monitoring SSL expiration for services available via HTTPS, e.g. we use https://github.com/prometheus/blackbox_exporter to receive alerts when SSL certificates expire in <14 days on both internal and external…
n7s
  • 399
  • 1
  • 7
2
votes
0 answers

Percona XtraDB Cluster Operator - mount additional storage (INFILE)

We have Percona XtraDB Cluster Operator setup on Kubernetes. In main configuration of cluster we have set persistentVolumeClaim option for pxc and proxysql. This is the query, we would like to execute on our Percona Cluster: LOAD DATA LOCAL INFILE…
Jakub Sakač
  • 21
  • 2
2
votes
1 answer

How to Configure MySQL for Percona Monitoring and Management

I can not get any analytics from _PMM Query Analytics showing https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html this is that link. I changed the configuration as mentioned in this page, but after that pmm is not…
AATHITH RAJENDRAN
  • 4,689
  • 8
  • 34
  • 58
1 2 3
…
43 44