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-20 andrew

    [scrap]Unix Sed Tutorial: Advanced Sed Substitution Examples

    http://www.thegeekstuff.com/2009/10/unix-sed-tutorial-advanced-sed-substitution-examples/ This artic...
  • 2014-12-18 andrew

    오픈 소스를 활용하여 스트리밍 서비스 구축을 위한 방법(사이트 모음)

    오픈소스 기반의 동영상 스트리밍서버 구축 http://kldp.org/node/53236 초간단 스트리밍 서버구축 http://blog.naver.com/vader99?Redire...
« [scrap]mysqldump 옵션 및 사용법 [scrap] mysql – dual master replication »

Leave a Reply Cancel reply

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

( optional )


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