Shulou(Shulou.com)05/31 Report--

This article focuses on "analyzing the process of database migration cloud solution". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "analyze the database migration cloud solution process"!

Oracle is a very powerful comprehensive database, but it also has some disadvantages, such as the use of centralized architecture, can not achieve good scale-out, and its stability depends on hardware. Due to the needs of architecture upgrading, cost reduction and cloud, more and more enterprises need to "de-Oracle".

1. Overview of Oracle data migration to the cloud

As we all know, Oracle is a very powerful comprehensive database, but Oracle also has some disadvantages, for example, because of the centralized architecture, it can not achieve scale-out well, and its stability depends on hardware, such as minicomputer that needs IBM, storage of EMC and so on.

In addition, there is technology dependence on Oracle database, and many users like to use PL/SQL when developing, so when upgrading the database isomerism or transforming the architecture, they have to solve the problem of technology dependence of Oracle.

At the same time, the cost of Oracle database is high, the use of Oracle database needs to be matched with the corresponding minicomputer and storage, and it is often difficult to achieve large-scale management.

2. Database & application cloud migration process

Enterprises often need to do "de-O" for the needs of architecture upgrading, cost reduction and cloud. The "go to O" is generally divided into the following steps.

The first step: evaluate the migration scheme, analyze how to migrate the database and applications, and choose which database to replace. In this process, we need to store a lot of knowledge, analyze the relationship between all the data objects and applications of the existing Oracle database, and judge whether the target database is compatible and whether the migration scheme is feasible.

It is difficult to choose a suitable target database to replace the existing Oracle database, because it is impossible to determine the change of performance and load when replacing Oracle with databases such as MySQL and PostgreSQL, and can only be done through continuous testing.

In addition, we also need to avoid the risk of heterogeneous migration as far as possible, and we need to ensure that applications and databases can be well adapted after migration.

Step 2: database and application transformation, database switching is bound to be incompatible, and the incompatibility here will be the "last kilometer" of database and application architecture transformation. Only when the "last kilometer" is completed can the whole migration plan be completed. In this part, we need to consider the transformation scheme for the database and applications.

Step 3: with the splicing of databases and applications, it is easy to migrate all the data, but the incremental migration of heterogeneous databases may be difficult, because it will involve a large number of data changes, frequent DDL, and even differences in database data types and precision, which are great challenges for migration.

Finally: database and application migration evaluation, including database escort, because Oracle performance is very powerful. Therefore, it is necessary to ensure that after migrating to other databases, the performance can still meet the needs of the business system.

In the escort phase, we need to consider how to deal with emergencies, how to fall back, and how to switch in the face of the complex relationship between databases and applications.

Comprehensive carding of architecture

For most enterprises, there may be not only one set of Oracle database, but also more than one set of applications, and there may be various relationships between database and database, application and application, application and database, but the enterprise does not have a comprehensive architecture diagram or architecture document to record these contents, so it is necessary to clarify the relationship between database and application to facilitate the planning of database and application heterogeneous transformation route.

Database scene carding

In addition, we need to clarify whether the current business situation of Oracle database is a mixed scenario of OLTP, OLAP or TP and AP. Only in this way can we select the target database and plan the replacement plan.

Reform content

There are many grammatical difficulties in database transformation, first of all, syntax conversion is needed. Because different database engines support different syntax, you need to convert the syntax of DML, DDL, and SQL. Second, you need to convert the application code, because in some cases, SQL statements are embedded in the program, and you may need to check and modify the SQL statements line by line for millions of lines of code, which is not only a lot of work, but also time-consuming.

Determine the transformation plan

After compiling the migration plan of database and application architecture, we also need to sort out the transformation points and function points one by one and test them one by one, so that the preliminary preparation of the whole de-O process takes a long time and a lot of energy.

3. Database migration cloud solution

As we all know, Alibaba is one of the first companies in China to practice the concept of going to IOE. At that time, Ali's road to IOE was not so smooth, encountered a lot of difficulties, stepped on a lot of pits, and precipitated a lot of experience, forming the best solution for today's database migration cloud.

Oracle database and application heterogeneous migration pain point

Full Link Scheme for heterogeneous Migration of Oracle databases and applications to the Cloud

Aliyun condensed the experience of database migration to the cloud into database and application migration (ADAM) products. ADAM can help us analyze the architecture of the whole IT system and provide suggestions for the selection of the target database for migration.

