How Does PolarDB Help Baison Software Solve Database Challenges at Peak Times?

Alibaba Cloud’s next-generation relational cloud database PolarDB is fully compatible with MySQL. With a maximum storage capacity of 100TB, and 6 times better performance than MySQL, PolarDB is suitable for diversified enterprise database applications. Storage and compute nodes of PolarDB are separated, with all compute nodes sharing the same set of data. PolarDB supports scaling up and down in minutes, failover in seconds, as well as global data consistency. It also provides free data backup and disaster recovery services. This article introduces Baison Software’s best practices — using Alibaba Cloud PolarDB to solve database challenges at peak times.

Introduction to Baison Software’s Services

Baison Software currently has 22 branches and subsidiaries, as well as more than 100 Baistar service agencies in China. Baison Software provides professional and timely support for the daily operation of more than 300,000 physical stores and more than 20,000 online stores. In the new retail era, Baison Software is dedicated to providing omni-channel new retail solutions for Chinese retailers. It helps customers achieve retail transformation and business innovation, build smart brands, and create extraordinary value.

The Baison iSHOP online marketplace is a mid-to-high-end e-commerce sales platform based on the consumer-driven business in the era of mobile Internet. It is a unified platform that fully satisfies the interaction, shopping experience, convenient transaction, and business growth needs of the various enterprises in different scenarios.

The Baison iSHOP online marketplace

Challenges for Baison Software

Challenge 1: Sharp Increase in Transactions at Peak Times

Before using the Alibaba Cloud’s database service, Baison Software used a self-built database. Back then, its largest retail terminal service often suffered from stagnation at peak times during the holiday season. For example, a transaction that could be normally completed within 2 seconds may have required 10 to 15 seconds at peak times. What’s worse, the stagnation may even cause transaction failures, in which case the buyers needed to re-submit the transaction requests.

Challenge 2: Database Capacity Approaching the Limit, Slowing Down the Business

Before using Alibaba Cloud’s database service, the capacity of Baison Software’s self-built database was approaching the limit, which slowed down its business expansion. The problem was: new service data could be accessed only when historical data was archived and cleaned up.

Why Choose Alibaba Cloud PolarDB?

In fact, Baison Software is most interested in the rapid scalability of Alibaba Cloud PolarDB — a scaling up/down configuration takes effect within 3 minutes. This allows Baison to quickly expand read-only instances at peak times. The secret behind the rapid scalability is that Alibaba Cloud PolarDB is a database cluster consisting of multiple nodes. The cluster has one master node and multiple read nodes. It provides two addresses by default — a cluster address and a master address. Generally, the cluster address is recommended because it supports read/write splitting. This allows it to integrate resources of all nodes to provide external services.

Cluster architecture of Alibaba Cloud PolarDB

PolarDB’s Read/Write Splitting Session Consistency

The implementation mechanism of PolarDB’s read/write splitting session consistency

In addition to read/write splitting in the middle layer, PolarDB tracks the redo log checkpoints, or the log sequence number (LSN), of each node. Each update is assigned a checkpoint, or Session LSN, in the log. When a new query is received, PolarDB compares the Session LSN of each node, and only sends the query to the node with the latest Session LSN, thus ensuring session consistency. Using the physical replication method, PolarDB is extremely fast and does not put too much pressure on the master database. In addition, in most scenarios, a database is more frequently read than written. This mechanism is proven to be trustworthy in ensuring session consistency based on our experience. It also ensures the effect of read/write splitting load balancing.

Baison Software replaced its MySQL database for the online retail marketplace with Alibaba Cloud PolarDB. With the powerful read/write splitting capabilities of PolarDB, Baison Software can easily increase the read-only instances when business pressure grows. After the peaks, Baison Software can easily remove read-only instances or reduce their specification to comprehensively reduce costs. Alibaba Cloud PolarDB has many excellent features, such as elastic scaling, online upgrading, high data security, high reliability, high availability, and zero-cost cloud migration. All these have greatly helped Baison Software with omni-channel new-retail transformation.

Baison iSHOP’s Alibaba Cloud-based database solution

PolarDB enables easy CPU and memory expansion by using the container virtualization and shared distributed block storage technologies. It allows Baison Software to add a new read-only node within 2–3 minutes. PolarDB also supports online database storage capacity resizing without interrupting the service. This mostly solves the hardware performance bottleneck.

Alibaba Cloud PolarDB provides comprehensive data security methods, such as whitelist, VPC network, SSL encryption, and multi-copy storage. All these are helpful for Baison Software to ensure data security in database access, storage, management, and so on. PolarDB uses an Active-Active highly available cluster architecture, which implements failover between the read-and-write master node and read-only replica nodes. In comparison with the conventional databases that use the Active-Standby architecture, PolarDB provides Baison Software with better system access performance at the same cost.

In addition, Alibaba Cloud PolarDB is fully compatible with MySQL. This allows Baison to smoothly migrate the existing database to PolarDB without restructuring it by using the Alibaba Cloud Data Transmission Service (DTS). At the same time, PolarDB allows customers of Baison Software to enjoy the performance and reliability of a commercial database at a lower cost.

Benefits of Using Alibaba Cloud’s Database Solution

During the World Cup, Baison Software’s customers streamed a large number of advertisements. With the powerful capabilities of Alibaba Cloud PolarDB, Baison Software managed to deal with millions of advertising exposures and high concurrent demands. With the powerful computing capability, Active-Active high-availability cluster architecture, and rapid increase of read-only instances, Alibaba Cloud PolarDB helped Baison Software successfully deal with peaks during the World Cup. This greatly improved the user experience and successfully safeguarded customer activities.

Reference:https://www.alibabacloud.com/blog/how-does-polardb-help-baison-software-solve-database-challenges-at-peak-times_594758?spm=a2c41.12843064.0.0

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com