Tagged articles
124 articles
Page 2 of 2
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 13, 2019 · Databases

Weekly Community Digest: MySQL 8.0.17 New Features, Redis 6 Release, DBLE & DTLE Updates, and Upcoming Shanghai Meetup

This weekly digest summarizes the latest MySQL 8.0.17 enhancements, Redis 6's new RESP3 protocol, free Mycat diagnostics, DBLE and DTLE weekly reports, original technical articles on MySQL fragmentation, dynamic permissions and TempTable engine, plus details of the upcoming Shanghai 3306π meetup.

DBLEDTLEcommunity
0 likes · 7 min read
Weekly Community Digest: MySQL 8.0.17 New Features, Redis 6 Release, DBLE & DTLE Updates, and Upcoming Shanghai Meetup
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 6, 2019 · Databases

Weekly Community Newsletter – DBLE & DTLE Updates, Release Notes, Events, and Technical Articles

This weekly newsletter summarizes the latest database industry rankings, DBLE and DTLE release notes, free Mycat diagnostic support, upcoming community meetups, performance testing tutorials, and technical deep‑dives such as MTS parallel incremental processing and event‑scheduler replication issues.

Community EventsDBLEDTLE
0 likes · 6 min read
Weekly Community Newsletter – DBLE & DTLE Updates, Release Notes, Events, and Technical Articles
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 2, 2019 · Databases

DBLE 2.19.05.0 Release Notes: New Features, Bug Fixes, and Upgrade Compatibility

The DBLE 2.19.05.0 release introduces seven new features—including MySQL 8.0 support and enhanced stored‑procedure hints—optimizes connection defaults, adds configurable templates, and resolves 36 bugs, while maintaining full compatibility with previous versions, and is available via the project's GitHub releases page.

Bug FixesDBLERelease Notes
0 likes · 8 min read
DBLE 2.19.05.0 Release Notes: New Features, Bug Fixes, and Upgrade Compatibility
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 12, 2019 · Databases

DBLE Sharding Algorithm Overview and Configuration Guide

This article explains DBLE's hash‑based sharding algorithm, detailing how logical shards are derived via modulo, mapped to physical shards through a rule.xml configuration and mapFile, compares it with MyCat, and provides development, operational, and configuration best practices along with code examples.

DBLEPartitioningmapFile
0 likes · 6 min read
DBLE Sharding Algorithm Overview and Configuration Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 5, 2019 · Databases

DBLE String‑Hash Sharding Algorithm and Configuration Guide

This article explains DBLE's string‑hash sharding algorithm, detailing how to configure partitionLength, partitionCount, and hashSlice in rule.xml, the conversion of string indexes to integers, comparison with MyCat, development and operational considerations, and provides example XML configurations and best‑practice tips.

DBLEstringhash
0 likes · 12 min read
DBLE String‑Hash Sharding Algorithm and Configuration Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 4, 2019 · Databases

How DBLE Maps Logical Shards to Physical Partitions Using a Hash Modulo

This article explains DBLE's hash‑based sharding algorithm that first computes a modulo to obtain a logical shard number and then directly maps it to a physical shard via a mapping table derived from partitionLength and partitionCount arrays, including configuration steps, development tips, operational guidance, and a comparison with MyCat.

DBLEDatabase MiddlewareMycat
0 likes · 7 min read
How DBLE Maps Logical Shards to Physical Partitions Using a Hash Modulo
Aikesheng Open Source Community
Aikesheng Open Source Community
May 29, 2019 · Databases

DBLE XA Transaction Implementation and Recovery Analysis

This article provides a comprehensive analysis of DBLE's XA transaction implementation, covering XA protocol basics, DBLE's architecture, code structure, execution flow, error handling, transaction logging, recovery mechanisms, and practical considerations for distributed transactions in database middleware.

DBLEDistributed TransactionsTransaction Recovery
0 likes · 25 min read
DBLE XA Transaction Implementation and Recovery Analysis
Aikesheng Open Source Community
Aikesheng Open Source Community
May 10, 2019 · Operations

Implementing Load Balancing for DBLE Using Lvs and Keepalived

This article details the design and implementation of a high‑availability load‑balancing solution for the DBLE distributed middleware using Lvs and Keepalived, covering environment setup, configuration, experimental scenarios, performance testing, and troubleshooting tips to ensure stable and balanced traffic distribution.

