DBA expertise: PostgreSQL, SQL Server & MySQL
taking backup percona xtrabackup is consider a hot backup that backup the whole data directory with its redo logs and also it will take backup of the my.cnf to take backup we have already setup directory for backup mkidr backup to take the backup we will use the below command which will also compress the…
The steps involve installing Percona Toolkit to be able to use the Percona tool pt-show-grant. The tool will print out the users with their privileges and encrypted passwords. The following are the steps needed to successfully migrate a MySQL database and users to another MySQL server: 1. installing perocna toolkit to install persona tool kit…
installing Percona XtraDB Cluster We will first show the server list where we will install Percona XtraDB Cluster below are details for DB server the below server will be running rocky linux 8.9 Node Name host ip address prod-db01 pxc1 10.10.10.130 prod-db02 pxc2 10.10.10.131 prod-db03 pxc3 10.10.10.132 prod-proxysql 10.10.10.133 setup prerequisites before we start…
Types of MySQL Version Upgrades there are two types of upgrades Minor MySQL Version Upgrade Example : upgrade from 8.0.28 to 8.0.30 Major MySQL Version Upgrade Example : upgrade from 5.7 to 8.0 Minor Version Upgrade The first step when performing a minor version upgrade is to obtain the current version of MySQL and the…
Replication Concepts Facilitates data transfer from primary (master) server to replica (slave) server. Primary server stores the source data, while the replica server acts as the destination. Primary and replica servers are hosted on separate machines for redundancy. Replication occurs asynchronously by default, allowing flexibility in timing. Replica server doesn’t require a continuous connection…
MySQL Default Configuration File Option Files also called as Configuration Files most of MySQL programs can read the start-up options from the option files also know as configuration files meaning programs such as mysqld , mysqladmin , mysqlimport when they start they takes some options from option files , those options can be defined…
Physical/Cold Backup This backup method, also known as a cold backup, involves making a physical copy of MySQL instance files to a backup location. No backup tool is required; only a simple Unix-based command is used. It’s considered the safest way to preserve your MySQL instance. In this backup method, you’ll back up the…
DBA Account Up until now, we’ve predominantly used the root account on localhost for database management. However, as we expand access to remote users, it’s essential to understand how to establish non-root user accounts for remote access. This setup will allow users to connect via various clients like the standard MySQL Client, the newer MySQL…
MySQL Architecture MySQL Architecture is divided into layers , its quit simple but for now we will focus on outer layer ‘End-User/Client Layer’ and ‘physical storage’ End-User/Client Layer: This is where applications or tools that need to work with MySQL, like scripts, come in. They use something called a MySQL connector—a type of software that…
installing Mysql 8 community edition involve below steps 1.Add MySQL Repository package. 2. Install MySQL Community Server from the repository. 3. Enable MySQL server to auto-start. 4. Start MySQL server. 5 .Verify if MySQL is running. Follow the steps in the provided link to add the repository and install MySQL. click here installing MySQL percona…