숀패밀리

mysql 리플리케이션 쿼리스킵

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

프로그램

8,188건
+
제목 글쓴이 날짜 조회
12-08-29 조회 5,524
12-08-21 조회 3,501
12-08-21 조회 3,583
12-08-05 조회 3,518
12-08-04 조회 4,497
12-07-31 조회 9,382
12-07-26 조회 3,913
12-07-24 조회 3,531
12-07-20 조회 3,547
12-07-15 조회 3,471
12-07-09 조회 4,717
12-07-09 조회 3,426
12-07-09 조회 3,313
12-07-06 조회 4,157
12-07-05 조회 3,256
12-07-05 조회 3,331
12-06-30 조회 3,441
12-06-29 조회 3,237
12-06-26 조회 3,470
12-06-18 조회 3,341
12-06-18 조회 3,472
12-05-31 조회 3,624
12-05-29 조회 4,387
12-05-23 조회 3,463
12-05-22 조회 3,767
12-05-17 조회 4,601
12-05-10 조회 3,511
12-05-06 조회 3,392
12-05-04 조회 3,062
12-04-25 조회 3,559
12-04-21 조회 3,103
12-04-21 조회 4,475
12-04-20 조회 3,571
12-04-10 조회 3,016
12-04-06 조회 2,880
12-04-05 조회 3,219
12-04-05 조회 3,893
12-03-31 조회 3,040
12-03-30 조회 3,105
12-03-29 조회 3,016
12-03-28 조회 3,047
12-03-27 조회 3,346
12-03-26 조회 3,737
12-03-23 조회 2,932
12-03-20 조회 2,994
12-03-12 조회 2,941
12-03-12 조회 3,261
12-03-12 조회 3,165
12-03-12 조회 4,115
12-03-12 조회 5,732
12-03-12 조회 3,714
12-03-12 조회 5,523
12-03-12 조회 3,738
12-03-12 조회 6,140
12-03-06 조회 3,052
12-03-04 조회 4,201
12-03-02 조회 4,108
12-02-16 조회 5,184
12-02-15 조회 4,646
12-02-11 조회 3,012
12-02-08 조회 2,871
12-02-08 조회 3,878
12-02-07 조회 3,276
12-01-30 조회 3,093
12-01-29 조회 3,415
12-01-25 조회 3,406
12-01-19 조회 3,060
12-01-12 조회 3,083
11-12-30 조회 3,709
11-12-29 조회 3,108
11-12-26 조회 3,095
11-12-26 조회 2,995
11-12-17 조회 4,129
11-12-17 조회 3,399
11-12-01 조회 3,080
11-11-19 조회 4,250
11-11-14 조회 4,132
11-11-14 조회 2,749
11-11-10 조회 2,981
11-11-10 조회 3,648
11-10-27 조회 2,523
11-10-26 조회 2,609
11-10-25 조회 2,522
11-10-17 조회 3,695
11-10-10 조회 2,562
11-10-03 조회 2,627
11-09-28 조회 2,490
11-09-28 조회 3,996
11-09-26 조회 2,475
11-09-26 조회 2,590
11-09-25 조회 2,935
11-09-19 조회 6,060
11-09-09 조회 3,024
11-09-08 조회 3,333
11-08-31 조회 3,125
11-08-29 조회 5,110
11-08-25 조회 2,794
11-08-23 조회 2,472
11-08-21 조회 2,492
11-08-19 조회 2,409