편리한 호스팅 미소IDC

   
 
 
 

      1차 네임서버 :
      ns1.misoidc.com
      101.79.73.101

      2차 네임서버 :
      ns2.misoidc.com
      101.79.73.105

      어제 : 229 ,오늘 : 247
      전체 : 1,015,897


     

 

 
작성일 : 12-10-31 10:22
mysql Replicating
 글쓴이 : 싼웹호스팅
조회 : 26,542  

Replicating specific databases only

As mentioned earlier, the master and slave database server do not need to be entirely in sync, with all databases and all tables from the master replicated onto the slave. By default, the slave will replicate everything, but you can change this behavior with the following options in the slave configuration file:

replicate-do-db=db_name (replicate this database)
replicate-ignore-db=db_name (don't replicate this database)
replicate-do-table=db_name.table_name (replicate this table)
replicate-ignore-table=db_name.table_name (don't replicate this table)
replicate--wild-do-table=db_name.table_name 
	(allows wildcards, e.g db% would be all databases beginning with db)
replicate-wild-ignore-table=db_name.table_name (ignore all specified tables, with wildcards)

These options can all be used multiple times in a single configuration. A couple of other useful options:

replicate-rewrite-db=master_db->slave_db (allows you to use map databases 
	that use different database names on each server)
log-slave-update (writes replicated statements to the slaves binary logs)


 
 

Total 78
번호 제   목 글쓴이 날짜 조회
18 리눅스에서 소스컴파일을 이용한 Trac, Subversion 설치 완벽 가… (1) 싼웹호스팅 05-10 21854
17 ORA-00020: maximum number of processes (%s) exceeded 싼웹호스팅 05-14 20059
16 memcached Cacti Template 싼웹호스팅 05-17 46818
15 rsyslog + LogAnalyzer 싼웹호스팅 05-21 41740
14 backuppc 소스설치 하기 (1) 싼웹호스팅 06-11 52139
13 레이어 팝업 - 닫기&오늘 하루 열지 않기 싼웹호스팅 06-12 39587
12 PHP 와 MongoDB 사용법 싼웹호스팅 07-27 65969
11 mysql Replicating 싼웹호스팅 10-31 26543
10 centos 6.2 oracle 10g 설치 (2) 싼웹호스팅 12-17 116977
9 MSSQL에서 DB 복원 후 사용자에 로그인이름이 없어 오류가 나는 … 싼웹호스팅 02-19 20155
8 MSSQL _Log.LDF 파일 사이트 커졌을때 정리하는 방법 싼웹호스팅 02-20 19005
7 [장비] OmniSwitch 6850-24x L2/L3 스위치 설정 싼웹호스팅 03-05 100011
6 The 5 minute DBA: Default My.cnf File 싼웹호스팅 03-06 22311
5 [Linux] 하드웨어 정보 확인하기 - dmidecode, lshw 싼웹호스팅 03-06 205651
4 MS-SQL 리플리케이션 (병합복제) 테이블 추가 방법 싼웹호스팅 05-09 24486
 1  2  3  4  5  6