숀패밀리

mysql 리플리케이션 쿼리스킵

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

프로그램

8,188건
+
제목 글쓴이 날짜 조회
12-04-26 조회 3,830
12-04-24 조회 3,226
12-04-23 조회 4,558
12-04-22 조회 3,251
12-04-19 조회 3,334
12-04-18 조회 4,387
12-04-18 조회 3,098
12-04-17 조회 3,371
12-04-17 조회 5,130
12-04-16 조회 3,547
12-04-13 조회 3,089
12-04-09 조회 3,161
12-04-04 조회 3,933
12-04-01 조회 3,211
12-03-31 조회 3,602
12-03-30 조회 3,212
12-03-30 조회 3,873
12-03-26 조회 3,482
12-03-26 조회 3,064
12-03-22 조회 3,216
12-03-21 조회 3,072
12-03-19 조회 3,481
12-03-17 조회 3,510
12-03-14 조회 3,239
12-03-10 조회 3,922
12-03-09 조회 3,501
12-03-09 조회 3,327
12-03-08 조회 3,801
12-03-08 조회 3,972
12-03-08 조회 4,065
12-03-03 조회 3,314
12-03-02 조회 4,639
12-02-28 조회 3,174
12-02-27 조회 2,987
12-02-25 조회 3,130
12-02-24 조회 3,840
12-02-23 조회 3,107
12-02-22 조회 3,628
12-02-22 조회 5,397
12-02-22 조회 3,970
12-02-22 조회 4,290
12-02-18 조회 3,781
12-02-17 조회 3,001
12-02-17 조회 3,409
12-02-14 조회 3,484
12-02-13 조회 3,364
12-02-10 조회 1만
12-02-08 조회 3,023
12-02-07 조회 3,363
12-02-06 조회 3,088
12-02-05 조회 3,553
12-01-31 조회 3,481
12-01-30 조회 9,664
12-01-29 조회 3,821
12-01-26 조회 3,420
12-01-25 조회 4,033
12-01-24 조회 3,427
12-01-10 조회 3,739
12-01-10 조회 4,497
12-01-09 조회 3,272
12-01-08 조회 7,135
12-01-08 조회 3,657
12-01-07 조회 5,191
12-01-04 조회 3,888
12-01-02 조회 3,114
12-01-02 조회 3,168
12-01-02 조회 3,474
12-01-01 조회 3,107
11-12-31 조회 3,416
11-12-31 조회 3,094
11-12-30 조회 3,259
11-12-30 조회 3,412
11-12-29 조회 3,626
11-12-28 조회 3,718
11-12-26 조회 3,292
11-12-23 조회 3,507
11-12-22 조회 3,051
11-12-15 조회 4,142
11-12-08 조회 3,959
11-12-05 조회 3,298
11-12-04 조회 5,714
11-12-03 조회 3,574
11-12-02 조회 3,355
11-12-01 조회 5,430
11-11-30 조회 2,914
11-11-30 조회 2,814
11-11-28 조회 3,159
11-11-26 조회 3,339
11-11-25 조회 3,359
11-11-24 조회 2,955
11-11-22 조회 3,046
11-11-22 조회 2,888
11-11-17 조회 2,823
11-11-11 조회 2,821
11-11-09 조회 2,877
11-11-08 조회 3,255
11-11-08 조회 2,546
11-11-04 조회 3,627
11-11-01 조회 2,935
11-10-26 조회 2,521