Two database migration solutions are recommended for ADAM products. The first is a smooth OLTP migration solution. The target database is POLARDB syntax compatible with Oracle, so you can directly migrate to Aliyun or offline POLARDB Box integrated machines with only a few changes. The scheme is characterized by compatibility, adaptation, flexible expansion and overall cost.

The second is the OLAP data warehouse cloud solution, which can be migrated to Aliyun's ADB for PG for the Oracle database that provides several warehouse services. The focus of this solution is on the transformation of Oracle analytical SQL and the ability to achieve real elastic expansion on the cloud, as well as cost reduction.

The heterogeneous migration of Oracle database and application is divided into six steps, namely, data collection, database intelligent analysis, application evaluation and analysis, database and application transformation, project implementation and splicing escort.

Full-chain solution tools for heterogeneous migration of databases and applications

ADAM also provides a full-process solution tool for heterogeneous migration of databases and applications. ADAM SaaS is the Oracle migration evaluation brain, providing professional, rich and visual database and application evaluation services, static or dynamic interactive reports, application transformation management, and support for automatic generation of test migration plans.

ADAM Studio is an Oracle migration transformation product, which can provide a stable and easy-to-use database migration test and transformation tool set, support the automatic generation of splicing migration plan, and realize the automatic synchronization of simulation and splicing environment plan. DSG for ADMA is an ADAM certified Oracle migration splicing and synchronization product, which can provide stable and reliable data migration and verification toolkits. With ADAM migration plan as the core, it provides scene-based, process-oriented and automated full data migration, incremental migration, data verification and data correction capabilities. DTS is a data transfer tool for Ali Cloud Database, which also supports data exchange between data sources and can help users to migrate data in full and increments.

Key technologies of ADAM

The core of ADAM is intelligent collection, intelligent evaluation, intelligent transformation and supporting tools. Intelligent acquisition does not need to collect the contents of database and application programs artificially, to collect agent products to achieve automatic collection, and the data will fall to the local after collection, ensuring the data security of the core assets. Intelligent evaluation will compare the performance and syntax of different databases one by one, and recommend target database selection, database generation and application heterogeneous migration solutions. With the help of supporting tools and intelligent transformation system, the transformation process can be completed quickly, for example, the transformation period can be shortened from 6 months to 1 month. ADAM products divide the difficulty of database object transformation into four levels according to database compatibility, and deal with them differently.

In addition, ADMA also provides ADMA studio to achieve structure migration and data pre-migration, SQL online translation tools can convert SQL statements of Oracle into SQL statements of other databases, PL/SQL to Java tools can convert PL/SQL language to Java language, in addition, there are SQL test tools and ADAM certification migration tools.

4. Best practices

Suggestions on cloud selection of database migration

According to how many Oracle features are used, Oracle databases are divided into two categories, weak O and strong O. For the former, a quick cloud deployment solution is recommended. Because fewer Oracle features are used, you can quickly migrate to the open source database MySQL or PostgreSQL to reduce costs.

The latter uses more Oracle features, so the POLARDB Oracle compatible version is recommended. ADAM provides a full-link migration solution. If you want to achieve the overall architecture upgrade, you can also directly restructure the business, achieve the micro-service division of the business and the database sub-table, and then quickly realize the architecture transformation of the IT system.

POLARDB cloud native distributed relational database architecture is completely autonomous and controllable.

POLARDB database has many advantages, such as storage and computing separation, RPO=0, automatic read-write separation, data-driven, hardware / software collaboration, and support for multi-mode data. POLARDB is a true cloud native distributed relational database with a completely autonomous and controllable architecture.

POLARDB BOX all in one machine

Some financial enterprises may have high requirements for database supervision, so Aliyun also provides an all-in-one POLARDB BOX, which enables enterprises to enjoy the technical dividend of cloud native database in the offline computer room. Bring the cloud database to the offline data center, and make full use of the management, control and performance convenience brought about by DBaaS.

AnalyticDB for PostgreSQL database

For data warehouse scenarios, Aliyun AnalyticDB for PostgreSQL can well support big data processing and achieve real dynamic horizontal expansion.

5. Suggestions for enterprises to move to the cloud isomerous

The cloud migration process of Oracle database needs a complete set of methodologies and products to help achieve architecture evaluation, database selection, migration evaluation and database application transformation, to help achieve application decoupling, and professional services to help achieve real zero downtime migration, and finally achieve enterprise heterogeneous migration cloud.

At this point, I believe you have a deeper understanding of the "analysis database migration cloud solution process", might as well come to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.