Shareplex three-point synchronization Configuration

I. Preparations

Master/Slave Type	System Version	Database Version	Host address	Host Name
Source database	Centos6.4 x86_64	11.2.0.4.0	192.168.3.230	Dbshareplex
Target Database	Centos6.4 x86_64	11.2.0.4.0	192.168.3.223	Dbshareplexbk
Target database 2	Centos6.4 x86_64	11.2.0.4.0	192.168.3.249	Dbshareplexbk2

Ii. install and configure shareplex

Reference deployment document

 

3. Implementation of three-point Synchronization

In fact, you only need to add the Host Name and Sid of the second configuration file to the configuration file in shareplex. The details are as follows:

Datasource: O. dbshareplex

Expand new8910. % new8910. % [email protected] + [email protected]

Use "+" to connect the target and target, with spaces in the middle

 

Iv. Problems Encountered

At the time of operation, the error "cannot connect to host on dbshareplexbk2: No route to host" always exists.

In addition, only one target database can be pinged, and then dbshareplexbk2 1521 cannot be pinged.

But 2188 is normal.

Dbshareplexbk2 information is also found in the ARP-a table, which can basically eliminate network problems.

It may be a firewall problem. After the firewall is disabled, it still does not work. Finally, Baidu finds a command iptables-F to clear the firewall rules. After the command is cleared, the error message disappears and the synchronization is normal.

Shareplex three-point synchronization Configuration