5 votes
Accepted

centos yum remove mysql will remove core components

Postfix depends on having a package that provides libmysqlclient. You can remove the old packages (mysql57-community) and install the new ones (Percona) in a single yum transaction using yum swap. ...
Florin Asăvoaie's user avatar
5 votes
Accepted

mysqldump: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled

This is a bug of Percona Server 5.7: This was introduced as part of our work in porting Facebook MySQL MyRocks engine to Percona Server 5.7. The use of I_S over P_S was not caught during the ...
the_nuts's user avatar
  • 460
3 votes

Mysql backup of remote server in local machine using percona xtrabackup

You need to install Percona Xtrabackup on the remote server and then SSH from your local server to the remote server. From this position, you can initiate the backup and stream to your local server. ...
greenweeds's user avatar
3 votes

Entire proxmox Xen Node has grey question marks + database container gone

I've also suffered from a problem with similar symptoms (all nodes, VMs, and CTs go into an "unknown" status). Using the command line everything seemed fine and so it was more of a nuisance than ...
Allison's user avatar
  • 131
2 votes
Accepted

Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots

If all of your databases are in InnoDB format, then you don't need to do this. InnoDB will automatically make your data consistent at startup if you do a restore.
longneck's user avatar
  • 23.2k
2 votes

Netcat (nc) traditional package for RHEL 6.x?

please install package the called nmap-ncat and check it.
Manoj K's user avatar
  • 77
2 votes

Percona XtraDB Cluster with GlusterFS

I've did this , exactly this But ... ... since the results with XtraDB ON TOP of gluster were mixed , in the end the thingy was moved to a triple-headed percona Cluster with ProxySQL , your database ...
Bash Stack's user avatar
2 votes

mysql to percona replication

Disclosure: I work for Percona. I'd prefer to comment but I don't have enough points on server fault. You might find this discussion about compatibility on the Percona blog of interest https://www....
greenweeds's user avatar
2 votes
Accepted

mysql to percona replication

Accoing to https://www.percona.com/software/mysql-database/percona-server/faq Percona Server is a backwards-compatible replacement for MySQL® Default scenario is mysqldump --master-data. It will ...
Alexander  Makarenko's user avatar
2 votes

Connect MySQL using SSL only with the --ssl-ca option

There is a discussion of this in this blog post, as things changed with 5.7.3: https://www.percona.com/blog/2017/06/27/ssl-connections-in-mysql-5-7/ The link in that post, though, has changed as I ...
greenweeds's user avatar
2 votes

Fastest way to move Innodb database from one server to another

For anyone wondering, Copying the entire mysql data root (in my case) /var/lib/mysql AFTER shutting down mysqld worked perfectly to migrate data to another system. Otherwise if you need replication ...
Colin Faber's user avatar
2 votes
Accepted

Get rid of debian-sys-maint instead of root in MySQL 8

So long as the root MySQL account uses unix_authauthentication plugin (so no password required for root user to log into MySQL) then you should be fine to remove the debian-sys-maint user. Note that ...
Jeremy Davis's user avatar
1 vote

Percona MySQL 8.0.25-15 filling up slow log with headers only

Consider adding to my.cnf or my.ini the following min_examined_row_limit=1 to avoid useless chatter in the Slow Query Log.
Wilson Hauck's user avatar
1 vote
Accepted

Can't restore master/slave replication from Percona backup (slave server)

I found the solution here https://www.percona.com/doc/percona-xtrabackup/2.3/howtos/setting_up_replication.html I was missing the xtrabackup --move-back command
clarkk's user avatar
  • 2,085
1 vote

My innodb new rows disappear mysteriously

Did you use MySQL transaction, AUTO_INCREMENT, and InnoDB/XtraDB? Did your Node.js MySQL driver uses implicit transaction? If so, you probably got hit by InnoDB AUTO_INCREMENT sequence gap. You can ...
mforsetti's user avatar
  • 2,766
1 vote

changing from percona to mariadb without losing data

I would play it safe and use mysqldump to export current databases to backups, and then import those files to the new database server. This is because the data format might be incompatible between ...
Tero Kilkanen's user avatar
1 vote

