Questions tagged [percona]
Percona : MySQL open source fork with performance improvements
0
votes
1answer
33 views
Is it safe to use pt-online-schema-change in a multimaster environment?
I have 2 MySQL servers with row-based replication between them. Both of them are masters and slaves for each other (active-active master-master setup).
If I understand it correctly pt-osc creates ...
0
votes
0answers
17 views
Is ProxySQL Suitable for Connection Pooling Apps?
I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up?
I've found ...
0
votes
1answer
16 views
Xtrabackup corrupt incremental backup
I have 3 nodes PXC 5.6 cluster. Xtrabackup 2.3.10. Centos 7.6
Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64
I am using only single Node-1 for both read and write.
And I use to take backup ...
0
votes
1answer
28 views
Percona PAM with AD authentication using SSSD
I have installed percona PAm plugin on my Percona server as shown below:
mysql> show plugins;
...
| auth_pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL |
| ...
0
votes
2answers
38 views
Safe backup of PXC / Galera cluster
I have 3 nodes 'master master' cluster and using PXC 5.6
But I am only using a single node for both read and write.
Before using pxc, i was using standalone Mariadb 5.5 and I was taking backup using ...
0
votes
1answer
14 views
Convert MyISAM to InnoDB in PXC master master
I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM.
Total MyISAM table = 120
Total MyISAM table size = 80MB
I have also read few recommendations where it suggests ...
0
votes
1answer
9 views
Character set warning in PXC logs
I am using PXC 5.6 (Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64) and my log file is flooded with this warning:
[Warning] Client failed to provide its character set. 'latin1' will be
used ...
0
votes
1answer
29 views
Auto increment gap in percona xtradb cluster master master setup
I was using mariadb 5.5 before but now I have upgraded it and using percona xtradb cluster 5.6
I have 3 nodes cluster. I am only using single node for read and write.
I saw some increment gaps in ...
2
votes
0answers
30 views
Percona Xtradb Cluster not accepting options on command line
I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error:
CentOS 7:
systemctl start mysql --wsrep-sst-donor=srv1
...
-1
votes
0answers
38 views
Percona XtraDB Cluster 5.6 commit slow
I'm running Percona-XtraDB-Cluster-server-56 with Version : 5.6.39 Release : 26.25.1.el6. with 2 node PXC + 1 Garbd monitor.
Sometime commit command is slow, it affect to all commit command at that ...
0
votes
1answer
25 views
Missing wsrep variables in mysql / percona / galera cluster
I set up a small mysql/percona/galera cluster using the percona cluster docker image, with 3 nodes.
I followed the documentation written here
After starting up the whole cluster, I'm missing some of ...
0
votes
1answer
60 views
InnoDB Buffer causing a lot of deadlocks and connection/client timeouts
I have a PXC cluster (5.7) with three nodes running on CentOS 7 VMs, each with the following system info:
mysql_db# free
total used free shared buff/cache ...
5
votes
1answer
96 views
MongoDB Migrating away from RocksDB to WiredTiger
We have been working for some time with RocksDB as our engine and we are now trying to migrate to WiredTiger. We have some pretty big databases around 4~12 TB of data and according to the process ...
0
votes
0answers
18 views
mysql got connection timeout vs error tineout
I have Percona XtraDB Cluster with 3 nodes, and noticed a lot of the following timeout messages in my MySQL error log:
2018-11-13T08:34:13.724411-00:00 411826 [Note] Aborted connection 411826 to db: '...
1
vote
0answers
97 views
Percona 5.6.28-76.1: optimize config for database (Invision Power Board)
At the beginning I would like to explain that I'm not a DB expert. My hosting provider is struggling with DB optimization for my website. Unfortunately seems that they are out of ideas.
I would like ...
-1
votes
0answers
48 views
Orphaned foreign keys in mysql table
I'm running a Percona XtraDB Cluster with MySQL 5.7.12, which (amongst others) contains two tables like the following:
Create Table: CREATE TABLE `t1` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
...
1
vote
1answer
46 views
MySQL PXC node failing to receive state
I have three nodes that I want to setup into a Percona XtraDB Cluster (PXC). I have bootstrapped the first node and joined the second node, but cannot somehow join the third node. All configuration is ...
1
vote
0answers
25 views
Database with lots of writes to a big table uses less CPU than the same database with less writes?
I'm trying to understand why InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it.
I have a table with nearly 5M rows, about 9GB in size. I also ...
0
votes
1answer
34 views
ProxySQL in PXC and failing all nodes
I'm going to install Percona XtraDB Cluster, and I have two questions about it:
1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html
Or installing ProxySQL ...
0
votes
2answers
61 views
MySQL Solution to Sync 3 servers data
I have 3 servers which there is a load-balancer in front of them and sends the requests to these servers randomly.
The script is the same in all of these 3servers, but I need to sync the DB in all of ...
0
votes
1answer
38 views
Percona pt-table-sync Can't determine Master
We have following Multi master replication scenario. We are using MariaDB 10.1.34 and Percona 3.0.11
Master: Name: db-master1 (192.168.14.5)
Slave:
Name: db-slave2 (192.168.15.5) Replica Connection ...
0
votes
1answer
58 views
Percona pt-table-checksum output is in infinite loop “Waiting for the --replicate table to replicate”
We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11
Master: Name: db-master1 (192.168.14.5)
Slave: Name: db-slave2 (192.168.15.5) Replica ...
0
votes
1answer
50 views
Enable GTID on one node in Percona/Galera
Im having 3 node percona cluster. (5.6)
Server ID is enabled on each node but all are different IDs.
Binlog and log slave updates are enabled.
Now I want to enable GTID on the third node alone. I ...
1
vote
1answer
16 views
Does wsrep_cluster_address only accept the intranet IPs?
I was installing Percona XtraDB Cluster with 3 nodes.
Each node has a unique Internet IP address.
Following the docs Quick Start Guide for Percona XtraDB Cluster, I got the first node running but ...
0
votes
1answer
35 views
Point In Time recovery on Mysql
Can someone please advise best methods to do a mysql PITR from binary logs that are saved in MIXED format.
I am finding it difficult to identify the wrong queries that executed to avoid from restore ...
0
votes
1answer
49 views
Percona xtradb Backup for OLTP
I have installed MySQL 5.7 community edition installed.
Can we use Percona xtradb backup tool for backup DB for banking site databases for OLTP?
1
vote
1answer
122 views
what is MDL? (e.g. 'MDL semantics' or 'MDL locks') Probably Galera related
I found a guy talking about MDL semantics in a Galera/XtraDB bug report.
What is MDL? The term MDL also in Galera logs MDL conflict. Please explain in detail.
2018-06-14 17:07:10 140112699321088 [...
0
votes
0answers
27 views
percona mysql key_buffer_size value on replication slave
I noticed way odd behavior of replication slave due to altering key_buffer_size parameter.
I have 5.6.39 version of percona mysql and RAM 257671MB, according to the articles in the Internet i ...
1
vote
0answers
166 views
DPKG error: uninstall percona xtradb server 5.7
Trying to uninstall percona, as I broke installation. No luck:
>$ sudo apt remove percona-xtradb-cluster-server-5.7
Reading package lists... Done
Building dependency tree
Reading state ...
0
votes
2answers
259 views
Mysql backup of remote server in local machine using percona xtrabackup
I had asked this question in serverfault.Later, i came to know about this site.
I have percona xtrabackup installed in my ubuntu client machine. My local machine IP address is 192.168.0.100. The ...
2
votes
0answers
65 views
TokuDB/Percona - Insert Performance worse as table grows
We have a bunch of existing servers which run just fine, inserting our thousand rows/second, but the new batch just will not do it. As the day goes on and the table grows, it gets slower and slower, ...
0
votes
0answers
57 views
SQL Binary logs are dumped to fill up my disk space is full
I have an eCommerce website hosted in famous cloud environment and i had to enabled high availability of Database replication in Percona XtraDB cluster. Now the binary logs are eat up my disk space ...
1
vote
2answers
2k views
How to set MySQL binlog retention in hours?
I'm in a situation where the MySQL log partition is being filled in less than a day. I can't disable binlogs, since I need them for replication.
I know I can set log retention but that accepts days, ...
1
vote
2answers
380 views
ProxySQL user not connecting - XtraDB
I'm trying to set up a xtraDB Cluster consisting of 3 nodes. Now i've got the cluster up and running and per the instructions i'm trying to set up ProxySQL for load balancing.
So i've installed ...
1
vote
2answers
177 views
MySQL XtraDB/Galera Cluster High Availability RamDisk *SuperFast*
Ok, So this is going to be a speculative question, mostly design oriented and a rather long one. I'd grab a cuppa' covfefe, if I were you.
Preface: So I have been researching into databases and ...
0
votes
2answers
168 views
Percona XtraDb cluster auto increment
Help me please clarify a very important question on which I can't find the answer. It only can be proven with tests.
Let's say we have XtraDB Cluster (or Galera Cluster) with three nodes. We have ...
0
votes
0answers
77 views
Xtrabackup fails for full backup after a restore
After a restore in Percona 5.7 from another Percona 5.7 server full backups are failling with the following error:
xtrabackup: cd to /data/mysql
xtrabackup: open files limit requested 0, set to ...
0
votes
0answers
34 views
Percona Xtradb Cluster : VPS VS Dedicated
I installed Percona Xtradb Cluster on 3 VPS Centos 7 nodes and I converted all MyISAM tables to Innodb before migrating. After migrating the database to VPS, Percona works very well and SQL queries ...
1
vote
0answers
206 views
Full database backup using xtrabackup stream
I'm new to Percona XtraBackup. I've been trying to perform a full backup stream from my local ( test server around 600GB ) to remote server.
I just have some questions and I need guides, and I think ...
2
votes
1answer
265 views
Using Pt-online schema change on multi master MYSQL
We are using two MYSQL servers in ring replication where master is also a slave of the other master. Both have slaves connected to each other.
We want to run pt-online-schema-change to add couple of ...
1
vote
1answer
113 views
How can I make an Async Slave track all of the nodes in a Percona XtraDB Cluster?
I'm seeing a lot of tutorials that claim I have to pick just one of the nodes in my master-master replicated PXC to act as master for an async slave using vanilla mysql replication, and if something ...
0
votes
2answers
266 views
High “Pending normal aio writes”
During daily batch operations (mass delete/upsert operations), regular throughput is sometimes affected, e.g. operations such as a single lookup on a PK or a small range (7 rows examined, 1 row ...
1
vote
2answers
337 views
MySQL InnoDB .ibd file growing extreme
We have a database with a few larger tables were one (yes only one) table grows extremely. It contains only 50 gigabytes of data while the .ibd file (we use innodb_file_per_table) takes up about 1.2 ...
1
vote
2answers
1k views
MySQL memory usage keeps growing. 30GB growth in 3 weeks
We have a server with 64GB memory.
After restarting MySQL, in 3 weeks memory is almost full.
MySQL was installed using Debian Percona packages.
Version: Percona Server Release 17 5.7.19-17-log
In ...
0
votes
1answer
79 views
(re)creating empty tables in partially restored mysql database fails with “table exists”
Following situation:
I have a MySQL Server (running Percona Server 5.7) set up as a replication slave. This server should hold only a partial replication. To get to this I made a partial backup of ...
1
vote
1answer
122 views
Percona-Server: slow TokuDB queries after upgrading from 5.6 to 5.7. ANALYZE TABLE doesn't resolve the problem
After upgrading from Percona-TokuDB 5.6.29-76.2 to 5.7.19-17 we see some very slow queries on some tables without primary keys, but multiple non-unique indexes. The box we migrated to is pretty well ...
0
votes
1answer
283 views
how to setup percona pmm monitoring of percona 5.7 in docker container
I want to monitor percona running in docker with the percona monitoring and management client.
I have percona monitoring and management installed, running and monitoring other percona instances (...
1
vote
1answer
303 views
xb_stream_read_chunk(): wrong chunk magic at offset 0x0
I have taken a backup of mysql instance like this
innobackupex \
--user=$MYUSER \
--password=$MYPASS \
--no-timestamp \
--parallel=$DUMP_THREADS \
--stream=xbstream \
--slave-info \
...
1
vote
0answers
87 views
TokuDB table stats row count decreases very fast while adding/updateing data
We run an Percona server with the newest version(5.7.19-17).
After a while the cardinality of multiple tables drop to zero.
A new created index also have an cardinality of 0 if the existing are zero.
...
3
votes
2answers
2k views
What is the optimal solution for storing real time time-series in MariaDB / MySQL?
Use case: A measurement creates a given number of images. For each image we need to store a small set of quality indicators (floats, doubles) along with an image integer [1 ...N], a timestamp and one ...
