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
0 answers

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 other people with MySQL stopping unexpectedly and…
Andy Castles
  • 98
  • 1
  • 9
0
votes
0 answers

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. Loaded plugins: fastestmirror, security Setting…
Deckard
  • 111
  • 4
0
votes
1 answer

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 are actually no needed. What are the drawbacks in…
Ryan
  • 5,831
  • 24
  • 72
  • 91
0
votes
1 answer

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/mongod.conf -d percona/percona-server-mongodb
Meiram Chuzhenbayev
  • 231
  • 1
  • 3
  • 9
0
votes
2 answers

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 it with minor downtime ? Are the MySQL binary logs…
drookie
  • 8,625
  • 1
  • 19
  • 29
0
votes
1 answer

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's site just as written, after bootstrapping the…
user396356
  • 1
  • 2
0
votes
1 answer

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.5 seconds... but, is there any way where I can…
peixotorms
  • 113
  • 1
  • 5
0
votes
2 answers

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 percona-toolkit I got the following error: Transaction…
user3637899
  • 1
  • 2
0
votes
1 answer

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 check if the memory is going to be full again. Node…
user177174
  • 1
0
votes
1 answer

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 the nodes that doesn't serve the application by…
rgvcorley
  • 133
  • 6
0
votes
0 answers

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 existing MyISAM tables or even create new InnoDB…
HonoredMule
  • 187
  • 11
0
votes
1 answer

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 user 'dba'@'%' IDENTIFIED WITH auth_pam AS…
HonoredMule
  • 187
  • 11
0
votes
0 answers

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…
brenguy
  • 11
  • 1
  • 1
  • 4
0
votes
1 answer

Percona 5.7 restarting and drop my connection

i have fight with this bug a long time now, when i run scripts to MySQL (Percona) i disconnect me, and when i try to import a mysql dump from a live server its here disconnect me to. So what i'm fight with its why i got connection refuesed every…
ParisNakitaKejser
  • 261
  • 3
  • 10
0
votes
2 answers

Percona mysql-server on ubuntu 16.04

Issue: Can't install Percona mysql server. Platform: Ubuntu 16.04 x64 Server is an Openvz container. Memory: 1.5GB installation method apt-get install percona-xtradb-cluster-server-5.6 Source: cat /etc/apt/sources.list deb…
fatninja
  • 11
  • 1
  • 3
1 2 3
…
10 11