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

   
 
 
 

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

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

      ¾îÁ¦ : 304 ,¿À´Ã : 211
      Àüü : 1,127,501


     

 

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

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 23515
77 pptp vpn ¿¬°á¼­ 711 ¿À·ù ½ÑÀ¥È£½ºÆÃ 01-13 24190
76 ¹Ì¼ÒÄÉÀ̽º ½ÑÀ¥È£½ºÆÃ 07-30 25106
75 MS-SQL ¸®Çø®ÄÉÀÌ¼Ç (º´ÇÕº¹Á¦) Å×À̺í Ãß°¡ ¹æ¹ý ½ÑÀ¥È£½ºÆÃ 05-09 27615
74 [Linux] Çϵå¿þ¾î Á¤º¸ È®ÀÎÇϱâ - dmidecode, lshw ½ÑÀ¥È£½ºÆÃ 03-06 221711
73 The 5 minute DBA: Default My.cnf File ½ÑÀ¥È£½ºÆÃ 03-06 26805
72 [Àåºñ] OmniSwitch 6850-24x L2/L3 ½ºÀ§Ä¡ ¼³Á¤ ½ÑÀ¥È£½ºÆÃ 03-05 157359
71 MSSQL _Log.LDF ÆÄÀÏ »çÀÌÆ® Ä¿Á³À»¶§ Á¤¸®ÇÏ´Â ¹æ¹ý ½ÑÀ¥È£½ºÆÃ 02-20 21937
70 MSSQL¿¡¼­ DB º¹¿ø ÈÄ »ç¿ëÀÚ¿¡ ·Î±×ÀÎÀ̸§ÀÌ ¾ø¾î ¿À·ù°¡ ³ª´Â ¡¦ ½ÑÀ¥È£½ºÆÃ 02-19 23064
69 centos 6.2 oracle 10g ¼³Ä¡ (2) ½ÑÀ¥È£½ºÆÃ 12-17 328227
68 mysql Replicating ½ÑÀ¥È£½ºÆÃ 10-31 29734
67 PHP ¿Í MongoDB »ç¿ë¹ý ½ÑÀ¥È£½ºÆÃ 07-27 98277
66 ·¹ÀÌ¾î ÆË¾÷ - ´Ý±â&¿À´Ã ÇÏ·ç ¿­Áö ¾Ê±â ½ÑÀ¥È£½ºÆÃ 06-12 44473
65 backuppc ¼Ò½º¼³Ä¡ Çϱâ (1) ½ÑÀ¥È£½ºÆÃ 06-11 61624
64 rsyslog + LogAnalyzer ½ÑÀ¥È£½ºÆÃ 05-21 55094
 1  2  3  4  5  6