CentOS7 enables MySQL8 master-slave backup and daily scheduled full backup (recommended)

Primary database:
vim /etc/my.cnf
Add the following content under [mysqld]:
server-id = 1
log-bin=mysql-bin
relay-log = mysql-relay-bin
replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=test.%
replicate-wild-ignore-table=information_schema.%
From the database:
vim .etc/my.cnf
Add the following content under [mysqld]:
server-id = 2 
log-bin=mysql-bin 
relay-log = mysql-relay-bin 
replicate-wild-ignore-table=mysql.% 
replicate-wild-ignore-table=test.% 
replicate-wild-ignore-table=information_schema.%
 Restart the master-slave database and log in to the master database mysql -uusername -ppassword
mysql>show master status;
Find master_log_file, master_log_pos (usually mysql-bin.000001 and 155)
mysql>change master to \
mysql>master_host='from database IP', 
mysql>master_user='from database user',
mysql>master_password='from database password',
mysql>master_log_file='from database master_log_file', 
mysql>master_log_pos='from database master_log_pos';
mysql>start slave;
mysql>show slave status\G
 
Log in to the database mysql -uusername -ppassword
mysql>show master status;
Find master_log_file, master_log_pos (usually mysql-bin.000001 and 155)
mysql>change master to \
mysql>master_host='Master database IP', 
mysql>master_user='Master database user',
mysql>master_password='Master database password',
mysql>master_log_file='Master database master_log_file', 
mysql>master_log_pos='Master database master_log_pos';
mysql>start slave;
mysql>show slave status\G

cd ../usr/local/src/dbback
If there is no dbback, add a new folder vi bkDatabaseName.sh (if there is no dbback, this file will be added automatically)
Copy content:
#!/bin/bash
source /etc/profile
mysqldump -uusername -ppassword DatabaseName | gzip > /usr/local/src/dbback/DatabaseName_$(date +%Y%m%d_%H%M%S).sql.gz
save.
Add executable permissions: chmod u+x bkDatabaseName.sh
After adding executable permissions, execute the script first to see if there are any errors and whether it can be used normally;
./bkDatabaseName.sh
Then check if there is any compressed file added to the scheduled task