-
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…
-
A Smarter Way to Manage Databases: Worlber vs. Traditional Hiring & Vendor Contracts
•
Worlber Cost Comparison and Services Overview About Worlber At Worlber, we provide expert database consulting for PostgreSQL, MySQL, and SQL Server. Our goal is to empower small and medium-sized businesses in the Kingdom of Saudi Arabia (KSA) with open-source database technologies—offering flexible, cost-efficient solutions without requiring long-term contracts or hiring new staff. Our Services…
-
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…
-
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…