MariaDB - Easy setup of Primary/Standby replication using mariadb-dump

Опубликовано: 19 Октябрь 2024
на канале: IT-INZHENER

From this video you will learn how to set it up very simply
Master - Slave replication on Mariadb database using two servers.

Replication helps to fully protect against hardware failure, for example, the failure of individual servers.

0:00 Start
0:20 On the Primary server we create a directory for binary logs
1:13 On the Standby server we create a directory for relay logs
1:43 On the Primary server we edit the database configuration file, namely we enable binary logging
3:16 On the Standby server, we edit the database configuration file, namely, we enable relay logging
4:44 Create a replication user on the Primary server
6:00 We perform backup on the Primary server
6:35 Transfer the backup to the Standby server and import it
7:19 From the Standby server we connect to the Primary database
10:46 On the Standby server we start replication
11:01 Checking the result
12:08 The end

#mariadb #primary #standby #active #slave #master #replication