哪位大哥幫忙講解一下建表時(shí),data capture none是什么意思?

daliwa

哪位大哥幫忙講解一下建表時(shí),data capture none是什么意思?
謝謝!

huyuhui001

是對(duì)使用數(shù)據(jù)復(fù)制的Capture進(jìn)程使用的。用來(lái)捕捉這個(gè)table的sql變化，記入log，以同步目標(biāo)table。

daliwa

那么data capture none的意思,就是這個(gè)表不用做同步了?
不知你有沒(méi)同步的經(jīng)驗(yàn)?
能大概說(shuō)明一下怎么實(shí)現(xiàn)庫(kù)的同步嗎?
或是給點(diǎn)資料的鏈接也行
謝謝

huyuhui001

db2e0e80-Replication Guide and Reference.pdf
看這本書

daliwa

3ks

mymm

1. DATA CAPTURE
   
2. Indicates whether extra information for inter-database data replication is to be written to the log. This clause cannot be specified when creating a subtable (SQLSTATE 42613).
   
3. If the table is a typed table, then this option is not supported (SQLSTATE 428DH or 42HDR).
   
4. 
   
5. 
   
6. NONE
   
7.         Indicates that no extra information will be logged.
   
8. 
   
9. CHANGES
   
10.         Indicates that extra information regarding SQL changes to this table will be written to the log. This option is required if this table will be replicated and the Capture program is used to capture changes for this table from the log.
    
11. If the table is defined to allow data on a partition other than the catalog partition (multiple partition nodegroup or nodegroup with a partition other than the catalog partition), then this option is not supported (SQLSTATE 42997).
    
12. 
    
13. If the schema name (implicit or explicit) of the table is longer than 18 bytes, then this option is not supported (SQLSTATE 42997).
    
14. 
    
15. Further information about using replication can be found in the Administration Guide and the Replication Guide and Reference.

復(fù)制代碼