based on binlog master-slave replication, if master"s library or table is deleted, slave"s will also be deleted. I would like to ask whether the binlog read by slave from master is saved on slave, so that slave can be restored after deleting the database and deleting the table (assuming that the binlog of the main database is maliciously deleted after deleting the table)
is saved, but if you scroll forward, you can't find it without timely backup.
Open binlog on the slave library and open the log-slave-updates option, so that updates from Master Synchronize will be logged.
this ensures more security. Even if the master database is deleted and the log files are deleted, it can still be recovered from the slave!
delete truncate and other operations, the mysql master server can recover from the log itself. rm-rf , then the slave database does have this effect problem description start Times error mysql ERROR 2002 (HY000): Can t connect to local MySQL server through socket var lib mysql mysql.sock (2) there are no sock files in other directories find -name "* .sock " run chrony chronyd.soc...
use xtrabackup s innobackupex tool to back up the mysql database, some of which are myisam engines. After another machine is restored, when querying the table, prompt table "xxx " is marked as crashed and should be repaired, to use the repair command t...
B cannot access the database in A. I want B to use A s database, how to solve ...