BestHub
Sign in
Tag

Database Middleware

0 views collected around this technical thread.

IT Services Circle
IT Services Circle
Oct 25, 2024 · Databases

Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them

The article outlines the growing difficulties of managing diverse databases in cloud-native environments, introduces Apache ShardingSphere as a comprehensive open‑source solution with three core capabilities—connectivity, enhancement, and pluggability—and guides readers through a three‑step learning path from fundamentals to deployment and testing.

Cloud NativeDatabase ManagementDatabase Middleware
0 likes · 9 min read
Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them
Architecture & Thinking
Architecture & Thinking
Aug 1, 2024 · Databases

Choosing the Right Sharding Middleware: ShardingSphere vs MyCAT vs Vitess

This article explains why sharding is needed for high‑traffic databases, outlines vertical and horizontal partitioning, and compares three popular sharding middleware—ShardingSphere, MyCAT, and Vitess—detailing their architectures, advantages, and ideal use cases to help engineers select the right solution.

Database MiddlewareMySQLSharding
0 likes · 9 min read
Choosing the Right Sharding Middleware: ShardingSphere vs MyCAT vs Vitess
vivo Internet Technology
vivo Internet Technology
Mar 6, 2024 · Databases

Sharding-JDBC Source Code Analysis and Custom Development

The article dissects Sharding‑JDBC’s five core engines—parsing, routing, rewriting, execution, and merging—highlights production pain points, and details custom extensions such as skipping sharding for specific tables, forcing master routing, runtime configuration refresh, batch‑update handling, sharding‑condition deduplication, full‑route validation, and a simplified component wrapper to ease integration and improve performance.

Custom DevelopmentDatabase MiddlewareExecution Engine
0 likes · 55 min read
Sharding-JDBC Source Code Analysis and Custom Development
Architecture & Thinking
Architecture & Thinking
Mar 5, 2024 · Databases

How Database Middleware Solves High‑Traffic Challenges: Connection Pools, Sharding, and More

This article examines how database middleware tackles the demanding needs of large‑scale internet services by providing centralized connection‑pool management, transparent read‑write splitting, diverse load‑balancing algorithms, sharding support, automatic failover, security controls, comprehensive monitoring, and flexible backup‑recovery mechanisms.

Connection PoolDatabase MiddlewareLoad Balancing
0 likes · 9 min read
How Database Middleware Solves High‑Traffic Challenges: Connection Pools, Sharding, and More
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 2, 2023 · Databases

DBLE 3.23.08.0 Release Notes: New Features, Bug Fixes, and LTS Updates

The DBLE 3.23.08.0 release notes detail the project's overview, introduce five major feature enhancements—including hybrid OLAP/OLTP load support and internal thread hang detection—list numerous bug fixes, incompatibility adjustments, and summarize LTS version patches across several minor releases.

Bug FixesDBLEDatabase Middleware
0 likes · 9 min read
DBLE 3.23.08.0 Release Notes: New Features, Bug Fixes, and LTS Updates
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 20, 2023 · Databases

DBLE 3.23.04.0 Release Notes: New Features, Bug Fixes, and LTS Updates

The DBLE 3.23.04.0 release introduces six new or refactored features, fixes over five critical community issues and more than a hundred bugs, adjusts TCP keep‑alive parameters, adds experimental configuration support, and provides detailed LTS version updates and incompatibility notes for users.

DBLEDatabase MiddlewareRead-Write Splitting
0 likes · 8 min read
DBLE 3.23.04.0 Release Notes: New Features, Bug Fixes, and LTS Updates
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 12, 2023 · Databases

DBLE 3.22.11.0 Release Notes – New Features, Bug Fixes, and LTS Updates

The article provides a detailed overview of DBLE version 3.22.11.0, covering project background, major new functionalities such as master‑slave delay detection and audit logs, a full list of release notes, bug fixes, incompatibility changes, and subsequent LTS patch updates.

Bug FixesDBLEDatabase Middleware
0 likes · 7 min read
DBLE 3.22.11.0 Release Notes – New Features, Bug Fixes, and LTS Updates
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 28, 2022 · Databases

Understanding Dble Startup Configuration Validation and Common Failure Cases (Version 3.22.01.0)

This article explains how Dble validates its configuration files during startup, lists the main configuration file types, and walks through typical startup failure examples—such as port conflicts, syntax errors, and backend MySQL connectivity issues—providing step‑by‑step troubleshooting guidance for new users.

DBLEDatabase MiddlewareMySQL
0 likes · 9 min read
Understanding Dble Startup Configuration Validation and Common Failure Cases (Version 3.22.01.0)
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 7, 2022 · Databases

Integrating dble with ClickHouse for OLAP: Configuration and Testing Guide

This article explains how to extend the dble distributed middleware with ClickHouse to provide OLAP capabilities, covering environment setup, XML configuration of user.xml, db.xml and sharding.xml, command‑line testing, data import, and a sample architecture that combines dble, MySQL and ClickHouse.

ClickHouseDatabase MiddlewareMySQL
0 likes · 11 min read
Integrating dble with ClickHouse for OLAP: Configuration and Testing Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 28, 2022 · Databases

Quick Guide to Enabling Read‑Write Splitting in Dble (v3.20.10+)

