MySQL Upgrade from 5.6 to 5.7

In this post we will see how to upgrade MySQL Database Instance from MySQL 5.6 to MySQL 5.7 NOTE : If you are planning to upgrade in a Master-Slave Environment, please upgrade all Slave Environments first before upgrading Master Server database. Please stop the Slave...

MySQL upgrade from 5.7 to 8.0.21

In this post, we will see how to upgrade your MySQL database from 5.7 to 8.0.21 version NOTE : If you are planning to upgrade in a Master-Slave Environment, please upgrade all Slave Environments first before upgrading Master Server database. Please stop the Slave...

Steps to implement Master-Slave MySQL Replication

Master Server IP : 172.168.190.15 Slave Server IP : 172.168.190.35 For more interesting posts on MySQL, please click on INDEX 1. Take dump on master and restore on slave bin/mysqldump –defaults-file=/mysqldatabase/TEST/admin/my.cnf -uroot -pmysql...

MySQL Replication

To make MySQL a  totally reliable and available in cases of high load, database replication and clustering are a possible solution to achieve this For more interesting posts on MySQL, please click on INDEX As MySQL is one of the first open source databases, its...

MySQL Database

What is MySQL Database? MySQL is an open-source relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. Open Source means...

MySQL Backup and Restore Commands

In this post,I am going to explain the native methods that are used to generate the backup of the database. Mysqldump is a command-line utility that is used to generate the logical backup of the MySQL database. It produces the SQL Statements that can be used to...