Percona
Working with Percona
Step 1 — Install Percona
Update the package index sudo apt update Install Curl packages sudo apt install -y cur...
Step 2 — Replication Configuration on Primary Server
install nano sudo apt-get install nano Edit my.cnf file sudo nano /etc/mysql/my.cnf ...
Step 3 — Replication Configuration on Replication Server
On Replication Server sudo nano /etc/mysql/my.cnf [mysqld] server-id = 2 relay_lo...
Step 4 — Master Replication over SSL
Check following attributes on both master and replication servers. sudo nano /etc/mysql/my.cnf ...
Percona Toolkit
Experimenting each percona toolkit tools to efficiently replicate from the master to slave server
1. Prerequestics
Test Database Download sakila db https://dev.mysql.com/doc/index-other.html Extract the...
2. pt-archive
In this test case, data exchange from one table to another in the same db on the same server C...
pt-summary
Summarizes the status and configuration of a server Locate the pt-summary find / -name pt-sum...