-
Notifications
You must be signed in to change notification settings - Fork 10
mysqldump 시 replication 정보 추가 #7
Open
Description
mariadb replication 상태에서 master 백업시, slave 에서 복원을 위한 replication 정보 추가
--single-transaction 설정은 이미 포함되어 있음
--master-data=2
백업된 sql 상단에 추가되는 내용
-- -- Position to start replication or point-in-time recovery from -- -- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000113', MASTER_LOG_POS=72282874; -- -- GTID to start replication from -- -- SET GLOBAL gtid_slave_pos='0-1-193208812';
ex)
--single-transaction --master-data=2
Metadata
Metadata
Assignees
Labels
No labels
Type
Fields
Give feedbackNo fields configured for issues without a type.