Financial Industry MySQL High‑Availability Practices – Interview with Ming Xiyuan
In this interview, Ming Xiyuan, Technical Solutions Director at iKangSheng, shares practical guidance on selecting and deploying high‑availability MySQL solutions for the financial sector, covering planning pitfalls, hardware considerations, key configuration parameters, and the company’s product roadmap.
On December 14, the 3306π Shenzhen technical conference will feature a special interview titled “Financial Industry MySQL High‑Availability Practices” presented by Ming Xiyuan, Technical Solutions Director at iKangSheng.
Speaker Introduction Ming Xiyuan has extensive experience in data storage, cloud‑computing operations, and MySQL database and cloud‑platform design, having delivered solutions for numerous banks and insurance companies.
Topic Overview The interview covers three main points: selecting MySQL solutions for finance, iKangSheng’s financial‑grade MySQL high‑availability architecture, and a case study of a large state‑owned bank’s core system.
Q1 – Planning Tips Ming emphasizes the need to assess the intended workload (OLTP vs. OLAP) and optimize demand, then evaluate the operating environment, including hardware (SSD vs. HDD, RAID vs. NVMe) and OS. He highlights critical MySQL parameters such as double‑write buffers, redo log persistence, and binlog handling, urging flexible tuning based on real‑world conditions.
Q2 – What Is a “Financial‑Grade” MySQL HA Solution? He explains that high availability must address both business continuity and data consistency. Different scenarios (e.g., teller services vs. account transactions) have distinct requirements. iKangSheng’s Cloud‑Number @Guard component can tailor MySQL replication behavior to meet these varied needs.
Q3 – Future Product Plans Ming outlines current commercial offerings (Guard HA, @Proxy read/write splitting, @Shard distributed management, @DMP DBA platform, @RDS self‑service) and open‑source tools (DBLE middleware, DTLE binlog‑based data transfer, a SAGA‑based distributed transaction framework). Upcoming focuses include full MySQL 8.0 support, adding Redis management to @RDS, and integrating streaming backups with Veritas NetworkBackup.
Event Details Date: December 14, 2019, 08:00‑18:00 Location: Tencent Binhai Building, Nanshan District, Shenzhen (North Tower 3F, Multi‑Purpose Hall) Organizers: 3306π Community, Zhishu Hall Sponsors: iKangSheng, Qingyun, Tencent Cloud, Jushen Database
Signed-in readers can open the original source through BestHub's protected redirect.
This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactand we will review it promptly.
Aikesheng Open Source Community
The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.