This article explains how to configure Dble's read‑write splitting feature by preparing MySQL master‑slave instances, defining dbGroup and rwSplitUser in XML configuration files, reloading the settings, and verifying that write statements go to the primary node while reads are load‑balanced across replicas.

DBLEDatabase MiddlewareLoad Balancing
0 likes · 6 min read
Quick Guide to Enabling Read‑Write Splitting in Dble (v3.20.10+)
DeWu Technology
DeWu Technology
Jun 22, 2022 · Databases

Rainbow Bridge: A ShardingSphere‑Based Database Middleware for Scalability and Reliability

To support the rapidly growing DeWu App, the team created Rainbow Bridge—a ShardingSphere‑based middleware that unifies horizontal sharding, read‑write separation, shadow‑DB routing, rate limiting, and active‑active traffic correction, while adding a graphical console, stability enhancements, fine‑grained observability, hybrid JDBC/Proxy switching, and ongoing open‑source contributions.

Data ShardingDatabase MiddlewarePerformance Optimization
0 likes · 18 min read
Rainbow Bridge: A ShardingSphere‑Based Database Middleware for Scalability and Reliability
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 8, 2022 · Databases

Fixing DBLE Docker Deployment: IP Subnet and Permission Issues

This guide walks through troubleshooting DBLE container deployment by adjusting Docker network subnets, correcting DBLE configuration IPs, and granting the necessary database permissions to ensure the logical schema is created without errors.

DBLEDatabase MiddlewareDocker
0 likes · 10 min read
Fixing DBLE Docker Deployment: IP Subnet and Permission Issues
Aikesheng Open Source Community
Aikesheng Open Source Community
May 24, 2022 · Databases

Read SQL Routed to Master Despite rwSplitMode=3 Configuration

The article investigates why read queries are sent to the master node when Dble is configured with rwSplitMode=3, analyzes reproductions on standard replication and MySQL Group Replication, identifies heartbeat and replication status issues, and provides troubleshooting steps and recommendations.

DBLEDatabase MiddlewareGroup Replication
0 likes · 7 min read
Read SQL Routed to Master Despite rwSplitMode=3 Configuration
Aikesheng Open Source Community
Aikesheng Open Source Community
May 8, 2022 · Databases

Weekly Community Tech News Summary – MySQL, ClickHouse, DBLE, DTLE, SQLE Updates

This weekly community newsletter curates the latest technical news and open‑source progress, covering MySQL and Mycat issues, a ClickHouse distributed DDL block case, a MySQL MDL lock analysis, the new SQLE release, and updates on DBLE, DTLE, and SQLE middleware projects.

ClickHouseDatabase MiddlewareMySQL
0 likes · 3 min read
Weekly Community Tech News Summary – MySQL, ClickHouse, DBLE, DTLE, SQLE Updates
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 28, 2022 · Databases

DBLE 3.22.01.0 Release Notes – New Features, Bug Fixes, and Full Details

The DBLE 3.22.01.0 release introduces seven new or refactored features—including enhanced read/write separation, ClickHouse support, and hint‑based query planning—while fixing over a hundred bugs, addressing critical community issues, and providing a complete list of changes and incompatibilities.

ClickHouseDBLEDatabase Middleware
0 likes · 5 min read
DBLE 3.22.01.0 Release Notes – New Features, Bug Fixes, and Full Details
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 29, 2022 · Databases

Performance Tuning and Observation Techniques for dble Using BenchmarkSQL

This article shares practical configuration recommendations, system‑resource monitoring methods, and thread‑adjustment strategies for optimizing dble performance during BenchmarkSQL TPC‑C style load testing, highlighting how observable metrics guide effective tuning of the middleware and underlying MySQL nodes.

BenchmarkSQLDBLEDatabase Middleware
0 likes · 10 min read
Performance Tuning and Observation Techniques for dble Using BenchmarkSQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 26, 2022 · Databases

Weekly Community Update: MySQL Issues, DBLE/DTLE/SQLE Progress, and Upcoming Plans

This weekly community bulletin summarizes recent MySQL problem reports, new features and bug fixes in the DBLE distributed middleware, DTLE data‑transfer component, and SQLE SQL audit tool, while also highlighting upcoming development plans and inviting community feedback.

DBLEDatabase MiddlewareMySQL
0 likes · 4 min read
Weekly Community Update: MySQL Issues, DBLE/DTLE/SQLE Progress, and Upcoming Plans
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 6, 2022 · Databases

Dynamic Adjustment of DBLE Thread Pools Without Restart

This article explains how DBLE version 3.21.06.* enables runtime, non‑restart adjustments of various thread‑pool parameters such as processors and backendProcessors, describes the underlying reactor and JDK thread‑pool mechanisms, and provides practical guidance and precautions for safely scaling thread pools in production environments.

DBLEDatabase MiddlewareDynamic Scaling
0 likes · 11 min read
Dynamic Adjustment of DBLE Thread Pools Without Restart
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 13, 2021 · Databases

Configuring DBLE Middleware for Read/Write Splitting with and without Sharding

This article explains the new DBLE v3.20.10.0 feature that enables read/write splitting independently of sharding, detailing environment setup, configuration files, SQL testing, and log verification for both sharded and pure read/write split scenarios.

DBLEDatabase MiddlewareMySQL
0 likes · 10 min read
Configuring DBLE Middleware for Read/Write Splitting with and without Sharding