亚信科技

Recently, AsiaInfo Anhui Database Data Synchronization Platform fully met the Database Migration Tool Capability Requirements in the 17th batch of special tests of “Trusted Database” of CAICT, and became the first product to pass the standard test. Such achievement indicated that the professional and technical strength of Hunan AsiaInfo Anhui Technologies Co., Ltd. (“AsiaInfo Anhui”) in the field of database migration has been recognized by the industry, which fully proved that AsiaInfo Anhui can provide strong support and services for many enterprises that need database migration. 

Figure 1: Basic Competencies Specialized Test Certificate of Database Migration Tool 

Six Application Scenarios of Database Data Synchronization Platform 

AsiaInfo Anhui Database Data Synchronization Platform is a new generation of database migration and data synchronization replication product developed by AsiaInfo Anhui, which can integrate a complete set of migration solutions into the core products of native distributed RDBMS AntDB, and realize one-click evaluation, migration, audit and data validation capabilities for new multi-modal and multi-engine databases. In this evaluation, AsiaInfo Anhui Database Data Synchronization Platform adopted one-stop platform capability deeply integrated with AntDB. The application scenarios of this product are as follows: 

1. Data migration: Support data migration between isomorphic and heterogeneous data; Migrate from local database to cloud database.

  2. Data backup: Support the replication of production library; Support cross-platform replication which can be run under unix/linux/windows; Support the establishment of read-only replication library, realize the separation of reading and writing, and reduce the pressure of production library.

 3. Production expansion: Support the migration of single table data to shard table data in production library, and reduce the pressure on business systems.

 4. Data distribution: Support one extraction from the source database and distribute the extraction result to multiple target databases, support flexible distribution methods, and allow the distribution according to users and tables.

5. Real-time ETL: Support synchronization from Oracle, MySQL, PostgreSQL and AntDB to data warehouse, obtain data changes of business system in real time and synchronize in real time.

6. Remote disaster recovery: Support remote data synchronization and second-level incremental synchronization.

Core Advantages of Database Data Synchronization Platform 

AsiaInfo Anhui database data synchronization platform is suitable for a variety of data migration scenarios, including database collection, portrait analysis, environment detection, object compatibility evaluation and SQL code conversion. Whether it is a large-scale data center or a fast single point of backup, users can not only get all-round support and suggestions, but also better manage and migrate data. The core advantages are as follows: 

1. High performance real-time data processing 

Database data synchronization platform V2.1 adopts full synchronization and incremental loading mechanism to synchronize data. Based on AntDB log parsing capability, the platform can avoid the problem of slow loading of batch data by collecting data in second-level speed, and the throughput can be as high as 10W/ 

  2. Breakpoint continuation ability 

Breakpoint continuation is an important function to improve the efficiency and reliability of the transmission efficiency of data synchronization. AntDB supports breakpoint export when obtaining data from data sources, and performs operations through data playback, so that the whole migration process has the capability to continue transmission after interruption. 

3. One-click migration 

Database data synchronization platform V2.1 provides one-click data migration capability, which can actively judge migration risk points and optimize and adjust them through data migration evaluation, greatly reducing migration workload and risks. 

4. Visual operation and maintenance 

Through visual process management, users can intuitively understand the running status of the database, and operate and manage the daily operation and maintenance of the database conveniently. At the same time, the real-time monitoring alarm function can monitor the performance index of the database in real-time, and trigger the alarm immediately once an abnormal situation is found, so as to ensure the stable operation of the database. 

5. Data consistency 

The uniqueness of the collected data is guaranteed by the idempotence, which ensures that the data will not conflict or repeat in multiple operations so that the consistency and accuracy of the data will be ensured. At the same time, the SCN queue ensures the continuity of data, ensures the continuity and integrity of data in the process of collection, processing and storage, and avoids data loss or damage. In addition, task-level and full-scale audit are also important means to ensure data consistency. Through comprehensive inspection and verification of data, the accuracy and reliability of data are ensured, and high-quality database services are provided for users. 

About the Database Migration Tool Capability Requirements 

Database migration tool has always been an important tool for enterprises to promote digital intelligence and upgrade IT system. A mature migration tool can not only provide powerful basic functions and migration support, but also provide a complete and efficient application migration solution. 

The Database Migration Tool Capability Requirements includes 44 test items in five capability domains: basic functions, database object migration capability, data migration capability, data verification capability and migration evaluation capability, which are divided into 16 required options and 28 optional options. As the technical standard of the first database migration tool in the industry, Database Migration Tool Capability Requirements can provide a reference for the research, development, testing, and selection of database migration tools. 

Figure 2: Standard Framework of the Database Migration Tool Capability Requirements 

About AsiaInfo Anhui AntDB 

Established in 2008, AntDB provides online services to billions of users in 24 cities, provinces, and regions across the country on the core systems of service providers. It has product features such as high performance, elastic scalability, and high reliability. It can handle millions of core communications transactions per second at peak values, ensuring the continuous and stable operation of the system for nearly a decade, and has been successfully commercialized in industries such as communications, finance, transportation, energy sources, and the IoT.