Questions tagged [percona]
Percona : MySQL open source fork with performance improvements
160
questions
0
votes
1
answer
44
views
Error: Nothing to do while installing percona server on centos 7?
Can't install percona on centos 7
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
Output:
Loaded plugins: fastestmirror, langpacks
percona-...
0
votes
0
answers
6
views
pt-query-digest on large slowlog files runs slow - only singlethread
I have large slowlogfiles generated by percona 5.7 packed by zstd. Its for test, logging all queries, query time is set to 0s
I need it process quickly than in 12 hrs :) The pt-query-digest is ...
0
votes
0
answers
27
views
Installing XtraBackup on Centos 6
I’m trying to install XtraBackup on centos 6 using this guid but i get these errors:
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base)
Requires: libmysqlclient.so.16()(64bit)
Error: ...
- 99
0
votes
0
answers
62
views
Big performance gap between two similar servers in mysql-percona 5.6 ubuntu
I cannot figure out reason of performance difference between two (three?) similar percona 5.6 instances. I prepared some tpcc-like benchmarking using sysbench and among 3 similar servers, one is ...
2
votes
0
answers
148
views
Debugging Active Directory Login with MongoDB
I am trying to log into MongoDB using an active directory username. We're using Percona for MongoDB but I believe this really should be pretty similar to regular MongoDB 5.x authentication.
We've ...
- 619
0
votes
1
answer
247
views
how to take mysql xtrabackup to a remote server
I have a server running with mysql with huge db of 1 TB.
Now, I want to take full backup through percona xtra backup, because incremental backup is easy with percona xtrabackup.
Now,if I initiate ...
0
votes
1
answer
277
views
MySQL 8 replication via non-ssl connecion
I'm trying to setup tiny master-slave environment with percona-server-server.x86_64-8.0.27-18.1.el8.
A plan is to use non-ssl connections between the nodes as the servers will communicate in the LAN ...
- 1
0
votes
0
answers
306
views
Automate Percona Server installation
I'm installing Percona Server 8.0 on Ubuntu using ansible, so it's non-interactive. I'm trying to run the post-install mysql_secure_installation program, but that's not much good without interaction. ...
- 3,128
0
votes
1
answer
310
views
Can't restore master/slave replication from Percona backup (slave server)
A slave is restored from a master backup created with Percona xtrabackup
On the master binlog is set to expire in 14 days and this backup is less than 24 hours old
my.cnf (master)
expire_logs_days = ...
- 1,995
0
votes
0
answers
235
views
Mysql 5.7 slave poor performance with 5.6 master
We recently reinstalled 3 of our mysql servers running in master slave with percona 5.7 and ubuntu 18.04 instead of oracle linux 7. These servers are currently connected to a mysql 5.6 master. And ...
1
vote
1
answer
573
views
My innodb new rows disappear mysteriously
I used percona server 5.7 as my database on AWS. The problem is there's sometimes rows disappear mysteriously without a clue. My Backend using Node.JS already got inserted id from auto increment but ...
0
votes
1
answer
216
views
Get rid of debian-sys-maint instead of root in MySQL 8
We've recently upgraded from MySQL Percona 5.7 to 8 and we're in the phase of transitioning from mysql_native_password to caching_sha2_password.
As far as I understand, the only way to upgrade the ...
- 1,183
1
vote
0
answers
129
views
Does mcafee mysql audit plugin not work on Percona Server 5.7.27-30?
My environment is 5.7.27-30-log Percona Server on CentOS 7.4.
When I installed this plugin (audit-plugin-percona-5.7-1.1.7-866), I got the following error messages.
mysql> INSTALL PLUGIN AUDIT ...
- 11
0
votes
1
answer
184
views
Can not stop mysqld after database upgrade
I have an old Galera cluster (MySQL 5.5) that I am upgrading to Percona XtraDB (MySQL 5.7) on Ubuntu 18.04 LTS. I have successfully imported the database with xtrabackup and synced the cluster - so ...
- 125
1
vote
1
answer
7k
views
Constant problems with php-fpm, CPU usage 100% non-stop (No visitors even)
We are running two servers one for the application and one for the DB and some other software to keep the load off from the application's server, we are running CentOS and the latest version of PHP (7....
- 11
1
vote
0
answers
435
views
Mysql docker on centos not working
I use centos as server and I use docker-compose like:
mysql:
build: ./DockerFiles/Mysql
ports:
- ${LOCAL_PHP_IP}:${MYSQL_PORT}:3306
privileged: true
environment:
...
1
vote
0
answers
112
views
What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3
So we have been using Debian 9 with MariaDB 10.1. For faster backups (total DB size across three DBs is > 1TB) we have enabled innodb_track_changed_pages. However, that feature has gone away on ...
- 722
0
votes
1
answer
169
views
changing from percona to mariadb without losing data
i have a production server running with percona.
but i don't really like it anymore and i'm more used to mariadb.
can i change from percona to mariadb without losing any data or having compatibility ...
- 41
0
votes
1
answer
1k
views
automysqlbackup failes with ERROR 1045 (18000) Access denied ... after password change
I have two almost identical ubuntu database servers, and automysqlbackup was happily running on both of them on using Percona 5.7 databases.
On one of them I have changed the database root password....
- 173
0
votes
1
answer
306
views
percona toolkit pt-kill command --ignore-state flag
I have the following pt-kill daemon setup. It works but doesn't kill a query such as SELECT GET_LOCK(300). If I remove --ignore-state 'User lock' will this fix it?
sudo /usr/bin/pt-kill --ignore-...
- 467
1
vote
2
answers
544
views
Tune Percona Server 5.7
I am using a 4 core ubuntu cloud server with 8gb and ssds. There I have only one database for a Magento store which is about 2GB size.
Last month after some changes I made it seems that database ...
- 143
0
votes
2
answers
327
views
Fastest way to move Innodb database from one server to another
I understand I can use mysqldump or xtrabackup to move InnoDB from one db to another.
Considering I am okay with server down time, are there better way to move InnoDB database?
I have tried copying ...
- 5,701
-1
votes
2
answers
516
views
Increasing the number of connections MySQL 8 can handle (Debian 9 server) and auto restart event scheduler
I have a Debian 9 server (12 CPUs, 80GB of RAM), running Percona server for MySQL 8.0, about 1100 clients per second, the load is not very high around 0.3 to 2.30
Latested numbers from show engine ...
0
votes
2
answers
594
views
Enabling Encryption at Rest for MongoDB Generates Error
Running Percona Server for MongoDB server version: v3.6.8-2.0. I am attempting to enable encryption at rest using the procedure outlined in the following:
https://www.percona.com/blog/2018/11/01/...
- 131
2
votes
2
answers
5k
views
Mysql backup of remote server in local machine using percona xtrabackup
I have percona xtrabackup installed in my ubuntu client machine. My local machine IP address is 192.168.0.100. The database that i need to backup is in 192.168.0.200.
Is it possible to do the backup ...
- 21
4
votes
3
answers
5k
views
Entire proxmox Xen Node has grey question marks + database container gone
Firstly, i've recently taken on the management of a proxmox cluster which I have had no experience managing previously (i'm completely new to cluster management, but not too bad at linux).
pve-...
- 829
0
votes
1
answer
246
views
How to monitor mysql status variables and push to slack?
I've been trying to find a free way to monitor mysql status variables and push a slack notification when certain variables hit a threshold (ie: large number of connections).
At the moment, all the ...
- 829
0
votes
2
answers
1k
views
Nginx: location with proxy_pass, including uri (Percona PMM)
I'm trying to setup a proxy with Nginx for Percona Monitoring and Management (PMM). I'm using their public demo site for a testing purpose.
The goal is to expose PMM interface via URL like https://...
- 3,108
-2
votes
1
answer
362
views
How to run pt-kill on CentOS Server [closed]
So, I have downloaded pt-kill file with:
wget percona.com/get/pt-kill
Now, I tried running it, but everything is not working? How do you run this file?
- 123
0
votes
2
answers
835
views
Recover a failing node on Percona 5.5.41-37.0-55
I have a 3 node percona cluster of where 1 of the nodes has, because of a server crash, InnoDB log sequence problems.
180425 17:32:53 InnoDB: Error: page 151555 log sequence number
12431827692
...
- 3
0
votes
0
answers
418
views
How do I determine what is causing MySQL (Percona server) to crash on Linux
I am running the Percona version of MySQL Server v5.6 and every few days the MySQL seems to crash and then automatically restart itself. How can I work out what the reason is for the crash? I've seen ...
- 98
0
votes
0
answers
378
views
Having trouble updgraring mysql (Obsoleted By: Percona ... )
I'm trying to upgrage mysql 5.1 to 5.5.
Following this link step by step : https://www.zerostopbits.com/how-to-upgrade-mysql-5-1-to-mysql-5-5-on-centos-6-7/
But yum -y update mysql* gives me errorrs....
- 111
0
votes
1
answer
966
views
Connect MySQL using SSL only with the --ssl-ca option
I copied the ca.pem from server (Percona default 5.7 Ubuntu deb) able to make a secure connection with
mysql --ssl-ca=/var/lib/mysql/ca.pem -u root
I find that the options --ssl-cert and --ssl-key ...
- 5,701
0
votes
1
answer
505
views
How to set config file to percona-mongodb
I have an percona/percona-server-mongodb image of mongo.
I tried to mount my mongod.conf.
How to set config and run mongo with config file?
docker run --name mongo1 -v /opt/mongo/mongod3.conf:/etc/...
0
votes
2
answers
336
views
mysql to percona replication
Recently my employer was acquired by a bigger company and the new CTO wants us to move to their software stack. We have MySQL as the DB server, and they have Percona. So... what are the option to do ...
- 8,578
0
votes
1
answer
821
views
Initial Xtradb Cluster setup -- each node comes up isolated
I'm setting up a percona-xtradb-cluster-57 (3 nodes) on Ubuntu 16.04. They are to communicate using a private network, 10.254.10.101 through 10.254.10.103.
When I follow the instructions on Percona'...
4
votes
2
answers
5k
views
centos yum remove mysql will remove core components
Centos 7 x64, mysql-community 5.7 is installed from mysql57-community repo.
I am in the process of switching from mysql to percona. However, the first step is scary when I try to uninstall mysql.
...
- 287
1
vote
1
answer
1k
views
mysql tries to connect to localhost at startup, [Note] Access denied for user 'root'@'localhost' (using password: NO)
When I start/restart the mysql service, I always see this row in the log:
2017-07-19T17:35:02.379166Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
What is it trying to ...
- 410
0
votes
1
answer
269
views
how to speedup SELECT BENCHMARK(1000000,ENCODE('hello',RAND()));
I would like some ideas for speeding up the the query below:
SELECT BENCHMARK(1000000,ENCODE('hello',RAND()));
Currently, I've been playing around with the my.cnf option and I can execute this in 9....
- 113
2
votes
0
answers
3k
views
MYSQL: Aborted connection to db: 'unconnected' user: debian-sys-maint' host: 'localhost' (Got timeout reading communication packets)
I recently migrated all my logs to a new service, where I could see a recurring bug in mysql.
The message is the following:
Aborted connection <NUM> to db: 'unconnected' user: debian-sys-maint'...
- 121
0
votes
2
answers
2k
views
Percona-Server-shared my.cnf file conflicts with file from package mysql-community-server-5.5
I'm trying to install Percona Toolkit on the server where there is already mysql-community-server5.5.52 is running.
I require pt-table-checksum and pt-table-snc utility, so I ran:
yum install ...
6
votes
1
answer
8k
views
mysqldump: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled
When I try to run mysqldump on a Percona Server 5.7.17-12, I get this error:
# mysqldump -u backups -pxxxx -h 127.0.0.1 --single-transaction --quick dbname
mysqldump: [Warning] Using a password on ...
- 410
0
votes
1
answer
92
views
Percona xtradb cluster 1 node consuming memory
I've installed percona xtradb cluster on 3 nodes and all is good until i noticed that 1 node is consuming memory much more the other nodes
So i decided to stop all traffic going to this nodes and ...
1
vote
1
answer
312
views
Is there a way to load large BLOBs without restarting MySQL?
I'm trying to move the last few databases off an older mysql server, but one in particular has me stumped:
ERROR 1118 (42000) at line 595: The size of BLOB/TEXT data inserted in one transaction is ...
- 14.3k
2
votes
1
answer
592
views
mysqladmin not waiting for full shutdown (or debian init.d script broken?)
I'm running Percona MySQL server 5.6 (from packages) on debian wheezy (same behavior on jessie).
Unfortunately I always get this:
# service mysql stop
[FAIL] Stopping MySQL (Percona Server): mysqld ...
- 71
0
votes
1
answer
2k
views
Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?
I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database.
I would like to perform 'hot backups' simply using mysqldump on one of ...
- 133
0
votes
0
answers
211
views
Cannot create InnoDB tables
I have a working Percona database server running multiple databases with mostly InnoDB tables (maybe a few hundred tables total). Any table that exists is working fine, yet I cannot convert any ...
- 187
4
votes
1
answer
798
views
Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots
Basically what I'm looking for is a way to tell mysql (percona-flavored) to take the following steps:
Flush all committed transactions to the filesystem
Start buffering all transactions (keep the ...
- 187
0
votes
1
answer
352
views
Activating PAM configuration for Percona
I'm trying to configure Percona with LDAP support via PAM including group mappings and restriction. My Percona authentication setup is as follows:
INSTALL PLUGIN pam SONAME 'auth_pam.so';
create ...
- 187
0
votes
0
answers
85
views
pt-pmp fails to run on percona 5.5 ubuntu 12.04
Command:
[mysql] root:/mnt# pt-pmp --pid 16898
Wed Dec 7 18:41:51 UTC 2016
warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fffd4126000
18 libaio::??(libaio....
- 11