BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 6, 2025 · Databases

SQLE 4.2502.0 Release: New Features, Upgrade Guide, and Version Log

SQLE 4.2502.0 has been officially released, introducing SQL compliance rewriting, a performance tracker, a syntax rule knowledge graph, new community and enterprise features, detailed upgrade instructions, and comprehensive version logs highlighting enhancements, bug fixes, and support for multiple database platforms.

Database GovernanceEnterprisePerformance Tracking
0 likes · 12 min read
SQLE 4.2502.0 Release: New Features, Upgrade Guide, and Version Log
JD Cloud Developers
JD Cloud Developers
Jul 30, 2024 · Databases

Cutting MySQL Disk Usage by 10% and Reducing QPS by 30%: A Real‑World Case Study

The article describes a high‑traffic core application with a MySQL master‑slave setup facing high resource usage; it details analysis of hardware, disk, table space, QPS, slow SQL, and presents governance actions including data archiving, moving reads to replicas, a MyBatis interceptor, and monitoring scripts, achieving significant performance improvements.

Database GovernanceRead Replicasslow SQL
0 likes · 20 min read
Cutting MySQL Disk Usage by 10% and Reducing QPS by 30%: A Real‑World Case Study
Huolala Tech
Huolala Tech
Jun 29, 2023 · Databases

How to Build a Proactive SQL Defense System: From Early Detection to Capacity Forecasting

This article outlines a comprehensive SQL governance framework that moves defense to the testing stage, introduces SQLReview and new‑SQL detection with fingerprinting, details full‑SQL analysis for deep insight, and explains capacity prediction through simulated traffic load testing in a hybrid‑cloud environment.

Database GovernancePerformance Monitoringhybrid cloud
0 likes · 13 min read
How to Build a Proactive SQL Defense System: From Early Detection to Capacity Forecasting
dbaplus Community
dbaplus Community
Jun 4, 2023 · Databases

How to Build an End‑to‑End SQL Defense and Capacity Forecast System

This article summarizes a technical presentation on innovative database practices, covering a preventive SQL defense framework, full‑SQL analysis for deep observation, and capacity prediction through simulated traffic testing, with detailed methods, challenges, and future plans for multi‑cloud environments.

Database GovernanceIndex RecommendationPerformance Optimization
0 likes · 16 min read
How to Build an End‑to‑End SQL Defense and Capacity Forecast System
Alibaba Cloud Native
Alibaba Cloud Native
Nov 10, 2022 · Cloud Native

How OpenSergo Unifies Microservice and Database Governance Across Languages

The article explains why microservice governance is essential, introduces the OpenSergo project and its collaboration with ShardingSphere to create a unified, language‑agnostic standard for database governance, and provides concrete abstractions and YAML examples for implementing traffic, fault‑tolerance, and security policies.

Database GovernanceOpenSergoService Mesh
0 likes · 15 min read
How OpenSergo Unifies Microservice and Database Governance Across Languages
Alibaba Cloud Native
Alibaba Cloud Native
Jul 19, 2022 · Cloud Native

Mastering Database Governance in Cloud‑Native Microservices: Scenarios & Solutions

This article outlines critical database governance scenarios in cloud‑native microservice architectures, explains why database performance is a top priority, and details practical solutions such as slow‑SQL insight, flow‑control, connection‑pool management, and gray‑release techniques using MSE and OpenSergo standards.

Cloud NativeDatabase GovernanceMSE
0 likes · 12 min read
Mastering Database Governance in Cloud‑Native Microservices: Scenarios & Solutions
dbaplus Community
dbaplus Community
Jan 9, 2022 · Databases

How ICBC Tames MySQL: Real‑World Governance, Risk Mitigation, and SRE Practices

This article details Industrial and Commercial Bank of China's comprehensive MySQL governance framework, covering risk identification, prevention strategies, a four‑step methodology, automated quality gates, production‑level monitoring, SRE management, and future visions for rapid incident detection and self‑healing.

Database GovernancePerformance OptimizationProduction Monitoring
0 likes · 22 min read
How ICBC Tames MySQL: Real‑World Governance, Risk Mitigation, and SRE Practices
dbaplus Community
dbaplus Community
Nov 10, 2021 · Databases

