enable auditing can be done on both community and enterprise edition and its strait forward option for best approach we will use enable auditing permanently enabling auditing navigate to the below directory cd /usr/share/mysql-8.0/ run the below command to run script to install audit plugin mysql -u root -p -D mysql < audit_log_filter_linux_install.sql verify that…
mysql
MONITOR MYSQL
Getting MySQL Report from pt-mysql-summary This tool will generate report what is configuration for MySQL instance , how many replica MySQL has Or if the MySQL itself is replica , how many uses are connected What are the users doing How many databases How bug us innodb buffer pool size What is the version of…
mysql replication troublshooting
to achieve the best result in troubleshooting it is highly recommended to install percona toolkit it contains tool that will help resolve replication error Coordinator stopped because there were error(s) in the worker(s). when we use the command show replica status\G we found The error message you received indicates that there was a failure in…
MySQL master slave repliaction
installing MySQL Enterprise db1 & db2 we already downloaded the MySQL enterprise iso and added it on vm we have added three spread disk on the vm that we use to create separate directory for the following MySQL data dir MySQL bin-log MySQL backup also make sure to disable selinuix once we have setup the…
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 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…
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 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…
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 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…
Upgrading MySQL Server
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…
MySQL Server Replication
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 Server Configuration
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…