sql replication 성공
2020.02.20 21:51
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 154 | fcitx | WHRIA | 2020.04.05 | 59 |
| 153 | zerohq encryption [5] | WHRIA | 2020.04.23 | 58 |
| 152 | insync | WHRIA | 2023.02.09 | 58 |
| 151 | disk error | WHRIA | 2023.02.16 | 58 |
| 150 | XP shutdown 시 강제종료 시키기 | WHRIA | 2016.08.16 | 57 |
| 149 | cloudfront | WHRIA | 2023.04.09 | 57 |
| 148 | 윈도우 raid ahci 전환 | WHRIA | 2019.12.26 | 55 |
| 147 | boost 1.35 build | WHRIA | 2016.05.01 | 54 |
| 146 | chatbot | WHRIA | 2020.04.03 | 54 |
| 145 | mysql 암호화 [2] | WHRIA | 2020.04.24 | 54 |
| 144 | acquihire [1] | WHRIA | 2020.05.05 | 54 |
| 143 | software validation [1] | WHRIA | 2020.05.10 | 54 |
| 142 | 학술저널 받는법 | WHRIA | 2015.11.30 | 53 |
| 141 | lvm 확장 [1] | WHRIA | 2019.12.25 | 53 |
| 140 | 감가상각 계산 | WHRIA | 2015.11.30 | 52 |
mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=2 -A > ~/dump.sqlNow, examine the head of the file and jot down the values for MASTER_LOG_FILE and MASTER_LOG_POS. You will need them later:
head dump.sql -n80 | grep "MASTER_LOG_POS"