1、ORACLE DATAGUARD
Advantages:
Comes with enterprise edition.
There is no extra charge.
Logical mode can realize real-time synchronization.
There are two logical and physical protection methods.
Can switch between the main library and the standby library.
Support breakpoint continuation
Disadvantages:
Physical mode target library is not available.
The logical mode does not support large objects, and the physical mode is not real-time.
The source and destination cannot be different operating systems and different versions.
Resynchronization is very complicated.
The bandwidth requirement is high, so archive mode needs to be turned on.
It is risky to ask DBA to operate the production library.
If the user needs to use the database for 24 hours, it can't be satisfied before the version of11g.
2、HVR
Advantages:
Support various traditional relational databases, such as Oracle, SQL Sever, DB2, Ingres and PostgreSQL.
Support replication to big data platforms such as Taradata, Greenplum and Hadoop HDFS.
Support AWS, Azure, Salesforce and other cloud platforms.
At the same time, it also supports file (directory /ftp/sharepoint) copying.
Support log-based data capture and trigger-based data capture.
Target data available
The source system and the target system are heterogeneous.
You can choose to copy the content.
The data transmission process supports compression and encryption.
Provide online initialization synchronization
Support data online comparison and repair.
Complex scenes such as one-to-many and many-to-one can be realized.
Support breakpoint continuation
Support data conversion
Graphical management and monitoring interface, unified management of all skin links.
Disadvantages:
Separate payment license
Listeners should be installed in both the main library and the standby library, which has little impact on the business system.
Archive mode needs to be turned on
3. Kinmen, Oracle Bone Inscriptions
Advantages:
Target data available
The source system and the target system are heterogeneous.
You can choose to copy the content.
Save bandwidth
Uninterrupted initialization
The protection time is in seconds.
Can realize one-to-many and many-to-one
The changed data is compressed, occupying little space.
Support breakpoint continuation
Disadvantages:
Separate payment license
Both the main library and the standby library need to install programs, which will affect the business system.
Archive mode needs to be turned on
4、QUEST SHAREPLEX
Advantages:
Target data available
The source system and the target system are heterogeneous.
You can choose to copy the content.
Save bandwidth
Uninterrupted initialization
The protection time is in seconds.
Disadvantages:
Copying a table build statement requires modifying the configuration file.
Viewing transactions is not supported.
There is no local service and the price is high.
Maintenance workload is greater than DATAGUARD.
5. Woxin Technology Packaging
Advantages:
Target data available
The source system and the target system are heterogeneous.
Save bandwidth, and the minimum bandwidth supports satellite 56K.
Uninterrupted initialization, business system does not stop.
Hypertext transfer protocol (abbreviation of Hyper Text Transport Protocol)
Independent server mode, without installing any programs in the main library and standby library.
The protection time is in seconds.
Support transaction viewing.
The installation is simple, and the hardware and software performance of the main and standby machines are not affected.
Most DDL and DML statements are supported.
Support large objects and OIT tables.
Support synchronous log auditing
Disadvantages:
Non-international brands
Currently, one to many and many to one are not supported.
Need to buy separately
6. Beer
Advantages:
Target data available
The source system and the target system are heterogeneous.
Uninterrupted initialization, business system does not stop.
Hypertext transfer protocol (abbreviation of Hyper Text Transport Protocol)
Independent server mode, without installing any programs in the main library and standby library.
The protection time is in seconds.
Support replication filtering based on users, tables and other objects.
Support one-to-many, many-to-one and two-way replication.
The installation is simple, and the hardware and software performance of the main and standby machines are not affected.
Support main warehouse transaction audit
Disadvantages:
Non-international brands
Need to buy separately