Stack Overflow
Stack Overflow

Questions tagged [percona]

Percona builds free and open source database software that includes: Percona Server for MySQL®, Percona Server for MongoDB, Percona XtraDB Cluster, Percona XtraBackup, Percona Monitoring and Management, and Percona Toolkit. The widely installed Percona Server for MySQL is a drop in replacement for MySQL, and includes XtraDB, an enhanced version of the InnoDB storage engine.

Percona builds free and open source database software that includes:

  • Percona Server for MySQL® a free, fully compatible, enhanced, open source drop-in replacement for MySQL which includes XtraDB, an enhanced version of the InnoDB storage engine.
  • Percona XtraDB Cluster an active/active high availability and high scalability open source solution for MySQL ® clustering.
  • Percona XtraBackup a free, open source, complete online backup solution for all versions of Percona Server for MySQL, MySQL ® and MariaDB®.
  • Percona Monitoring and Management a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance.
  • Percona Toolkit a collection of advanced open source command-line tools that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually.
  • Percona Server for MongoDB a free, enhanced, fully compatible, open source, drop-in replacement for the MongoDB® Community Server that includes enterprise-grade features and functionality
647 questions
5
votes
3 answers

InnoDB: The innodb_system data file 'ibdata1' must be writable

I'm trying to run percona xtradb cluster. The output from the percona server is as followings: mysqld: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored. 2019-06-10T07:24:28.000875Z 0 [Warning] TIMESTAMP with implicit DEFAULT value…
Shudipta Sharma
  • 5,178
  • 3
  • 19
  • 33
5
votes
1 answer

Is it safe to use ALGORITHM=INPLACE for MySql?

ALTER TABLE in MySql allows ALGORITHM=INPLACE for avoiding table copy during altering. But for default they use copy instead of inplace. Why? Does default value used for backward compatibility or there are some limitations or failure with inplace…
Cherry
  • 31,309
  • 66
  • 224
  • 364
5
votes
1 answer

Parsing JSON in mysql 5.5

I have a string stored as json in a mysql table. I need to parse the string and return the value within a stored procedure. Does Mysql 5.5 support this? I came across this UDF: https://github.com/ChrisCinelli/mysql_json Unfortunately, I cannot…
ssk
  • 9,045
  • 26
  • 96
  • 169
5
votes
3 answers

how to undo CHANGE MASTER TO

We have a slave that follow the master. In near future, the master will shut down and the current slave will become new master. After becoming master, how can I undo CHANGE MASTER TO MASTER_HOST='master'... SQL statement that previously executed on…
IAmAliYousefi
  • 1,132
  • 3
  • 21
  • 33
5
votes
2 answers

how to deal with percona keyserver with ansible

I have been trying to create a percona role in ansible and failing at it. I won't really say failing but it doesn't work as planned. Below is a snippet of the role - name: Setting up percona server apt-key apt_key: id=1C4CBDCDCD2EFD2A …
black sensei
  • 6,528
  • 22
  • 109
  • 188
5
votes
2 answers

How can i know if percona is installed

I though it is a silly question but after searching all over internet could not find an answer. So how do I check if I have Percona or original MySQL installed on the server?
besimple
  • 444
  • 1
  • 7
  • 12
5
votes
3 answers

Converting iso-8859-1 data to UTF-8 in UTF8 and Latin1 tables

Problem Summary: While trying to convert a site with mysql database from latin1 to utf8, some special characters are not displaying correctly despite ensuring charsets are all utf8 system wide. Problem Details: This is a common problem. But I seem…
David
  • 16,246
  • 34
  • 103
  • 162
5
votes
2 answers

WordPress database performance: Percona server vs MySQL w/o InnoDB

I don't want to ask a subjective "which DBMS is best?" or "which DBMS of these two is better?". This doesn't have to be a fanboy debate. Rather, I welcome any benchmark test results or specific experiences, when it comes to one specific criteria -…
OC2PS
  • 1,037
  • 3
  • 19
  • 34
5
votes
2 answers

MySQL / InnoDB occasionally some updates run very slow, in 'Updating' status

We have been experiencing an occasional massive slow down in UPDATE performance across our database. For example, the table FooTable we have about 40 columns with a varchar PK in addition there are 10 indexes. The following query took 44 seconds,…
Jeremy
  • 2,870
  • 3
  • 23
  • 31
5
votes
2 answers

Percona's pt-table-sync: how to run on more than one table?

In the command line, this will successfully update table1: pt-table-sync --execute h=host1,D=db1,t=table1 h=host2,D=db2 However if I want to update more than one table, I'm not sure how to write it. This only updates table1 as well and ignores the…
Joe
  • 279
  • 1
  • 4
  • 12
4
votes
2 answers

Percona and MySQL Workbench

Does anyone know if MySQL Workbench will work with a Percona 5.1 server? If not, can anyone suggest a similar tool that will?
David
  • 16,246
  • 34
  • 103
  • 162
4
votes
2 answers

mysql replication 5.5 master to 5.7 slave

We have two production MySQL servers running Percona Server 5.5.42 and would like to set up a new server running Percona Server 5.7 as a slave to them. However, because there's such a gap in versions, the 5.7 slave is unable to get a server_uid…
jyncka
  • 68
  • 1
  • 7
4
votes
2 answers

Why is Percona pt-online-schema-change performing so badly?

We've been using Percona OSC for a while now to make changes to our mysql schema without locking the tables and it has worked great, typically adding a new column or index to "large" innodb tables (~3.8 million rows) within a couple of…
SharkEgg
  • 41
  • 3
4
votes
3 answers

Percona Xtradbcluster: Error while getting data from donor node

I've a problem in joining new node to percona xtradbcluster. here is my log : I tested the test_sstuser working on honor without any problem . but in new nodes I get these errors : 2014-05-31 04:01:40 2391 [Warning] WSREP: Failed to prepare for…
a.fti
  • 39
  • 1
  • 6
4
votes
2 answers

Can't stop percona xtradb cluster node

I have three Percona xtradb nodes running on ubuntu 12.04 computers. I want to stop one of the nodes, without disconnecting eth0. I have tried: $ service mysql stop and $ /etc/init.d/mysql stop Both commands say stopping...OK. But I can still…
Francis Snipe
  • 551
  • 2
  • 10
  • 20
1 2
3
…
43 44