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
0
votes
1 answer

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 = 14 restore script (slave) service mysql…
clarkk
  • 2,035
  • 8
  • 24
  • 36
0
votes
0 answers

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 since the reinstallation we are getting way more…
Jan Willem Mannaerts
  • 1
0
votes
1 answer

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 Plugin is with the below query, and if no password…
Tolsadus
  • 1,183
  • 11
  • 23
0
votes
1 answer

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 far so good. My problem is that I can not stop the…
koenig
  • 125
  • 8
-1
votes
2 answers

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 innodb status: 183.82 inserts/s, 169.69 updates/s,…
Luciano Serra
  • 3
  • 4
-1
votes
1 answer

installing Percona XtraDB Cluster on Ubuntu 13.04

So, a bit of explanation of the big picture: I am trying to get multiple PXC instances running on a single machine, replicating via Galera to each other. I am running Ubuntu Server 13.04 amd64 in a VirtualBox OSE virtual machine. I installed the…
lord_nullset
  • 1
  • 2
-1
votes
2 answers

Basic usage commands of Percona Server?

Im trying to use Percona Server with XtraDB with Drupal But the documentation not describe the basic usage like how to login to the CLI (MySQL usemysql -u root -p), how to create database, etc Connecting Drupal with MariaDB is very easy because all…
cewebugil
  • 715
  • 3
  • 9
  • 12
-2
votes
1 answer

How to run pt-kill on CentOS Server

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?
Wolfdog
  • 123
  • 2
-2
votes
1 answer

How does one add commands to nrpe.cfg for Percona MySQL plugins on NRPE client?

How do you add commands to nrpe.cfg for Percona MySQL plugins on NRPE client? To configure percona-nrpe plugins for mysql you will have to do 3 things viz : 1. define commands in command.cfg 2. Define service in service.cfg 3. Add commands on…
Ashish Karpe
  • 277
  • 2
  • 5
  • 19
-2
votes
1 answer

Backup/Recovery like barman for MySQL

I'd like to have a Backup/Recovery tool for MySQL (MariaDB/Percona) servers which has somehow the same features as barman has for postgresql take full backups on a regular basis (xtrabackup, but cool life with others too) collect binary logs (copy…
m.sr
  • 1,060
  • 1
  • 8
  • 19
-2
votes
1 answer

installing percona mysql on centos

From where will I get the mysqldump file from /usr/bin of percona mysql server (32 bit centos 5)? Is it available on the web without installing the software? In other words I am collecting all mysqldump utilities built by percona for various flavors…
shantanuo
  • 3,579
  • 8
  • 49
  • 66
-3
votes
2 answers

syntax error, unexpected $end, expecting FTS_TEXT or FTS_TERM or FTS_NUMB or '('

I have many messages like the following in /var/log/mysqld.log What does it mean? %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%$ syntax error,…
rabotalius
  • 109
  • 1
  • 5
1 2 3
…
10
11