DBLELVShigh availability
0 likes · 13 min read
Implementing Load Balancing for DBLE Using Lvs and Keepalived
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 18, 2019 · Databases

Improving MyCat Pitfalls with the Distributed Middleware DBLE: Technical Review and Comparison

This article reviews the shortcomings of MyCat in handling sharding, joins, inserts, and session variables, demonstrates how the DBLE middleware addresses those issues with better correctness, performance, security, and operational management, and discusses code‑quality improvements and automated testing practices.

DBLEDistributed Systemssql
0 likes · 19 min read
Improving MyCat Pitfalls with the Distributed Middleware DBLE: Technical Review and Comparison
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 4, 2019 · Databases

Quick Start Guide for DBLE Distributed Middleware Using Docker‑Compose

This article introduces DBLE, an enterprise‑grade open‑source distributed middleware, and provides a step‑by‑step Docker‑Compose quick‑start tutorial covering download links, prerequisite installations, container launch, connection details, cleanup commands, and how to customize the configuration with custom scripts.

DBLEDockerDocker Compose
0 likes · 9 min read
Quick Start Guide for DBLE Distributed Middleware Using Docker‑Compose
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 28, 2019 · Databases

Performance Analysis of DBLE vs MyCat: Identifying Sorting and Isolation Level Issues

A detailed case study investigates why DBLE middleware achieves only about 70% of MyCat's performance, revealing that excessive sorting CPU usage, a cmp‑function inefficiency, and a delete‑loop bug under REPEATABLE_READ isolation cause the slowdown, and demonstrates how adjusting isolation levels and fixing the cmp implementation restores expected performance.

DBLEIsolation LevelSorting
0 likes · 10 min read
Performance Analysis of DBLE vs MyCat: Identifying Sorting and Isolation Level Issues
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 26, 2019 · Databases

Community Contributions on DBLE: Case Analysis, Configuration Guides, and Custom Sharding Algorithms

The announcement showcases a 30‑day community sharing event for the open‑source DBLE middleware, highlighting three member submissions that cover a cross‑shard query case study, detailed rule.xml and server.xml configuration guides, and a tutorial on creating custom sharding algorithms, along with reward details.

ConfigurationDBLEcase study
0 likes · 5 min read
Community Contributions on DBLE: Case Analysis, Configuration Guides, and Custom Sharding Algorithms
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 30, 2019 · Databases

Comparison of Cross‑Node Join Queries Between DBLE and Mycat Middleware

This article presents a step‑by‑step comparison of DBLE and Mycat distributed middleware by setting up a test environment, defining table schemas and sharding rules, inserting sample data, executing the same cross‑node join query on both systems, and analyzing the differing results and execution plans to explain why Mycat omits expected rows while DBLE returns the correct result.

DBLEMycatcross-node join
0 likes · 9 min read
Comparison of Cross‑Node Join Queries Between DBLE and Mycat Middleware
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 29, 2019 · Databases

DBLE Middleware Overview and schema.xml Configuration Guide

This article introduces the open‑source DBLE distributed middleware, provides official resource links, outlines its main configuration files—including server.xml, schema.xml, and rule.xml—explains the role of schema.xml for sharding, and presents a detailed example with code and diagrams to help users configure DBLE effectively.

DBLEdatabasesschema.xml
0 likes · 5 min read
DBLE Middleware Overview and schema.xml Configuration Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 22, 2019 · Databases

DBLE Quick‑Start Guide: Environment Setup, Installation, Configuration, Sharding and Read‑Write Separation

This article provides a step‑by‑step tutorial for preparing the environment, installing DBLE, configuring its sharding and read‑write‑separation features, and verifying the setup with command‑line examples and configuration file snippets, enabling developers to quickly get started with the DBLE middleware.

DBLEInstallationRead-Write Separation
0 likes · 13 min read
DBLE Quick‑Start Guide: Environment Setup, Installation, Configuration, Sharding and Read‑Write Separation
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 9, 2019 · Databases

Detailed Analysis of DBLE 2.18.12.0 Release Notes

This article provides a comprehensive review of the DBLE 2.18.12.0 release, covering project background, version overview, six new features, extensive bug fixes, compatibility considerations, and guidance for upgrading the enterprise‑grade open‑source distributed middleware.

DBLEDatabase ProxyRelease Notes
0 likes · 6 min read
Detailed Analysis of DBLE 2.18.12.0 Release Notes