Setting up a separate MySQL backup server is essential in the event of failure. Read this guide to set up a MySQL 8 Master-Slave replication on Ubuntu 20.04.
Join the DZone community and get the full member experience. MySQL is an open-source and one of the most widely used relational database management systems. Setting up a separate MySQL backup server is essential in the event of failure, as the backup server contains everything necessary for a successful recovery. Replication features in MySQL allow you to maintain multiple copies of MySQL data. All data in the master server will be synced to the slave server automatically. If your master server fails, you can promote a Slave to a Master for commit operations. For this tutorial, we will use the following configuration: First, you will need to install the MySQL 8 server on both servers. Run the following command to install the MySQL 8 server on both servers. After installing the MySQL server, you will need to set a MySQL root password on both servers. Run the following command to set a root password: You will be asked the following: Just press Enter to set a root password: Set your MySQL root password and answer the remaining questions as shown below: First, you will need to edit the MySQL default configuration file on the Master server to allow remote access and enable the binary log.
