-
Types of MySQL Version Upgrades
•
there are two types of upgrades Minor Version Upgrade The first step when performing a minor version upgrade is to obtain the current version of MySQL and the newer minor upgrade available. To get the current version of MySQL on Red Hat, we use the following command, which queries the RPM package: To obtain…
-
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…
-
MySQL Storage Engines
•
Storage Engines MySQL supports a variety of table types to cater to different needs: To manage these diverse table types, MySQL uses different components known as storage engines. These engines are responsible for handling SQL operations for the tables. The storage engines include: MySQL employs a Pluggable Storage Engine architecture, which allows for the…
-
Mysql replication troublshooting
•
${toc} 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…
-
MONITORING 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…