In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Data distribution configuration is an one-to-many configuration scheme. OGG supports synchronizing source libraries to multiple target systems.
Considerations for data distribution configuration:
If the delivery process (data pump) finds a failure in the network connection of the target library during the data transmission, the captured data will continue to be sent like other targets. On the source side, an initial extraction group (extractgroup) and a delivery group (data pump extractgroup) are used to correspond to multiple target databases.
Create a data distribution structure
Source-end system
Configuration management process
1. Configure the management process on the source side. See [goldengate] official documentation Note 1.
Http://blog.itpub.net/29047826/viewspace-1249506/
2. In the management process parameter file, use the PURGEOLDEXTRACTS parameter to control the cleanup of the local trail file.
Configure the primary extraction process
3. On the source side, use the ADD EXTRACT command to create a primary extraction group. Here we call it ext.
ADD EXTRACT, {TRANLOG | INTEGRATED TRANLOG}, BEGIN, [, THREADS]
4, on the source side, use the ADD EXTTRAIL command to create a local trail
ADD EXTTRAIL, EXTRACT
Use the parameter EXTRACT to link the extraction group ext and trail. The extraction group writes the information to the trail, and the delivery group reads from the trail.
5. On the source side, use the EDIT PARAMS command to create a parameter file for the primary extraction group.
-- Identify the Extract group:EXTRACT
-- Specify database login information as needed for the database:
[SOURCEDB] [, USERID] [, PASSWORD []]
-- Specify the local trail that this Extract writes to
-
-and encryption options:
ENCRYPTTRAIL EXTTRAIL
-- Specify tables to be captured:
TABLE.
EXTTRAIL is used to specify the local trail configuration data pump delivery group
On the source side, use the ADD EXTRACT command to create a data pump for each target system. Here we call it pump_1,pump2.
ADD EXTRACT, EXTTRAILSOURCE, BEGIN
ADD EXTRACT, EXTTRAILSOURCE, BEGIN
The EXTRACT parameter is used to connect the remote trail to different delivery groups. The specified delivery group writes the information to the corresponding trail file.
8. On the source side, use the EDIT PARAMS command to create a parameter file for each data pump extraction group.
Data pump_1
-- Identify the data pump group:
EXTRACT
-- Specify database login information if using NOPASSTHRU:
[SOURCEDB] [, USERID] [, PASSWORD []]
-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL
-- Specify the name or IP address of the first target system
-- and optional encryption of data over TCP/IP:
RMTHOST, MGRPORT, ENCRYPT
-- Specify remote trail and encryption options on first target system:
ENCRYPTTRAIL
RMTTRAIL
-Allow mapping, filtering, conversion or pass data through as-is:
[PASSTHRU | NOPASSTHRU]
-- Specify tables to be captured:
TABLE.
Data pump_2
-- Identify the data pump group:
EXTRACT-Specify database login information if using NOPASSTHRU:
[SOURCEDB] [, USERID] [, PASSWORD []]
-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL
-- Specify the name or IP address of the second target system
-- and optional encryption of data over TCP/IP:
RMTHOST, MGRPORT, ENCRYPT
-- Specify remote trail and encryption options on second target system:
ENCRYPTTRAIL RMTTRAIL
-Allow mapping, filtering, conversion or pass data through as-is:
[PASSTHRU | NOPASSTHRU]
-- Specify tables to be captured:
TABLE.
Target system
Configuration management process
9. Configure the management process on the source side. See [goldengate] official documentation Note 1.
Http://blog.itpub.net/29047826/viewspace-1249506/
10. In the management process parameter file, use the PURGEOLDEXTRACTS parameter to control the cleanup of the local trail file.
Configure replication group
11, create a replication checkpoint table (Replicat checkpoint table) separately on each target system
12. On each target system, use the ADD REPLICAT command to create a replication group (Replicat group) for trail on each remote system. Here we call it rep_1,rep_2.
Target_1
ADD REPLICAT, EXTTRAIL, BEGIN
Target_2
ADD REPLICAT, EXTTRAIL, BEGIN
The EXTTRAIL parameter is used to connect the replication group to the correct trail. 13. On each target system, use the EDIT PARMAS command to create an extraction group parameter file.
Target_1
-- Identify the Replicat group:
REPLICAT
-- State whether or not source and target definitions are identical:
SOURCEDEFS | ASSUMETARGETDEFS
-- Specify database login information as needed for the database:
[TARGETDB] [, USERID] [, PASSWORD []]
-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL
-- Specify error handling rules:
REPERROR (,)
-- Specify tables for delivery:
MAP., TARGET. [, DEF]
Target_2
-- Identify the Replicat group:
REPLICAT
-- State whether or not source and target definitions are identical:
SOURCEDEFS | ASSUMETARGETDEFS
-- Specify database login information as needed for the database:
[TARGETDB] [, USERID] [, PASSWORD []]
-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL
-Specify error handling rules:REPERROR (,)
-- Specify tables for delivery:
MAP., TARGET. [, DEF]
You can use multiple MAP statements for replication groups. These MAP statements must specify the objects contained in the same trail connected to the group.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.