Shulou(Shulou.com)06/02 Report--

? Project background in recent years, in the tide of digital transformation of the banking industry, the database market is undergoing subtle changes. While the commercial database giants represented by Oracle continue to make important contributions in the banking industry, the banking industry begins to try the application scenario of open source database. In infrastructure selection, the database is the core component. Among them, the most popular relational database system, MySQL, plays a positive role in the field of open source database because of its advantages such as easy to use, mature and stable, low operating cost, suitable for business scenarios and so on.

In the new financial ecological pattern, to better serve customers in the financial field through the Internet, and to effectively solve customers' technical pain points through products and timely service has always been the service mode and purpose pursued by Yunqu. In order to meet the requirements of the rapid innovative development of Internet financial business, the cloud technology database team relies on rich database best practices, performance optimization and cloud experience to ensure the smooth launch of the new system.

? Type selection and realization

Looking to the future, it is based on many new features of MySQL 8.0 and is more conducive to cloud services. At the same time, in line with the principle of simple, uncomplicated, more familiar and more convenient for development, we choose the read-write separation middleware + MySQL 8.0.20 MGR cluster database architecture. MGR is a database solution with high availability and high expansion introduced by MySQL officially in version 5.7.17, based on the distributed paxos protocol and provided in the form of plug-ins. Really ensure data consistency at the MySQL cluster level (different from MHA). Due to the heavy use of class refactoring code in version 8.0, third-party open source branches have been hit hard to keep up with the 8.0 code structure.

? Customer income

During the launch of the support, Yunqu database team made fine adjustments to the database operating system parameters, such as NUMA, to ensure the normal operation of the system, refined analysis of database IO, memory, CPU resources, and adjustments to sql statements.

The smooth launch of the new system has greatly reduced the science and technology costs of small and medium-sized banks, reduced corporate costs, and also met the requirements of the current environment for banking infrastructure. At the same time, it once again confirms the technical strength of the Yunqu database team.

About Yunqu

Zhejiang Yunqu Network Technology Co., Ltd. is an IT company that provides professional high-tech services. We focus on high-end database and automated operation and maintenance services, we have worked in the original ORACLE factory senior experts and BAT Internet companies, operators and other technical experts team, the use of years of practice and operation and maintenance experience to provide customers with a complete set of solutions, committed to traditional industries, Internet enterprises to provide professional database systems and automation operation and maintenance related services and products.

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.