How HuoLaLa Built a Hybrid‑Cloud Database Governance Platform

This article outlines HuoLaLa's journey from a fragmented multi‑cloud environment to a unified, platform‑driven database governance system, detailing the technical challenges, architectural decisions, key components for MySQL, Redis, Kafka, and other middleware, and the measurable stability and cost improvements achieved after a year of operation.

Database GovernanceKafkahybrid cloud
0 likes · 44 min read
How HuoLaLa Built a Hybrid‑Cloud Database Governance Platform
JD Cloud Developers
JD Cloud Developers
Mar 5, 2021 · Databases

How Transparent Sharding Middleware Powers NewSQL: Core Functions Explained

This article explains the fundamentals of transparent sharding middleware in NewSQL systems, covering data partitioning strategies, read/write separation, the complete SQL processing pipeline, protocol adaptation for MySQL/PostgreSQL, distributed transaction models such as XA, Saga and TCC, and essential database governance and online scaling techniques.

Database GovernanceDatabase MiddlewareDistributed Transactions
0 likes · 28 min read
How Transparent Sharding Middleware Powers NewSQL: Core Functions Explained
21CTO
21CTO
Jan 8, 2021 · Databases

How ICBC Scales MySQL to 10,000 Nodes: Governance, Challenges, and Solutions

This article summarizes ICBC's experience of deploying nearly ten thousand MySQL nodes, detailing the current status, challenges, governance strategies—including standards, containerization, automated monitoring, emergency handling, and post‑incident analysis—and outlines future improvement plans for core‑application databases.

Database GovernanceICBCLarge‑Scale Deployment
0 likes · 17 min read
How ICBC Scales MySQL to 10,000 Nodes: Governance, Challenges, and Solutions
ITPUB
ITPUB
Jan 8, 2021 · Databases

How ICBC Scales MySQL to 10,000 Nodes: Governance, Automation, and Performance Strategies

This article outlines Industrial and Commercial Bank of China's journey from early MySQL adoption to managing nearly ten thousand production nodes, detailing the challenges of high‑capacity, high‑concurrency workloads and the comprehensive governance framework—including standards, pre‑emptive checks, automated incident response, and future self‑healing plans—used to ensure reliable core‑application data storage.

Database GovernanceLarge‑Scale DeploymentPerformance Monitoring
0 likes · 17 min read
How ICBC Scales MySQL to 10,000 Nodes: Governance, Automation, and Performance Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 6, 2021 · Databases

MySQL Governance Practices at Industrial and Commercial Bank of China

This article details ICBC's extensive MySQL deployment—nearly ten thousand nodes supporting core A‑level applications—and outlines the bank's governance framework, including current challenges, standardized operational procedures, automation, containerization, and future self‑healing strategies to ensure reliable, high‑performance database services.

Database GovernanceOperationsPerformance Automation
0 likes · 16 min read
MySQL Governance Practices at Industrial and Commercial Bank of China
ITPUB
ITPUB
Jul 3, 2020 · Databases

Why Redis’s Founder Is Stepping Down and What It Means for the Database’s Future

The article recounts Salvatore Sanfilippo’s decision to relinquish his role as Redis’s benevolent dictator, outlines the new community‑driven governance model led by Yossi Gottlieb and Oran Agra, and reflects on his personal philosophy about code as artistic self‑expression while highlighting Redis’s continued prominence as a leading NoSQL database.

Database GovernanceNoSQLOpen source
0 likes · 8 min read
Why Redis’s Founder Is Stepping Down and What It Means for the Database’s Future
Sohu Tech Products
Sohu Tech Products
Dec 12, 2018 · Databases

Designing and Implementing SQL Audit: Significance, Core Principles, Dimensions, Highlights, Workflow, and Future Plans

This article explains the importance of SQL audit as a self‑service, standards‑focused process, outlines its core concepts, covers the DDL/DML/DQL dimensions, presents scoring and visualization features, describes a practical workflow with API integration, and discusses future enhancements for database governance.

Database GovernanceSQL auditautomation
0 likes · 12 min read
Designing and Implementing SQL Audit: Significance, Core Principles, Dimensions, Highlights, Workflow, and Future Plans