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

Hankou Bank is a city commercial bank, focusing on science and technology, people's livelihood and other fields in recent years. In the transformation of database localization, Hankou Bank introduces TiDB database and applies it to the important business system: position system, which realizes stack data service, meets the requirements of high concurrency, low delay, data consistency and high availability, and solves the limitations of traditional database.

Hankou Bank is a city commercial bank headquartered in Wuhan, with 201 branches. In recent years, through professional operation and fine management, Hankou Bank strives to cultivate and shape business characteristics in science and technology, people's livelihood, small and micro, Internet and other fields, and the ability of sustainable development continues to be enhanced. Hankou Bank has been one of the top 500 global banks since 2010, according to Banker magazine. Hankou Bank has been awarded the honor of China's top ten city commercial banks, excellent competitive brand construction bank, best science and technology service bank and so on.

After years of polishing, domestic database has a mature and sustainable development ecology, and is widely used in banking, insurance and other enterprises. Under the guidance of business development planning, Hankou Bank started the transformation of database localization earlier, made a clear plan for all kinds of systems in the bank, and began to explore and try some scenarios.

The position system is one of the important business systems of Hankou Bank. by monitoring the current position level and the factors that affect the position change, the position system realizes the electronic forecast of large position, the automation of position correction, and the computerization of allocation and examination and approval process. provide fund business maturity query, historical fund transaction query, currency desk fund transaction query and so on. Position system is a typical mixed HTAP scenario with both online transactions and online analysis. the product capability and service capability of TiDB database are recognized by the bank during the landing of the project.

Hankou Bank builds TiDB master / standby cluster to provide one-stack data services for the position system, uses TiDB to complete online transaction processing in massive data scenarios, provides scalable, unlimited real-time writing and real-time query capabilities, meets the requirements of high concurrency, low latency, data consistency and high availability, and thoroughly solves the problems of low concurrency, non-linear expansion and poor analysis ability of traditional databases.

Why choose TiDB?

The native distributed architecture is transparent to the business and convenient for application development.

The native distributed architecture design of TiDB computing and storage separation can flexibly expand computing or storage nodes, support automatic sharding and the sharding strategy does not require prior intervention and design, which is very convenient for business development, especially in scale-up scenarios. Compared with the distributed database based on sub-database and sub-table architecture, the advantage is more obvious.

Class high availability

Each component of TiDB adopts redundant design, and three copies of data are used. The consistency and high availability of data of each copy are ensured by Multi Raft protocol. Disaster recovery clusters can be built between clusters through TiCDC or TiDB binlog to ensure high availability of cluster level. TiDB provides two centers, two places and three centers and other highly available disaster recovery solutions to meet the organization's requirements for the ultimate RPO and RTO.

Innovative HTAP capability, the performance advantage of complex SQL is obvious

For multi-table join, complex analysis and run-batch scenarios, if the analysis library is built separately, the data processing process becomes longer and the complexity of the system is increased. You only need to add TiFlash nodes to the TiDB cluster to obtain the HTAP capability, which provides excellent performance for the query performance of complex SQL. The application does not need to develop two sets of programs and is equipped with two sets of technology stacks.

Comprehensive localization and ecological compatibility

TiDB is compatible with mainstream domestic servers, domestic chips, domestic operating systems and domestic middleware. It runs stably on the mainstream domestic software and hardware, and its performance can meet the business requirements. TiDB has excellent functional and syntax compatibility with MySQL, so it is the first choice for domestic replacement of MySQL database.

Independent open source and active community

TiDB adheres to the independent open source model, creates an open source community dominated by Chinese people, and ensures the security of the product supply chain. The TiDB community is active, and questions encountered in testing and application can be answered in community forums. In addition, TiDB documents and video course resources are very rich, so it is easy to learn systematically.

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.