INFRA Xpertzz

MySQL Master Master Replication – Step By Step

by | Jun 18, 2022 | MySQL

Here we will be implementing Master Master Replication in MySQL 5.7 For more interesting posts on MySQL, please click on INDEX Below are the server details which will be used : Server 1 : Hostname : Master1 IP Address : 172.168.190.1 Server 2 : Hostname : Master2 IP...

MySQL Upgrade from 5.6 to 5.7

by | Dec 17, 2021 | MySQL

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

by | Dec 17, 2021 | MySQL

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

by | Oct 16, 2021 | MySQL

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

by | Oct 16, 2021 | MySQL

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

by | Oct 16, 2021 | MySQL

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...