Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Percona is a company that features their compilation of MySQL with emphasis on performance. That MySQL software is best known as Percona Server. They have downloads for MySQL 5.5, 5.1, 5.0, and MariaDB.

162 questions
1
vote
1 answer

Issue with percona-xtrabackup-2.0.0 hotbackup on MyIsam tables

I am trying to implement hot backup for MyIsam tables with "percona-xtrabackup-2.0.0" and getting the following error? As the all tables are MyIsam I doubt am I using the correct package ? Backup : ./innobackupex --user="root" --password=***…
arn
  • 91
  • 2
  • 7
1
vote
1 answer

Is it safe to use MySQL 5.1 clients with Percona server 5.5?

For a number of our websites we are using Ubuntu LTS 10.04 with MySQL 5.1. We are looking into consolidating the SQL databases onto a single server and have been testing Percona 5.5 for this purpose. The MySQL clients (PHP5-MySQL) use…
Falc
  • 11
  • 1
1
vote
2 answers

CentOS - Percona MySQL - Not Reading /etc/my.cnf

I've compiled Percona 5.5 on my CentOS 6.1 server and it starts fine, however it doesn't appear to be reading my /etc/my.cnf file. # In /etc/my.cnf character_set_server = utf8 collation_server = utf8_general_ci mysql> show variables like…
Mike Purcell
  • 1,708
  • 7
  • 32
  • 54
1
vote
3 answers

Percona MySQL 5.5 fails to start

trying to setup new server here but keep getting this in error log: mysqld_safe Starting mysqld daemon with databases from /data/mysql/myisam [Warning] Can't create test file /data/mysql/myisam/hostname.lower-test [Warning] Can't create test file…
keymone
  • 958
  • 8
  • 10
1
vote
2 answers

Linux: How to rename old mysqld when upgrading MySQL?

I'm upgrading MySQL from MySQL 5.0 to Percona Server 5.1. I'm planning to just use yum remove and yum install to do the upgrade. However, I read in the documentation that it's a good idea to rename the old mysqld to mysqld-5.0. And if the upgrade…
Continuation
  • 3,080
  • 5
  • 30
  • 38
1
vote
1 answer

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 after that, that rows is disappear without a…
Paiboon Panusbordee
  • 167
  • 1
  • 10
1
vote
0 answers

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 SONAME 'libaudit_plugin.so'; ERROR 1123 (HY000): Can't…
kanpai
  • 11
  • 1
1
vote
1 answer

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.3), Nginx (1.17.9), Percona MySQL (5.7), Redis,…
Ibrahim S
  • 11
  • 1
  • 3
0
votes
1 answer

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 issues afterwards? if so, is it as simple as ~…
Joe Silencio
  • 41
  • 1
  • 1
  • 6
0
votes
1 answer

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. Sucessfully apparently, as I can logon to the…
P Burke
  • 183
  • 3
  • 12
0
votes
1 answer

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-state 'User lock' --rds --match-command Query…
Chris Muench
  • 487
  • 3
  • 10
  • 31
0
votes
2 answers

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 all "ib_*" files and seems does not work. Are there…
Ryan
  • 5,831
  • 24
  • 72
  • 91
0
votes
1 answer

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 out-of-the-box solutions require massive monitoring…
David
  • 841
  • 3
  • 14
  • 31
0
votes
2 answers

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://localhost.local/pmm. server { listen 443…
HTF
  • 3,148
  • 14
  • 52
  • 82
0
votes
2 answers

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 InnoDB: is in the future! Current system log sequence…
japaveh
  • 3
  • 1
1 2 3
…
10 11