Using percona xtrabackup for backup
taking backup percona xtrabackup is consider a hot backup that backup the whole data directory with its redo logs and...
Read MoreAuthor: AHMED
MySQL to MySQL Migration Guide
The steps involve installing Percona Toolkit to be able to use the Percona tool pt-show-grant. The tool will print out...
Read More
Mysql Perocna Xtradb Cluster Setup Guide
installing Percona XtraDB Cluster We will first show the server list where we will install Percona XtraDB Cluster below...
Read More
Upgrading MySQL Server
Types of MySQL Version Upgrades there are two types of upgrades Minor MySQL Version Upgrade Example : upgrade from 8.0.28...
Read More
MySQL Server Replication
Replication Concepts Facilitates data transfer from primary (master) server to replica (slave) server. Primary server stores the source data,...
Read More
MySQL Server Configuration
MySQL Default Configuration File Option Files also called as Configuration Files most of MySQL programs can read the start-up...
Read More
MySQL Backup & Restore
Physical/Cold Backup This backup method, also known as a cold backup, involves making a physical copy of MySQL instance...
Read More
MySQL User Administration
DBA Account Up until now, we’ve predominantly used the root account on localhost for database management. However, as we expand...
Read More
Exploring MySQL Server
MySQL Architecture MySQL Architecture is divided into layers , its quit simple but for now we will focus on outer...
Read More
MySQL installation and removing
installing Mysql 8 community edition involve below steps 1.Add MySQL Repository package. 2. Install MySQL Community Server from the repository....
Read More