Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
0
votes
1answer
249 views

Enable GTID on one node in Percona/Galera

Im having 3 node percona cluster. (5.6) Server ID is enabled on each node but all are different IDs. Binlog and log slave updates are enabled. Now I want to enable GTID on the third node alone. I ...
0
votes
2answers
421 views

Percona XtraDb cluster auto increment

Help me please clarify a very important question on which I can't find the answer. It only can be proven with tests. Let's say we have XtraDB Cluster (or Galera Cluster) with three nodes. We have ...
0
votes
1answer
57 views

Calculating Galera gcache for PXC

I was trying ti figure out how to calculate the right gcache for my server and came across the following post discussing just how to do that: https://www.percona.com/blog/2014/09/08/calculate-correct-...
0
votes
1answer
453 views

Pagination: Slow ORDER BY with large LIMIT range

I have a forum that run this query to do pagination for category pages: mysql> SELECT thread.threadid,thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, ...
0
votes
1answer
320 views

percona-online-schema-change is taking a lot of time

We have a table with 600M+ records and using AWS Aurora with master-slave replication. Requirement: We need to add two columns with index in customer table. Aurora Instance Specs: Ram: 30.5 GB ...
0
votes
1answer
646 views

Optimise Percona 5.7 my.cnf for a 32GB mixed nginx/php/mysql server

I have a dedicated server which I run my website from. It's got 32GB of ram, Xeon E5-1650 3.2Ghz (6 core, 12 with HT) and two 3TB drives in RAID 1. I'm running Percona 5.7.18 99% of my tables are ...
0
votes
1answer
84 views

MySQL tuning query - 5.6

I'm using Percona Server 5.6.31 on RHEL 6. 64G RAM/16vCPU - VMware. It's Completely InnoDB and the database size is 300G. I have set Innodb_buffer_pool to 52G, innodb_buffer_pool_instances to default ...
0
votes
1answer
81 views

MySQL Monitoring Tools

I want to deploy tools to monitor my Production Percona servers (5.6 on Linux). I never used Nagios or any tool before. I did go through this great link but I wanted to clarify few things before ...
0
votes
1answer
572 views

Percona Xtrabackup (Partial + incremental)

we have been trying restore Percona (Partial + Incremental) mysql backup, but failing. The process followed is as below: For Backup # Step I: Take Partial-Full Backup innobackupex --user=root -...
0
votes
1answer
70 views

MySQL - Upgrading from 5.5 to 5.6

I have MySQL community version 5.5.50 running in linux having 4-5 databases on it. Requirement is to upgrade to Percona Server 5.6.31-77.0. What are the pre-requisites that I need to check before ...
0
votes
1answer
497 views

how to change wsrep_cluster_size in Percona XtraDB Cluste?

I am trying to setup Percona XtraDB Cluster according to their doc When I run show status like 'wsrep%'; it's show wsrep_cluster_size is 1 in every node(2 node for me). Actually it should be 1 for ...
0
votes
1answer
26 views

Failed transaction replicated and thrown errors on remaining Percona XtraDB cluster nodes

I am using Percona XtraDB cluster 5.5.37. I have run one alter command (to add unique constraint) on node1. But due to duplicate keys,alter command failed on it. But that failed statement passed to ...
0
votes
2answers
72 views

percona-online-schema-change recommendation

I am currently setting up percona-online-schema-change to do a ALTER on a table with 300m+ rows. I've verified that percona-online-schema-change can make the required ALTER. The source table ...
0
votes
1answer
31 views

Allow access to RackSpace database from Vagrant box

