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.
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.
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.
This article reviews the seven sharding algorithms supported by DBLE, introduces the unique JumpStringHash algorithm with its configuration and usage details, summarizes the complete XML rule examples for all algorithms, and links to the previous series articles for further reference.
This article explains DBLE’s date‑based sharding algorithm, describing its band and ring modes, the required rule.xml configuration parameters, development and operational considerations, and a comparison with MyCat’s similar sharding approach for large-scale deployments.
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.
This article explains DBLE's enum-based sharding algorithm, how it maps user-defined enum values to shard nodes, compares it with MyCat's approach, and provides development, operational, and configuration best practices, including code examples and mapping file format guidelines.
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.
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.
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.
This article examines the enterprise‑level open‑source distributed middleware DBLE (aka MyCat Plus), explains MySQL 5.1 prepared‑statement protocol, details DBLE’s implementation and two reported bugs (#1122 and #1124), analyzes their root causes, and presents the fixes released in version 2.19.03.0.
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.
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.
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.
The DBLE 2.19.01.0 release introduces Docker images, new management commands, attribute enhancements, query plan optimizations, and numerous bug fixes—including issues with RocksDB cache, complex joins, and global table handling—while providing download links, documentation, and community support resources.
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.
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.
This article provides a comprehensive overview of DBLE's Server.xml configuration, covering system parameters, user definitions with schema and privilege controls, and black‑white list firewall settings, along with practical code examples and links to official resources for quick onboarding.
This article explains how DBLE loads routing functions, performs sharding calculations, queries parameters, and provides step‑by‑step guidance for developing, packaging, and deploying custom partition algorithms with required interface methods and configuration setters.
This article introduces the DBLE middleware project, lists its main configuration files, explains the purpose and structure of rule.xml, and provides a detailed PatternRange sharding example with code snippets, mapping files, and routing logic to help users configure database sharding effectively.
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.
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.
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.
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.