MSR-related Deprecated Option

minstone·2022년 4월 19일
post-thumbnail
  • 상태값 'FILE'은 이상 사용되지 않으며 상태값 'table'은 MySQL 8.0 복제 메타데이터 리포지토리의 기본값.
  • MySQL 8.0.23버전 이후 아래 옵션 제거.
  • 옵션 적용 시 경고발생.

master_info_repository
relay_log_info_repository

The use of the system variables master_info_repository and relay_log_info_repository is now deprecated, and a warning message is issued if you attempt to set them or read their values. The system variables will be removed in a future MySQL version. These system variables were used to specify whether the replica’s connection metadata repository and applier metadata repository were written to an InnoDB table in the mysql system database, or to a file in the data directory. The FILE setting was already deprecated in a previous release, and tables are the default for the replication metadata repositories in MySQL 8.0.



# 참조
MySQL 8.0 Reference Manual

profile
🌚Stone Kid

0개의 댓글