log 2022-07-17
blog
jo
평가 작성 완료..
prepare ch 11 - 3
binlog test
mysql binlog 설정 적용 완료.
에러가 발생했었는데, 알고보니 원인은 로그 폴더를 다른 하드로 지정했는데, 권한 이나 설정 문제였던 것으로 보인다.
mysql data folder도 해당 폴더의 상위 폴더로 지정하고, 그 상위 폴더를 chown -R로 권한 설정하고, mysql log 파일과 index 파일을 생성 후 니 성공적으로 mysql 실행이 되었다.
epikem@epi-nano:~/dev/repos/dev-tips$ cat /var/log/mysql/error.log
2022-07-17T13:59:24.228901Z 0 [ERROR] Aborting
2022-07-17T13:59:24.228950Z 0 [Note] Binlog end
2022-07-17T13:59:24.229077Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2022-07-17T13:59:24.721417Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-17T13:59:24.724378Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.38-0ubuntu0.18.04.1-log) starting as process 26290 ...
mysqld: File '/mnt/HDD/mysql/logs/mysql-bin.~rec~' not found (Errcode: 13 - Permission denied)
2022-07-17T13:59:24.729800Z 0 [ERROR] MYSQL_BIN_LOG::open_purge_index_file failed to open register file.
2022-07-17T13:59:24.729816Z 0 [ERROR] MYSQL_BIN_LOG::open_index_file failed to sync the index file.
2022-07-17T13:59:24.729829Z 0 [ERROR] Aborting
2022-07-17T13:59:24.729881Z 0 [Note] Binlog end
2022-07-17T13:59:24.729998Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2022-07-17T13:59:25.222758Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-07-17T13:59:25.225735Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.38-0ubuntu0.18.04.1-log) starting as process 26373 ...
mysqld: File '/mnt/HDD/mysql/logs/mysql-bin.~rec~' not found (Errcode: 13 - Permission denied)
2022-07-17T13:59:25.231106Z 0 [ERROR] MYSQL_BIN_LOG::open_purge_index_file failed to open register file.
2022-07-17T13:59:25.231123Z 0 [ERROR] MYSQL_BIN_LOG::open_index_file failed to sync the index file.
2022-07-17T13:59:25.231136Z 0 [ERROR] Aborting
2022-07-17T13:59:25.231188Z 0 [Note] Binlog end
2022-07-17T13:59:25.231314Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
아래가 최종 설정인데, 지금 보니 log_bin은 _ (언더스코어) 든 - (대쉬) 든 상관이 없는 것 같다.
# log-bin=/mnt/HDD/logs/mysql-bin.log
[mysqld]
server-id=1
binlog_format=row
datadir = /mnt/HDD/mysql
log_bin=/mnt/HDD/mysql/logs/mysql-bin.log
log_bin_index=/mnt/HDD/mysql/logs/mysql-bin.index
#log-bin=/var/log/mysql/mysql-bin.log
binlog_cache_size=2M
# max_binlog_size=100M
# expire_logs_days=7
Comments