Replication of database servers

Published: 05 March 2023
on channel: Skule Sørmo
71
1

Configuration of Mariadb/Mysql databases to replicate one master database to a slave database on a different server. Configuration procedure shown in VMware Workstation with Centos 9 Streaming servers.

In order to secure your Mariadb or Mysql databases, you can copy the database from a master server to a slave. That can be done online immediately when the databases are republicated from a master databases to slave databases. That secure from hardware disk failure. Not from update failure, since all changes of the master databases are immediately copied to the slave server. Therefore, the need for other kind of regular backup routines is also required. The replication can be done to a number of slave servers simultaneously, but only one slave server is discussed here.

Useful link about this subject: https://www.server-world.info/en/note...


Watch video Replication of database servers online without registration, duration hours minute second in high quality. This video was added by user Skule Sørmo 05 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 71 once and liked it 1 people.