Andrew's Garage

Shrunk Expand

Primary Navigation

[scrap] Replication 깨졌을때 Skip

http://simonshin.egloos.com/2247512

show slave statusG

Stop slave;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;

SLAVE START SQL_THREAD;

START SLAVE;
SHOW SLAVE STATUSG

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related


Posted on 2015-05-18 3:55 PM by andrew Comment
📂This entry was posted in DB관련 기술자료

Related Posts

  • 2015-05-19 andrew

    L(U)nix 에서 특정 문자열 위치 표시 및 구간 정보 보기

      grep   -n "패턴"  화일명  에서 처럼  -n 옵션을 사용하면 찾고자 하는 문자열이 포함이 되어 있는 line number를 표시 해 준다.   se...
  • 2015-06-16 andrew

    Working with Apache Cassandra on Mac OS X

    If you use Mac OS X as your platform for development work, then you may be interested to know how ea...
« [scrap]mysqldump 옵션 및 사용법 [scrap] mysql – dual master replication »

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

( optional )


©2026 boots Entries RSS and Comments RSS Child theme Boots of Raindrops Theme