percona toolkit pt-kill command --ignore-state flag

User lock The thread is going to request or is waiting for an advisory lock requested with a GET_LOCK() call. For SHOW PROFILE, this state means the thread is requesting the lock (not waiting for it)....
asktyagi's user avatar
  • 2,934
1 vote

Mysql backup of remote server in local machine using percona xtrabackup

It's complicated, xtrabackup needs access to the filesystem, because it's copy database files, when mysqldump connects to the MySQL server and make database dump. But if you still want to use ...
Alexander Tolkachev's user avatar
1 vote

Entire proxmox Xen Node has grey question marks + database container gone

I run the below commands in ssh to solve the same problem I have on my server, although I did not use ./script.sh systemctl restart pvedaemon systemctl restart pveproxy systemctl restart pvestatd
Ebenezer Omotere's user avatar
1 vote
Accepted

Increasing the number of connections MySQL 8 can handle (Debian 9 server) and auto restart event scheduler

Please provide SHOW CREATE TABLE noticia. If texto is of type TEXT, then the one running query in the PROCESSLIST requires a table scan. If it is VARCHAR, then an index would probably help. You ...
Rick James's user avatar
  • 2,558
1 vote

Enabling Encryption at Rest for MongoDB Generates Error

The OP's own answer is essentially correct. But just in case you have an option: In theory, the migration can occur without downtime: if you do these steps on Secondaries first, step-down the Primary,...
greenweeds's user avatar
1 vote

Enabling Encryption at Rest for MongoDB Generates Error

Percona Server for MongoDB 3.6.8-2 can't encrypt existing databases. You have to shutdown the instance, purge the data files directory, configure the instance for encryption, and start the instance.
Adam's user avatar
  • 141
1 vote

Nginx: location with proxy_pass, including uri (Percona PMM)

Viewing the source on Percona's PMM demo page reveals this: <base href="/graph/" /> <link rel="stylesheet" href="public/build/grafana.dark.css?v5.0.4"> Put together, these are the ...
Joseph Montanaro's user avatar
1 vote

How to set config file to percona-mongodb

Very nearly there, just need to add “--config /etc/mongod.conf” to tell Percona Server for MongoDB to use your config file (mapped to /etc/mongod.conf) - the full command you need is here: docker run ...
greenweeds's user avatar
1 vote

Initial Xtradb Cluster setup -- each node comes up isolated

I think your problem might be: 2017-11-15T15:23:20.516889Z 0 [Note] WSREP: gcomm: connecting to group 'pxc-cluster', peer '' Assuming this is your second node and your first node is configured with: ...
Jervin Real's user avatar
1 vote

Is there a way to load large BLOBs without restarting MySQL?

There's no workaround, here. You'll need to restart. Everything in InnoDB is done in a transaction. Sometimes it's an implicit one (when autocommit is enabled, each statement executed -- ...
Michael - sqlbot's user avatar
1 vote

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

You can also use Percona XtraBackup (already shipped and used by Percona XtraDB Cluster), that is a hot backup tool (if you are using InnoDB tables only, which you should since you are on PXC), ...
Guriandoro's user avatar
1 vote
Accepted

Percona 5.7 restarting and drop my connection

There might be several reasons for this error. Often this is caused by a corrupt database. Check if this is the case via: mysqlcheck --check --all-databases The PHP exceptions you mentioned aren't ...
dr_'s user avatar
  • 1,105
1 vote
Accepted

CentOS6 box: yum remove Percona-Server-shared-51 dependencies

You should keep Percona-Server-shared-51. The rest can be uninstalled. You just need to: yum remove Percona-Server-client-56-\* Percona-Server-shared-56-\* Percona-Server-server-56-\* yum install ...
Mircea Vutcovici's user avatar
1 vote
Accepted

PerconaDB cant run without innodb_recovery 4

My help involves pointing you at the relevant documentation. You should read it carefully and be aware of the purpose of innodb force recovery. In particular If you are able to dump your tables ...
user9517's user avatar
  • 116k

Only top scored, non community-wiki answers of a minimum length are eligible