Install Percona Monitoring and Management using Docker Rumi, September 9, 2022 You can any distribution for installation- Rocky/Alma/CentoS 8 Stream. I assume you’ll use anyone of these instance. Step 1: Add Docker Repository Docker is not yet available on default repositories. Thankfully, an official repository has been provided by developers and we are going to add it first to the system…. Continue Reading
Percona Mysql Service Force Stop Rumi, June 10, 2020 Service mysql stop is being ignored. How to fix? Try mysqladmin -u root -p shutdown Alternatively, In case you have started /etc/init.d/mysql bootstrap-pxc So in this case you should stop bootstrapped node using /etc/init.d/mysql bootstrap-stop Continue Reading
Exporting Percona Database Rumi, March 11, 2020March 11, 2020 Exporting percona database is however a bit tricky way to make funcitonal. The usual- mysqldump -u root -p [database] > database.sql will stuck and shoot you many error. All you need is the add an extended parameters to execute the dump, and here it is: mysqldump -u root -p [database]… Continue Reading
Install Percona XtraDB Cluster for MySQL 5.7 on Debian 8 Rumi, February 18, 2019 First of all, why we choose three nodes and not only two? In any cluster, the number of nodes should be odd, so in the case of disconnection of a node, we assume that the highest group of servers has the fresh data, and should be replicated to the down node… Continue Reading
Setup Percona on Debian 7 Rumi, November 23, 2017 MySQL multi-master replication is an excellent feature within MySQL. However, there is only one problem; standard multi-master replication seems to never be as stable as something like master-slave replication. It is always in need of attention. That is where Percona comes into play. The Percona team has developed an amazing… Continue Reading