Question : I’m seeing a lot of tutorials that claim I have to pick just one of the nodes in […]
Tag: percona
Mysql error : Slave SQL Could not execute …on table
Question : Im running a percona cluster of 3 nodes. Yesterday I needed to throw some more memory in them, […]
Flush Host Connection Blocked, but some connections allowed
Question : We are running Percona MySQL 5.6.30. We’ve had an issue where a PHP script on a different host […]
MySQL8: xtrabackup Invalid stream argument: tar
Question : I am using xtrabackup to take full backup and send it to another host as .tar file using […]
truncate table in mysql 8.0 is slower than older version
Question : I have few hundreds of tests which use mysql. I was using Mysql 5.7 (percona) and I changed […]
Using CONVERT TO CHARACTER SET for changing only collation?
Question : I think the answer to this is an obvious yes, but I’m having trouble finding confirmation on it. […]
Can’t restore master/slave replication from Percona backup (slave server)
Question : A slave is restored from a master backup created with Percona xtrabackup On the master binlog is set […]
Does Percona Xtrabackup support RedHat release 4
Question : I downloaded Percona’s Xtrabackup rpm file for RedHAT. I attempted to install but hit into an error. The […]
Difference between FIND_IN_SET and LIKE
Question : Is there a difference in behavior or performance in choosing FIND_IN_SET over LIKE for a operation that looks […]
xtrabackup prepare – after dump or before restore?
Question : i have doubts about xtrabackup –apply-log. is there any difference when use it? should it be done right […]