숀패밀리

mysql 리플리케이션 쿼리스킵

· 2011-12-17 (토) 10:56:08 · 3416
리플리케이션 운영시 슬레이브가 쿼리한두개로 깨졌을때 스킵하여 복구하기입니다
 
SLAVE STOP;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
SLAVE START;
 
확인은
 
SHOW SLAVE STATUS\G;
|
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
12-03-19 조회 3,492
12-03-16 조회 4,042
12-03-14 조회 3,922
12-03-13 조회 3,540
12-03-13 조회 4,405
12-03-12 조회 5,473
12-03-12 조회 1만
12-03-08 조회 6,033
12-03-06 조회 1.1만
12-03-06 조회 3,724
12-03-06 조회 6,255
12-03-02 조회 5,021
12-02-29 조회 3,594
12-02-27 조회 4,083
12-02-22 조회 3,643
12-02-20 조회 3,624
12-02-20 조회 6,726
12-02-01 조회 3,237
12-01-30 조회 8,768
12-01-29 조회 3,260
12-01-24 조회 3,571
12-01-21 조회 3,229
12-01-10 조회 3,704
11-12-26 조회 3,602
11-12-23 조회 5,021
11-12-23 조회 4,678
11-12-23 조회 4,307
11-12-23 조회 8,003
11-12-22 조회 3,725
11-12-17 조회 3,758
11-12-12 조회 3,173
11-12-08 조회 7,714
11-12-08 조회 3,562
11-12-07 조회 3,800
11-12-06 조회 5,566
11-12-02 조회 3,517
11-12-01 조회 3,125
11-11-30 조회 6,928
11-11-26 조회 3,864
11-11-24 조회 4,646
11-11-22 조회 3,019
11-11-22 조회 6,642
11-11-18 조회 5,060
11-11-16 조회 3,447
11-11-14 조회 3,465
11-11-12 조회 3,957
11-11-08 조회 3,284
11-11-06 조회 1만
11-11-06 조회 3,859
11-11-03 조회 5,549
11-11-02 조회 5,821
11-11-01 조회 9,330
11-10-19 조회 2,829
11-10-17 조회 2,624
11-10-10 조회 2,571
11-10-07 조회 3,364
11-10-06 조회 3,960
11-10-06 조회 2,508
11-10-02 조회 3,260
11-09-08 조회 4,267
11-09-08 조회 2,642
11-09-07 조회 2,631
11-09-02 조회 2,711
11-09-01 조회 3,653
11-08-28 조회 3,541
11-08-23 조회 3,390
11-08-22 조회 2,797
11-08-22 조회 2,393
11-08-13 조회 2,443
11-08-05 조회 2,894
11-08-03 조회 4,098
11-07-03 조회 2,592
11-06-15 조회 3,233
11-06-15 조회 3,059
11-05-15 조회 2,874
11-05-11 조회 5,596
11-04-12 조회 3,003
11-01-27 조회 3,831
11-01-26 조회 2,631
11-01-26 조회 4,474
11-01-18 조회 2,688
10-11-23 조회 2,926
10-10-24 조회 4,739
10-09-15 조회 4,427
10-09-07 조회 3,399
10-08-27 조회 4,087
10-08-20 조회 6,975
10-07-30 조회 5,651
10-06-30 조회 2,889
10-06-11 조회 4,650
10-06-11 조회 3,341
10-05-15 조회 4,181
10-05-10 조회 2,861
10-03-19 조회 5,424
10-03-05 조회 5,189
10-02-17 조회 5,601
09-11-21 조회 6,934
09-11-09 조회 4,004
09-11-04 조회 6,735
09-10-26 조회 3,860