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

   
 
 
 

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

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

      ¾îÁ¦ : 804 ,¿À´Ã : 459
      Àüü : 1,256,236


     

 

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

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
¹øÈ£ Á¦   ¸ñ ±Û¾´ÀÌ ³¯Â¥ Á¶È¸
78 ¿ø°Ý¼­¹ö¿¡¼­ authorized_keys ·Î ÀÎÁõ¾ÈµÉ¶§ ½ÑÀ¥È£½ºÆà 07-31 27408
77 pptp vpn ¿¬°á¼­ 711 ¿À·ù ½ÑÀ¥È£½ºÆà 01-13 28040
76 ¹Ì¼ÒÄÉÀ̽º ½ÑÀ¥È£½ºÆà 07-30 28995
75 MS-SQL ¸®Çø®ÄÉÀÌ¼Ç (º´ÇÕº¹Á¦) Å×À̺í Ãß°¡ ¹æ¹ý ½ÑÀ¥È£½ºÆà 05-09 36432
74 [Linux] Çϵå¿þ¾î Á¤º¸ È®ÀÎÇϱâ - dmidecode, lshw ½ÑÀ¥È£½ºÆà 03-06 292497
73 The 5 minute DBA: Default My.cnf File ½ÑÀ¥È£½ºÆà 03-06 89987
72 [Àåºñ] OmniSwitch 6850-24x L2/L3 ½ºÀ§Ä¡ ¼³Á¤ ½ÑÀ¥È£½ºÆà 03-05 170718
71 MSSQL _Log.LDF ÆÄÀÏ »çÀÌÆ® Ä¿Á³À»¶§ Á¤¸®ÇÏ´Â ¹æ¹ý ½ÑÀ¥È£½ºÆà 02-20 25202
70 MSSQL¿¡¼­ DB º¹¿ø ÈÄ »ç¿ëÀÚ¿¡ ·Î±×ÀÎÀ̸§ÀÌ ¾ø¾î ¿À·ù°¡ ³ª´Â ¡¦ ½ÑÀ¥È£½ºÆà 02-19 26205
69 centos 6.2 oracle 10g ¼³Ä¡ (2) ½ÑÀ¥È£½ºÆà 12-17 407358
68 mysql Replicating ½ÑÀ¥È£½ºÆà 10-31 48600
67 PHP ¿Í MongoDB »ç¿ë¹ý ½ÑÀ¥È£½ºÆà 07-27 294223
66 ·¹À̾î Æ˾÷ - ´Ý±â&¿À´Ã ÇÏ·ç ¿­Áö ¾Ê±â ½ÑÀ¥È£½ºÆà 06-12 53624
65 backuppc ¼Ò½º¼³Ä¡ Çϱâ (1) ½ÑÀ¥È£½ºÆà 06-11 69598
64 rsyslog + LogAnalyzer ½ÑÀ¥È£½ºÆà 05-21 84639
 1  2  3  4  5  6