这篇博客讨论了MySQL 8.0中主从复制的管理，包括如何处理不断增长的二进制日志文件、mysqldump的使用以及在异步复制环境中恢复从库的方法。同时，它还涵盖了MySQL服务器的安全要求，如最小化无关进程、限制操作系统用户的访问以及正确的文件系统权限。此外，还提到了如何配置mysqld_multi以允许实例使用相同的端口。
Q81.The replication for master ad slave MySQL Server is up and running .The disk space occupied by the binary log files continues to grow.
Which two methods mange this issue?
A)Execute the FLUSH LOGS statement.
B)Delete all binary log files manually a=on the file system to release storage space.
C)Execute the PURGE BINARY LOGS statement.
D)On the master server,disable binary logging by removing the --log-bin option
E)Set the binlog_expire_logs_seconds variable.
Answer:CE
Q82.Examine this list of MySQL data directory binary logs:
Binlog.000001
Binlog.000002
........
Binlog.000289
Binlog.000300
Binlog.000301
Binlog.index
Now examine this command, which executes successfully:
Mysqldump --delete-master-logs--all-databases>/backup/db_backup.sql
Which two are true?
A)All databases are backed up to the output file.（不会备份sys、information_schema、performace_schema）
B)All details regarding deleted logs and master metadata are captured i
最低0.47元/天 解锁文章
967
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
