다음 커맨드를 실행하면 mysql binlog를 볼 수 있다.
show binlog events in ‘바이너리로그파일명’ from 포지션번호 limit 10
{“id”:631028} {“before”:{“test.test.user.Value”:{“id”:631028,“username”:{“string”:“Random-8d04a798-89df-4260-87f7-8f91d6da458e”},“vin”:{“string”:“c485b8d4-f5d4-459f-b686-52b6a5f8f343"},“address”:null}},“after”:null,“source”:{“version”:{“string”:“0.9.2.Final”},“connector”:{“string”:“mysql”},“name”:“test”,“server_id”:1944318,“ts_sec”:1554885981,“gtid”:{“string”:“9a227629-491c-11e9-ae9d-fa163ea8d9a7:1651774"},“file”:“mysql-bin.000001",“pos”:36040188,“row”:0,“snapshot”:{“boolean”:false},“thread”:{“long”:1616},“db”:{“string”:“test”},“table”:{“string”:“user”},“query”:null},“op”:“d”,“ts_ms”:{“long”:1554885981898}}
file : 바이너리 로그 파일명, pos에는 포지션 번호이다.