we have two developers using Vagrant (which has it's own internal ip like: 10.0.2.0/24). On RackSpace we have a percona database instance. We would like to allow read/write access to that database ...
0
votes
1answer
1k views

Cannot overwrite file: /var/lib/mysql/ibdata1 when using Percona xtrabackup

I am receiving an error when I am trying to restore from a percona backup to my local mysql server. Cannot overwrite file: /var/lib/mysql/ibdata1 at /usr/bin/innobackupex line 2128. sudo ...
0
votes
1answer
64 views

How to determine if an Index is uselss in Percona MySQL?

Using Percona Server 5.5 I've a table which stores user activty (lets call it user_activity). It was created quite a few years ago when I had only a little bit of knowledge about database ...
0
votes
1answer
1k views

Mariadb Galera Cluster using Xtradb backup is not working

I am trying out the first test of MariaDB Galera cluster setup without success. This is the error in the log innobackupex: Created backup directory /tmp tar: -: Cannot write: Broken pipe tar: Error ...
0
votes
1answer
642 views

Mysql master master with high latency

We have a single master setup with many slaves in germany and some slaves in australia. To have faster writes in australia we want a master-master setup between germany and australia. Read slaves ...
0
votes
1answer
40 views

Is this normal binary logging behaviour - maintaining one ever growing file despite expire_logs_days?

I have a Percona MySQL DB running on a dedicated server. I have in my.cnf # REPLICATION # log_bin=/var/lib/mysql/binlogs/mysql-bin expire_logs_days=7 My issue is that the log file mysql-bin.000001 ...
0
votes
1answer
142 views

Any recommendation on my.cnf on aws.large instance?

Any best recommendation variables for my.cnf on percona server on a high 256GB RAM and 32 CPU with 4000 IOPS? How about below ones? > innodb_buffer_pool_size=180G > ...
0
votes
1answer
2k views

LDAP authentication with Percona Server

Reading over this post it seemed to indicate this plugin allowed user authentication via LDAP Percona Server is bundled with the PAM plugin which opens a plethora of ways to authenticate to MySQL ...
0
votes
1answer
175 views

MySQL: How to find MySQL 5.1 (with built-in InnoDB) or MySQL 5.1 (with InnoDB-plugin)?

My DB server has MySQL 5.1.58-community-log and I am planning to upgrade it to MySQL 5.6 with specific purpose of improving my system performance and removing the bottleneck issue. So, I have gone ...
0
votes
1answer
668 views

Trouble installing percona 5.6 on Google compute engine debian

I've been trying to install percona server on a fresh Google compute engine instance. I haven't installed mysql server previously. I followed the instructions from here. I get this when I use: apt-...
0
votes
1answer
2k views

Percona MySQL 5.5.33 not reading my.cnf?

At some point Percona MySQL on CentOS 6.4 seems to have stopped reading my.cnf, possibly after MySQL updated to 5.5.33 a few days ago. Selection from /etc/my.cnf: [mysqld] # GENERAL # user ...
0
votes
0answers
6 views

Unable to add new node to Percona eXtraDB Cluster

I have a machine which was bootstrapped once for a Percona eXtraDB Cluster which is no longer available. See systemctl status mysql@bootstrap.service below: [root@RH7 ~]# systemctl status mysql@...
0
votes
1answer
21 views

right syntax to use near 'TOKUDB_DEFAULT'

mysql> CREATE TABLE stable1 ( column_a INT NOT NULL PRIMARY KEY, column_b INT NOT NULL) ENGINE=TokuDB, ROW_FORMAT=TOKUDB_DEFAULT; ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
0
votes
0answers
23 views

MySQL oomkiller crashes after backup [duplicate]

I am using percona and the backups run successfully. However after the backup is done and sometimes during the backup MySQL is crashing and I am not certain where to start. Running show engine ...
0
votes
0answers
16 views

Problems importing innodb tablespaces

I am struggling with restoring a backup of a MySQL 5.5 database, which has been created with innobackupex --databases .... These are the steps to set up mysql and prepare the backup for restore: # ...
0
votes
1answer
27 views

Slow logs are not showing full details

I am new to mysql DB. I have set log_slow_verbosity value to full. root@localhost/(none)> SELECT @@global.log_slow_verbosity; +-----------------------------+ | @@global.log_slow_verbosity | +------...
0
votes
0answers
25 views

Percona: Analyze table doesn't work

I have a Percona 5.6.28 servers with a=some TokuDB tables. The biggest table has ~120 million rows. Statics keeps changeing in the past hald year: At first. Analyze table with recount model toke ...
0
votes
1answer
47 views

MySql Galera Multi site high availability

We have a datacenter with 3 percona glera nodes We have a store that wants to be in sync with our datacenter(multi master) our store's internet connection is not reliable ( may be down for 30 min), ...
0
votes
0answers
540 views

Error: ERROR 1047 (08S01) at line 6955: WSREP has not yet prepared node for application use

While restoring a dump from a CloudSQL instance into a node of a Percona xtradb cluster, I am getting this error. The line 6955 in the .sql dump file is in bold below: DROP TABLE IF EXISTS `...
0
votes
1answer
29 views

Percona/XtraDB Database with many of writes to a small table uses less CPU than the same database with less writes?

I'm trying to understand why Percona and xtradb InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it. I've a InnoDB database with only one table ...
0
votes
1answer
207 views

MySQL replication slave using percona and docker

I am trying to run a MySQL replication slave in a docker container. We are running MySQL 5.7.24-27-log in production and it's from the percona repository (Ubuntu 18.04). I have used xtrabackup to ...
0
votes
1answer
240 views

Is it possible to setup MySQL replication through ProxySQL?

We currently have replication working through haproxy so that if a node goes down replication continues with one of the other nodes. We're trying to completely replace haproxy with proxysql. Due to ...
0
votes
0answers
38 views

deadlock when transaction is waiting for itself

Sypnosis: percona-server 5.7.12, sometimes deadlocking Am I right interpreting this output in a way that transaction 2 is waiting on itself ? And, if yes - why ? ------------------------ LATEST ...
0
votes
0answers
76 views

Where and how to set the variables for Percona MySQL Audit Variables

I am trying to set the variable values for Percona MySQL Audit Plugin in my.cnf file before installing the audit plugin on MySQL Server like 'audit_log_rotate_on_size','audit_log_rotations' and '...
0
votes
2answers
348 views

Percona Xtradb cluster 56 node 2 rejoin cluster failed

I have following DB cluster: Node 1: Percona-XtraDB-Cluster-56-5.6.39-26.25.1 Node 2: Percona-XtraDB-Cluster-56-5.6.39-26.25.1 Node 3: Percona-XtraDB-Cluster-56-5.6.41-28.28.1 I start in order ...
0
votes
0answers
184 views

MySQL InnoDb crash when importing tablespace from remote machine

InnoDB crashes when importing ibd file from remote machine. Source version is MySQL-5.6.40, Destination version is MySQL-5.6.40. Database was backed up was backed Percona Xtrabackup with xbstream ...
0
votes
0answers
30 views

Proper way to fully backup and restore a database including indexes in a low-resource shared web host with ssh access?

I'm rather new to database management and I would like some advice on better practices by using the following experience as an example. Every time I update php software I do a quick export from ...
0
votes
1answer
112 views

Is it safe to use pt-online-schema-change in a multimaster environment?

I have 2 MySQL servers with row-based replication between them. Both of them are masters and slaves for each other (active-active master-master setup). If I understand it correctly pt-osc creates ...
0
votes
0answers
447 views

Is ProxySQL Suitable for Connection Pooling Apps?

I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up? I've found ...
0
votes
1answer
32 views

Xtrabackup corrupt incremental backup

I have 3 nodes PXC 5.6 cluster. Xtrabackup 2.3.10. Centos 7.6 Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64 I am using only single Node-1 for both read and write. And I use to take backup ...
0
votes
1answer
281 views

Percona PAM with AD authentication using SSSD

I have installed percona PAm plugin on my Percona server as shown below: mysql> show plugins; ... | auth_pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL | | ...
0
votes
1answer
38 views

Convert MyISAM to InnoDB in PXC master master

I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM. Total MyISAM table = 120 Total MyISAM table size = 80MB I have also read few recommendations where it suggests ...
0
votes
1answer
22 views

Character set warning in PXC logs

I am using PXC 5.6 (Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64) and my log file is flooded with this warning: [Warning] Client failed to provide its character set. 'latin1' will be used ...
0
votes
1answer
380 views

InnoDB Buffer causing a lot of deadlocks and connection/client timeouts

I have a PXC cluster (5.7) with three nodes running on CentOS 7 VMs, each with the following system info: mysql_db# free total used free shared buff/cache ...
0
votes
1answer
81 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
0
votes
1answer
219 views

Percona pt-table-checksum output is in infinite loop “Waiting for the --replicate table to replicate”

We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11 Master: Name: db-master1 (192.168.14.5) Slave: Name: db-slave2 (192.168.15.5) Replica ...
0
votes
1answer
58 views

Point In Time recovery on Mysql

Can someone please advise best methods to do a mysql PITR from binary logs that are saved in MIXED format. I am finding it difficult to identify the wrong queries that executed to avoid from restore ...