Development Resource set of MobiLink-brief introduction to the technology _ MySQL-mysql tutorial

Data Replication means that data is shared physically between completely different databases. When an application modifies shared data in any database, the changes are propagated to other databases in the replication system. A major advantage of the data replication system is that you can access data locally without connecting to a single central database (which may occupy a lot of resources and have low reliability ).

Data Replication means that data is shared physically between completely different databases. When an application modifies shared data in any database, the changes are propagated to other databases in the replication system. A major advantage of the data replication system is that it can access data locally, instead of getting data through a connection with a single central database (which may occupy a lot of resources, have low reliability and are slow. Data can be accessed locally even if there is no connection to the central server. in this way, data can still be accessed when the remote network connection is interrupted.

Sybase provides different replication technologies:

MobiLinkIt is a session-based technology used for bidirectional data replication between central unified databases and a large number of remote databases. It supports multiple unified database servers, including non-Sybase databases. Remote site management and resource requirements have been minimized, so it is very suitable for various mobile databases. After each synchronization session ends, these databases will be consistent.

Copy serverIt is a connection-based technology used for bidirectional Transaction replication. It is suitable for replication between a small number of enterprise databases connected by high-speed networks. Generally, each site has an administrator. In such systems, latency may be reduced to several seconds.

MobiLink is a component in SQL Anywhere and can be used in a replication system that meets the following requirements:

Large number of databasesMobiLink is used to support a large number of remote databases. In a single system, thousands of remote databases are supported.

Timed connectionYou can connect to or indirectly connect to the database in the network of the server from time to time. The scalability of MobiLink is limited only by the scalability of the unified database management system.

Flexible synchronization and schedulingTypically, applications are connected and synchronized at specified intervals (several minutes, hours, or days.

Low to medium capacityOnly one remote site can be prepared to download information at a time. In the MobiLink system, a large amount of data may lead to a long connection time, because the remote site cannot be disconnected before the synchronization is complete.

Heterogeneous databasesMobiLink supports the use of many commonly used relational databases as a unified database (Oracle, IBM DB2, ms SQL Server, Sybase ASE ). The remote site mode can be different from the unified database mode, because the synchronization process can be controlled by writing scripts.

The operation of MobiLink is to combine the results of multiple transactions in the remote database into a change set and then apply it to the unified database. Because synchronization is always performed at the transaction boundary, the integrity of the reference is maintained. The order of changes made during the component transaction process is not retained: because uncommitted data is never copied, data integrity is retained. Similarly, during data transmission, the user authorization, data compression and encryption measures are used to ensure the security of data during transmission.

A synchronization system consists of the following parts:

Unified databaseRefers to the enterprise's central database, which includes a centralized copy of all information in the synchronization system.