Shulou(Shulou.com)12/24 Report--

At the end of October 2023, MySQL 5.7 officially retired from the historical stage. As a free and open source version with global popularity, accounting for 43.4% of the total share of MySQL database and the most stable core, MySQL 5.7 has attracted wide attention in the industry since it announced its discontinuation date. The reason is not only that MySQL 5.7 has a large user base, but also that migrating MySQL 5.7 is not a simple system reinstallation, but requires arduous and arduous work such as replacing, adapting, migrating and restructuring the database and the application software and business systems loaded on it.

At the same time, MySQL5.7 shutdown means that users who continue to use it in the future do not meet the requirements of domestic open source technology applications, there may be large vulnerability risks, kernel-level failure problems cannot be solved, and technical sources for DBA support are reduced.

Therefore, how to realize application migration efficiently, safely and with low risk in compliance with policy compliance requirements has become the core demand of users.

For all of this, Wanli Database, as the original MySQL China R & D Center, perfectly inherits the most mature technical ecology, syntax and compatibility of MySQL technical route. It has prepared for a rainy day earlier, formulated a response solution, and officially launched the MySQL 5.7 service suspension solution zone on the official website to provide guarantee for user system security and business continuity.

Pay attention to [Wanli Database] Weixin Official Accounts, click "Service Suspension Scheme" in the menu bar to learn more

Why the Miles database?

Wanli Database was MySQL China R & D Center from 2006 to 2009, responsible for core code research and development, and has strong control over MySQL core source code.

On August 29, 2006, MySQL AB and Wanli Database jointly established MySQL China R & D Center and MySQL China Education Center under the auspices of MySQL founder David Axmark. MySQL China R & D Center, as an important part of MySQL global R & D team, participated in the latest MySQL product development at that time, marking the first time that Chinese technical team entered the core development field of internationally renowned open source basic software.

During the past 4 years, Wanli Database has continuously participated in the development of MySQL core code, fixed more than 100 NDB Cluster bugs and 300 Replication bugs respectively, completed the development of more than 10 NDB Cluster and 20 Replication new functions respectively, and completed the translation of MySQL version 5.1 Chinese reference manual.

On this basis, Wanli Database has precipitated MySQL technical capability system with seven modules in three dimensions: MySQL source service, MySQL operation and maintenance tools and MySQL support service, which can provide high-quality customized solutions for MySQL user database use, database migration, database operation and maintenance, database consultation and other problems.

MySQL source code service: Since 2006, MySQL China R & D Center, the predecessor of Wanli Database, as an important part of MySQL global R & D team, has made significant contributions to MySQL development, deeply controlling MySQL source code, and contributing 163504 lines of code. Wanli database deeply optimizes MySQL security code, adds a large number of security functions such as national secret support and audit enhancement, and improves MySQL official MGR and a series of functional features to meet the requirements of level scenario consistency. In addition, Wanli database has MySQL Bug hotfix repair capability, contributes Bug repair code to MySQL official community, and formulates a standard factory test process. In 2021, GreatSQL open source database, a domestic technology branch of MySQL led by Wanli Database, integrates two patches contributed by Huawei Kunpeng computing team (for OLTP and OLAP scenarios), showing excellent patch fusion capability.

MySQL O & M tool: GreatADM, a database O & M management platform built by Wanli Database, provides flexible graphical deployment methods and supports MySQL and other databases to realize the full lifecycle O & M management of databases from security deployment, O & M management, monitoring and alarm, operation analysis, log inspection to health assessment. GreatDTS, a data migration evaluation tool, is also available. It has migration evaluation, migration comparison, rapid heterogeneous migration, bidirectional synchronization and other functions. It can quickly realize the migration of stock data in the business system and enhance data synchronization, and the migration work can be evaluated and quantified.

MySQL Support Service: For MySQL open source database, Wanli Database can provide users with rich technical support services, including MySQL Expert Service and MySQL on-site technical service. It can also provide MySQL customized R & D services according to customers 'business scenario requirements, and can assist multiple customers to develop independent and secure relational database versions.

MySQL 5.7 is discontinued, what should I do?

Wanli Database is committed to creating a new generation of domestic database with "extreme stability, extreme performance and extreme ease of use." GreatDB, its security database, relies on its own core R & D capability, security capability, maintenance capability, customization capability and wide ecological adaptation, and has the ability to cope with the technical business impact and network security risks caused by MySQL5.7 shutdown, which can provide customers with a stable, reliable and compatible domestic database choice.

For users affected by the suspension of MySQL 5.7, Wanli Database has formulated solutions from four application scenario dimensions: migration requirements and unplanned migration.

On the one hand, for users with migration needs: Wanli Database divides the overall migration process into six stages: migration evaluation, scheme design, object migration, data migration, application adaptation and online operation. For each stage, it provides implementation suggestions based on Wanli database application practice experience, and provides migration evaluation tools and one-stop database operation and maintenance management platform.

Wanli Database provides four different migration steps and matching migration methods for four common application scenarios of full-volume import and export, MySQL source library, MySQL slave library and MySQL reverse synchronization.

On the other hand, for users who have no plans to migrate: Wanli Database can also provide a safe takeover solution for MySQL5.7 shutdown, providing users with safe technical takeover services, specifically including MySQL Expert Service and MySQL on-site technical service including technical consultation and support, 400 telephone consultation, on-site debugging, on-site service, etc., to ensure the safe and stable operation of the existing MySQL5.7 database system.

Stop taking is not terrible, how to deal with it is the key. At present, the MySQL 5.7 outage response solution launched by Wanli Database can assist MySQL users in many key industries such as operators and energy to complete the migration and replacement of business systems. In the future, MySQL users in thousands of industries will continue to be assisted to gradually complete database replacement wages, ensure the safe and stable operation of their databases, improve the operation efficiency of business systems, and assist users in their future development.

Pay attention to [Wanli Database] Weixin Official Accounts, click "Service Suspension Scheme" in the menu bar to learn more

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.