Database Replication and Clustering
The setupCDC.sh script configures an Oracle database with the necessary CDC tables to enable heterogeneous replication from Oracle to MySQL.
The script accepts one argument, the filename of the configuration file that
will define the CDC configuration. The file accepts the parameters as listed
in Table 8.33, “setupCDC.conf Configuration Options”.
Table 8.33. setupCDC.conf Configuration Options
| CmdLine Option | INI File Option | Description |
|---|---|---|
cdc_type | cdc_type | The CDC type to be used to extract data, either synchronous (using triggers) or asynchronous (using log processing). |
delete_publisher | delete_publisher | Whether the publisher user should be deleted. |
delete_subscriber | delete_subscriber | Whether the subscriber user should be deleted. |
pub_password | pub_password | The publisher password that will be created for the CDC service. |
pub_user | pub_user | The publisher user that will be created for this CDC service. |
service | service | The service name of the Tungsten Replicator service that will be created. |
source_user | source_user | The source schema user with rights to access the database. |
specific_path | specific_path | The path where the tungsten.tables file is located; the file must be in a shared location accessible by Tungsten Replicator. |
specific_tables | specific_tables | If enabled, extract only the tables defined within a tungsten.tables file. |
sys_pass | sys_pass | The system password to connect to Oracle as SYSDBA. |
sys_user | sys_user | The system user to connect to Oracle as SYSDBA. |
tungsten_pwd | tungsten_pwd | The password for the subscriber user. |
tungsten_user | tungsten_user | The subscriber (Tungsten user) that will subscribe to the changes and read the information from the CDC tables. |
Where:
| Option | cdc_type | |
| Config File Options | cdc_type | |
| Description | The CDC type to be used to extract data, either synchronous (using triggers) or asynchronous (using log processing). | |
| Value Type | string | |
| Valid Values | CDCASYNC | Enable asynchronous capture |
| CDCSYNC | Enable synchronous capture | |
The CDC type to be used to extract data, either synchronous (using triggers) or asynchronous (using log processing).
| Option | delete_publisher | |
| Config File Options | delete_publisher | |
| Description | Whether the publisher user should be deleted. | |
| Value Type | string | |
| Valid Values | 0 | Do not the delete the user before creation |
| 1 | Delete the user before creation | |
Whether the publisher user should be deleted.
| Option | delete_subscriber | |
| Config File Options | delete_subscriber | |
| Description | Whether the subscriber user should be deleted. | |
| Value Type | string | |
| Valid Values | 0 | Do not the delete the user before creation |
| 1 | Delete the user before creation | |
Whether the subscriber user should be deleted.
| Option | pub_password | |
| Config File Options | pub_password | |
| Description | The publisher password that will be created for the CDC service. | |
| Value Type | string | |
The publisher password that will be created for the CDC service.
| Option | pub_user | |
| Config File Options | pub_user | |
| Description | The publisher user that will be created for this CDC service. | |
| Value Type | string | |
The publisher user that will be created for this CDC service.
| Option | service | |
| Config File Options | service | |
| Description | The service name of the Tungsten Replicator service that will be created. | |
| Value Type | string | |
The service name of the Tungsten Replicator service that will be created.
| Option | source_user | |
| Config File Options | source_user | |
| Description | The source schema user with rights to access the database. | |
| Value Type | string | |
The source schema user with rights to access the database.
| Option | specific_path | |
| Config File Options | specific_path | |
| Description | The path where the tungsten.tables file is located; the file must be in a shared location accessible by Tungsten Replicator. | |
| Value Type | string | |
The path where the tungsten.tables file is located; the file must be in a shared location accessible by Tungsten Replicator.
| Option | specific_tables | |
| Config File Options | specific_tables | |
| Description | If enabled, extract only the tables defined within a tungsten.tables file. | |
| Value Type | string | |
| Valid Values | 0 | Extract all tables |
| 1 | Use a tables file to select tables | |
If enabled, extract only the tables defined within a tungsten.tables file.
| Option | sys_pass | |
| Config File Options | sys_pass | |
| Description | The system password to connect to Oracle as SYSDBA. | |
| Value Type | string | |
The system password to connect to Oracle as SYSDBA.
| Option | sys_user | |
| Config File Options | sys_user | |
| Description | The system user to connect to Oracle as SYSDBA. | |
| Value Type | string | |
The system user to connect to Oracle as SYSDBA.
| Option | tungsten_pwd | |
| Config File Options | tungsten_pwd | |
| Description | The password for the subscriber user. | |
| Value Type | string | |
The password for the subscriber user.
| Option | tungsten_user | |
| Config File Options | tungsten_user | |
| Description | The subscriber (Tungsten user) that will subscribe to the changes and read the information from the CDC tables. | |
| Value Type | string | |
The subscriber (Tungsten user) that will subscribe to the changes and read the information from the CDC tables.
To use, supply the name of the configuration file to setupCDC.sh:
shell> ./setupCDC.sh sample.conf