Æí¸®ÇÑ È£½ºÆà ¹Ì¼ÒIDC

   
 
 
 

      1Â÷ ³×ÀÓ¼­¹ö :
      ns1.misoidc.com
      101.79.73.101

      2Â÷ ³×ÀÓ¼­¹ö :
      ns2.misoidc.com
      101.79.73.105

      ¾îÁ¦ : 211 ,¿À´Ã : 264
      Àüü : 1,151,006


     

 

 
ÀÛ¼ºÀÏ : 12-10-31 10:22
mysql Replicating
 ±Û¾´ÀÌ : ½ÑÀ¥È£½ºÆÃ
Á¶È¸ : 30,299  

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 63376
17 ORA-00020: maximum number of processes (%s) exceeded ½ÑÀ¥È£½ºÆà 05-14 22434
16 memcached Cacti Template ½ÑÀ¥È£½ºÆà 05-17 78868
15 rsyslog + LogAnalyzer ½ÑÀ¥È£½ºÆà 05-21 55965
14 backuppc ¼Ò½º¼³Ä¡ Çϱâ (1) ½ÑÀ¥È£½ºÆà 06-11 62293
13 ·¹À̾î Æ˾÷ - ´Ý±â&¿À´Ã ÇÏ·ç ¿­Áö ¾Ê±â ½ÑÀ¥È£½ºÆà 06-12 45210
12 PHP ¿Í MongoDB »ç¿ë¹ý ½ÑÀ¥È£½ºÆà 07-27 100429
11 mysql Replicating ½ÑÀ¥È£½ºÆà 10-31 30300
10 centos 6.2 oracle 10g ¼³Ä¡ (2) ½ÑÀ¥È£½ºÆà 12-17 333035
9 MSSQL¿¡¼­ DB º¹¿ø ÈÄ »ç¿ëÀÚ¿¡ ·Î±×ÀÎÀ̸§ÀÌ ¾ø¾î ¿À·ù°¡ ³ª´Â ¡¦ ½ÑÀ¥È£½ºÆà 02-19 23610
8 MSSQL _Log.LDF ÆÄÀÏ »çÀÌÆ® Ä¿Á³À»¶§ Á¤¸®ÇÏ´Â ¹æ¹ý ½ÑÀ¥È£½ºÆà 02-20 22502
7 [Àåºñ] OmniSwitch 6850-24x L2/L3 ½ºÀ§Ä¡ ¼³Á¤ ½ÑÀ¥È£½ºÆà 03-05 158105
6 The 5 minute DBA: Default My.cnf File ½ÑÀ¥È£½ºÆà 03-06 27349
5 [Linux] Çϵå¿þ¾î Á¤º¸ È®ÀÎÇϱâ - dmidecode, lshw ½ÑÀ¥È£½ºÆà 03-06 222559
4 MS-SQL ¸®Çø®ÄÉÀÌ¼Ç (º´ÇÕº¹Á¦) Å×À̺í Ãß°¡ ¹æ¹ý ½ÑÀ¥È£½ºÆà 05-09 28184
 1  2  3  4  5  6