Access process

Prerequisites

  1.     The middleware can make a custom mapping of table fields, table names, and schema names, and supports inconsistent default conversion of source and destination end table field data types, and supports field filtering;
  2.     Support for custom business logic by implementing interfaces (already the demand side is doing custom business logic work).

Prepare

Mysql to relational database synchronization

  1.     Source:
  2.         Table structure information:
  3.             schema name
  4.             table name
  5.             When the source targets are inconsistent, a mapping relationship is required.
  6.             Primary key (required)
  7.             Update time field (not required, if there is no source, the number of data on the target side is checked)
  8.         bin-log:
  9.             ROW format
  10.         Database connection information:
  11.             It is not required. If it is not provided, the source and destination data will not be checked.
  12.         Data extraction connection information:
  13.             Mysql account with replication privileges
  14.     Target:
  15.         Table structure information : same as Source
  16.         Target database connection information    
  17.         If it is mysql, it is not case sensitive (temporarily not case sensitive)

Oracle to relational database synchronization

  1.     Source:
  2.         Operation and Maintenance Engineer cooperate with OGG configuration.
  3.         Table structure information:
  4.             schema name
  5.             table name
  6.             When the source targets are inconsistent, a mapping relationship is required.
  7.             Primary key (required)
  8.             Update time field (not required, if there is no source, the number of data on the target side is checked)
  9.         Database connection information:
  10.             It is not required. If it is not provided, the source and destination data will not be checked.
  11.     Target:
  12.         Table structure information : same as Source
  13.         Target database connection information    
  14.         If it is mysql, it is not case sensitive (temporarily not case sensitive)

Custom sync

  1.     See the plugin development chapter for details.

Process

  1.     Involving custom business logic, it is necessary to advance the docking plug development work (developed by the demand side) to audit the custom logic code in the multi-threaded concurrent environment;
  2.     If the custom business logic is not involved, the deployment period is completed within 1 day. The time is uncontrollable due to parameter synchronization.

Environmental deployment

Development environment

  1.     Use the hardware resources of the demand side to assist in deployment.

test environment

  1.     In a short period of time, the existing hardware can carry the test available architecture resources, and use up the destruction.

Production Environment

  1.     Unified deployment, separately applying hardware resources to access data synchronization clusters.
  2.     Can be deployed separately if there are special needs.

Business development support

  1.     Help documentation:
  2.         See the plugin development chapter.