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.
This tutorial explains how to use Docker to deploy DBLE, Prometheus, and Grafana, configure JMX Exporter for JVM metrics, and create a monitoring dashboard that visualizes CPU, memory pool, GC, and thread statistics of DBLE instances.
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.
This weekly community bulletin curates high‑quality technical shares and release notes from the MySQL and DBLE ecosystems, highlighting new features, bug fixes, and upcoming development plans while inviting reader feedback and questions about the middleware tools.
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.
This article explains the difference between ON and WHERE clauses in MySQL LEFT JOIN, illustrates why a proposed optimization for DBLE sharding does not work, and provides practical examples and pseudo‑code to clarify how MySQL processes left joins.
This weekly digest curates top community technical articles and release notes, highlighting PostgreSQL vs MySQL comparisons, architecture diagram tips, a six‑hour pagination incident, MySQL core‑dump handling, new DBLE features, DTLE performance boosts, and SQLE multi‑source audit enhancements.
The article introduces the DBLE distributed middleware, outlines the main updates in version 3.22.07.0—including read‑write splitting local read, OpenSSL support, hint‑based query plan improvements—and provides the complete release notes, bug fixes, acknowledgments, and related learning resources.
This article investigates why DBLE repeatedly logs "no handler" messages by analyzing DBLE and MySQL logs, using Arthas to trace the call chain, reproducing the scenario with timeout settings, capturing network traffic, and explaining the MySQL 8.0.24 error‑packet behavior that leads to the observed logs.
This article examines the DBLE distributed database middleware cache, reproduces a primary‑key update query that returns incomplete results due to stale routing cache, analyzes cache contents via the management console, explains the cache’s behavior and limitations, and shows how disabling the primary‑key cache restores correct query routing.
This article provides a comprehensive, code‑rich guide on using TiDB DM v2.0.7 to perform full and incremental migration of terabyte‑scale MySQL data to DBLE, covering environment setup, TiDB DM installation, DBLE configuration, data generation, task execution, verification, and important operational considerations.
This weekly roundup shares community and industry news, open‑source project updates, bug fixes, and upcoming plans for the DBLE distributed middleware, DTLE data‑transfer component, and SQLE SQL‑audit tool, along with links to detailed articles and recruitment notices.
This article details a low‑impact migration from MyCat to DBLE, covering required parameter adjustments, sharding function replacement, data node handling, and business‑SQL compatibility issues, while providing concrete configuration examples and practical recommendations for a smooth transition.
This article explains the DBLE split feature that partitions large mysqldump files according to sharding configuration, provides command syntax and usage examples, and presents a performance test showing that split‑based import can be up to 18 times faster than direct DBLE import while preserving data correctness.
This weekly community newsletter summarizes the latest MySQL‑related articles, open‑source middleware updates for DBLE, DTLE and SQLE, bug fixes, feature developments, upcoming plans, and invites community feedback, providing a concise technical snapshot for database practitioners.
This article introduces the SSL protocol, explains why encryption is needed for database communication, and provides step‑by‑step instructions for generating self‑signed certificates with OpenSSL, converting them for Java, and configuring both DBLE server and client to use SSL, including experimental verification of encrypted versus unencrypted connections.
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.
This weekly community newsletter summarizes recent MySQL licensing research, bug fixes, open-source middleware updates for DBLE, DTLE, and SQLE, highlights new features, community Q&A, and upcoming plans, providing developers with concise technical insights and resource links.
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.
This weekly roundup from the DBLE open‑source community shares the latest MySQL‑related news, feature releases, bug fixes, and upcoming plans for DBLE, DTLE, and SQLE, providing developers with concise technical updates and links to detailed articles.
This article provides a step‑by‑step tutorial on deploying a DBLE cluster, configuring sharding.xml, db.xml and user.xml, creating test tables, installing DTLE, performing full MySQL‑to‑DBLE data migration, then switching to GTID‑based incremental synchronization with detailed troubleshooting tips and best‑practice recommendations.
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.
This weekly community newsletter summarizes the latest MySQL change‑buffer insights, data‑consistency checks, new password policies, releases of DBLE, DTLE, and SQLE middleware, along with bug fixes, feature improvements, community Q&A, and plans for the upcoming week.
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.
This article explains DBLE's support for server‑side and client‑side prepared statements, outlines their advantages and drawbacks, describes the related MySQL protocol commands, and provides detailed guidance on enabling and verifying cursor usage with code examples and configuration parameters.
This guide explains how to set up a monitoring environment for the DBLE distributed middleware using Zabbix, covering host and software configuration, MySQL master‑slave deployment, DBLE installation, Zabbix script creation, and template configuration with detailed code examples.
The article provides a detailed overview of DBLE version 3.21.10.0, covering project background, three major new features—including single‑node detach/reattach, enhanced traffic control, and default sharding mode—along with a full list of release notes, bug fixes, incompatibilities, and subsequent LTS patch updates.
This guide explains how to set up DBLE's alert webhook to send notifications to various platforms such as WeChat, DingTalk, FeiShu, or a custom URL, including download, installation, configuration file details, and example curl requests for seamless integration.
This article provides a comprehensive guide to DBLE's built‑in commands for viewing system information, diagnosing faults, and performing maintenance tasks such as killing connections, reloading configurations, and managing sharding nodes, helping MySQL DBAs efficiently operate distributed database clusters.
This article explains why GUI tools like phpMyAdmin may fail to display database lists when connecting to DBLE, outlines step‑by‑step troubleshooting using packet capture or the DBLE general log, and details the configuration parameters, commands, performance impact, and implementation mechanism of the general log.
This weekly bulletin from the DBLE community presents curated technical news, video courses, event announcements, detailed DBLE and DTLE development updates, bug fixes, and upcoming plans, providing valuable insights for developers working with MySQL middleware and open‑source database solutions.
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.
The article provides a comprehensive overview of DBLE version 3.21.06.0, detailing project background, eight new or refactored features, numerous bug fixes, incompatibility changes, LTS patch updates, and links to official resources and tutorials.
This weekly roundup presents community news, technical articles, video courses, and open‑source middleware updates, including MySQL and TiDB issue discussions, index design insights, and the latest DBLE and DTLE development progress, bug fixes, and upcoming plans.
This weekly community digest compiles recent MySQL technical articles, open‑source middleware progress for DBLE and DTLE, and community news links, offering developers concise insights into database engine best practices, bug fixes, new features, and upcoming plans.
This article introduces the DBLE MySQL‑compatible distributed middleware, details its new pure read/write splitting feature in version 3.20.10.0, and provides a comprehensive table showing which SQL statements trigger implicit commits and their support status.
This weekly community bulletin, presented by the Gold Medal Broadcaster Yongzheng, compiles selected MySQL and DBLE technical news, open‑source developments, bug fixes, community Q&A, and upcoming feature plans, providing readers with concise updates and links to detailed discussions.
The DBLE 3.21.02.0 release introduces ten new or refactored features, fixes over ten bugs, adds general logging, batch load data mode, fine‑grained SQL statistics, and other enhancements, while also detailing LTS updates, project overview, download links, and community acknowledgments.
This weekly community newsletter compiles the latest technical updates, including MySQL and ProxySQL troubleshooting articles, Redis memory diagnostics, InnoDB performance insights, as well as progress reports and upcoming plans for the open‑source middleware projects DBLE and DTLE.
This article analyzes why certain join queries in DBLE distributed database middleware fail to push down to backend nodes, leading to high CPU usage and latency, and presents four concrete examples with step‑by‑step optimizations to ensure full query push‑down and improved performance.
This article summarizes the DBLE network module, describing its key classes such as NIOAcceptor, NIOReactor, and SocketWR, explaining how client connections are accepted and processed, and highlighting the importance of low‑level network I/O knowledge for middleware development.
This guide explains how to install and run the DBLE distributed database middleware on Huawei's Kunpeng 920 ARM‑based servers, covering wrapper preparation, Kunpeng‑compatible JDK installation, DBLE startup verification, and connection testing with MySQL client.
This weekly community newsletter summarizes recent MySQL issues, a recommended MySQL book, DBA team insights, MySQL 8.0.23 updates, index design tips, data recovery guidance, as well as DBLE and DTLE open‑source middleware progress, new features, bug fixes, community Q&A, and upcoming plans.
This article provides a detailed source‑code walkthrough of DBLE’s network module, explaining how it processes MySQL packets, implements selector‑based multiplexing, and performs asynchronous task handling to achieve high‑performance database communication for client connections.
The DBLE 3.20.10.0 release notes detail the open‑source distributed middleware's project overview, major enhancements such as management‑port metadata access and read/write splitting, a comprehensive list of new features, bug fixes, backward‑compatibility changes, and references to past versions and documentation.
This article explains the principles of hash tables, how hash functions are used for data sharding in distributed databases such as DBLE, compares hash‑modulo and consistent‑hash approaches, and discusses their advantages, limitations, and practical configuration tips.
The fifth episode of the MySQL 冲冲冲 livestream explores the trade‑offs between sharding and middleware architectures, discusses distributed transaction challenges, compares DBLE with MyCat and other solutions, and provides practical guidance for developers and DBAs handling high‑throughput MySQL workloads.
The article introduces the DBLE 3.20.07.0 release, covering project background, major updates such as configuration file refactoring, expanded DML push‑down support, online DDL capabilities, a detailed list of new features, bug fixes, and links to documentation and download resources.
This article analyzes a community‑raised issue where a left join between a global table and a sharded table produces incorrect results in Mycat but works as expected in DBLE, explaining the underlying execution‑plan differences and how DBLE correctly merges results to avoid duplicate data.
In a June 10 live session, ICBC's software development center manager Wei Yadong presented the financial industry's distributed database needs and selection criteria, answering 31 detailed questions covering architecture, middleware, sharding, high availability, migration, and operational practices.
In a June 10 live broadcast, ICBC software development manager Wei Yadong answered 31 audience questions covering the motivations, architecture, storage, high‑availability, migration challenges, and operational practices behind the bank’s distributed database selection and design decisions.
An investigation of a DBLE performance issue revealed that identical sharding keys with the same stringhash rule failed to improve query speed because differing hashSlice configurations prevented proper partitioning, and after correcting the rule.xml function settings, the SQL executed efficiently with sub‑second response times.
This weekly newsletter presents the June DB-Engines database popularity ranking, explains its methodology, shares community resources such as Mycat diagnostics and MySQL tips, outlines DBLE and DTLE development updates, bug fixes, upcoming plans, and invites community feedback.
The article presents a comprehensive overview of DBLE version 2.20.04.0, including project background, new features such as larger MySQL packet support and redesigned failover, a full list of enhancements, bug fixes, backward‑compatibility changes, and links to official documentation and source repositories.
This week’s community newsletter highlights the DB‑Engines May 2024 ranking where MySQL shows the highest growth, shares links to MySQL troubleshooting and performance articles, reports DBLE and TXLE development progress, bug fixes, community Q&A, and outlines upcoming plans for the open‑source middleware projects.
The article recaps the final DBLE open class session on May 12, presenting DBLE 3.0 roadmap, sharing PPT and video resources, and providing detailed Q&A covering features such as connection pooling, read‑write separation, distributed transactions, sharding, high‑availability, and future development plans.
The article explains how DBLE 2.19.11.0 replaces the server‑level global table check with a table‑level, Quartz‑driven mechanism that allows precise scheduling, customizable check methods, and easier result handling, and provides configuration examples for the built‑in CHECKSUM and COUNT checks.
This article explains how DBLE, a PaaS middleware, implements MySQL view capabilities by first describing MySQL view concepts and the MERGE and TEMPTABLE algorithms, then detailing DBLE's push‑down and non‑push‑down approaches, the criteria for each, and providing illustrative diagrams.
This article explains the purpose of DBLE's heartbeat detection, including high‑availability switching, read load balancing, and idle connection management, and provides a detailed walkthrough of the module's source code—from the Scheduler initialization to the MySQLHeartbeat implementation—illustrating how the system monitors MySQL instance status.
This weekly newsletter summarizes the latest DBLE, DTLE, and TXLE open‑source middleware updates, including new feature developments, bug fixes, community‑submitted articles on MySQL topics, and upcoming plans, while inviting community feedback and participation.
This weekly community roundup presents the latest DBLE and TXLE open‑source developments, highlights new MySQL features and diagnostic tools, shares bug‑fixes and upcoming plans, and invites readers to contribute feedback and questions about the distributed database middleware ecosystem.
This weekly DBLE community newsletter, authored by reporter Yongzheng, compiles curated MySQL and DBLE resources, outlines recent open‑source developments, bug fixes, community Q&A, and upcoming plans for both DBLE and TXLE middleware projects.
This article explains how DBLE implements the MySQL LOAD DATA large‑scale data import feature, covering the overall design, key classes such as ServerLoadDataInfileHandler and LoadDataUtil, and detailed Java source code handling client‑server interactions, file routing, and backend MySQL communication.
The DBLE 2.19.11.0 release introduces 13 new features, 28 bug fixes, and backward‑compatibility changes, providing detailed explanations of global table checks, new commands, and performance improvements for this enterprise‑grade open‑source distributed middleware to enhance.
This weekly roundup from the DBLE open‑source community presents the latest MySQL‑related articles, bug‑fixes, open‑source middleware progress, upcoming release plans for DBLE, DTLE, and TXLE, and invites community feedback on development and usage.
This tutorial demonstrates how to enable, configure, and analyze DBLE’s slow query log—compatible with MySQL’s mysqldumpslow and Percona’s pt‑query‑digest—by generating sample queries, examining log rotation, and using the tools to inspect performance details, while also providing community resources and course information.
This article demonstrates how to enable DBLE's trace function, view detailed execution timing with `show trace`, and analyze performance bottlenecks across client, middleware, and MySQL layers, including a real‑world case study and optimization tips.
The article explains how to overcome performance degradation in DBLE‑based pagination by using a constant LIMIT clause, filtering with id‑based conditions, and adhering to sharding‑key constraints, while outlining practical steps, limitations, and best‑practice recommendations for continuous page navigation.
This article demonstrates how to use the Explain feature in DBLE to visualize distributed query plans, compare join orders across multiple SQL statements, identify Cartesian products and ordered joins, and apply optimization insights for better performance in multi‑table queries.
This article demonstrates how DBLE manages table-level DML permissions, global blacklist rules, and user‑IP whitelist controls, showing configuration steps, reload procedures, and the resulting effects on query execution and login access.
This article introduces the DBLE management console, explains its dual role in administration and monitoring, demonstrates how the reload command hot‑applies configuration changes, and provides guidance on using select/show commands for database inspection.
This weekly newsletter summarizes the 2019 DB-Engines MySQL award, highlights community news on DBLE, DTLE, and TXLE middleware, and presents technical articles on query field count impact, count(*) vs count(column) differences, and improving RDS monitoring aesthetics.
This tutorial demonstrates how to configure and use DBLE's global sequence feature, covering the timestamp‑based Snowflake algorithm and the offset‑setup type, including server.xml settings, table definitions, insertion behavior, and handling of restarts to ensure unique identifiers.
This article introduces DBLE's advanced global sequence features, explaining the Snowflake algorithm with its timestamp‑based ID generation and the offset‑step token allocator, detailing their designs, capacities, cluster considerations, and practical trade‑offs for distributed database systems.
This article explains how DBLE's hint mechanism can be used to specify database routing, classify different hint types, and demonstrate practical operations such as invoking stored procedures and executing custom SQL statements on selected nodes.
This article explains a second method for implementing ER tables in DBLE that avoids configuring child_table, demonstrates how tables with identical split columns, distribution nodes, and algorithms can act as ER tables, and shows practical JOIN and EXPLAIN query examples.
This article explains the concept of ER tables, demonstrates how they are configured and used in the DBLE middleware with parent‑child relationships, shows a practical SELECT example and query plan analysis, and concludes with best‑practice recommendations for leveraging foreign‑key optimizations.
This article explains what Global tables are in DBLE, how to configure them in schema.xml, and demonstrates their behavior during various JOIN operations across sharded databases, highlighting benefits and performance considerations for low‑change, low‑concurrency dictionary data.
This tutorial explains how DBLE splits tables using different rules, demonstrates cross‑database INNER, LEFT, and RIGHT JOINs with jump‑hash sharding, and details the distributed query plan and sorting optimization that reduces join complexity in a middleware environment.
This weekly newsletter summarizes the latest DB‑Engines December ranking, PYPL top‑10 database trends, new features and bug fixes in the DBLE, DTLE, and TXLE middleware projects, and includes community announcements and links to detailed videos and articles.
This article explains DBLE's query workflow, covering basic DML handling, simple query routing and result merging, as well as complex query processing with JOIN, UNION, sub‑queries, and sharding strategies, illustrated with diagrams and code examples.
This article explains the role of the Java Service Wrapper (JSW) in DBLE, describes its architecture and daemon startup workflow, analyzes critical bugs that caused process hangs and crashes, and outlines the improvements made in the latest JSW version to enhance reliability.
This tutorial explains DBLE's core horizontal sharding mechanism, detailing the purpose of data partitioning for massive tables and walking through the three essential XML configuration files—rule.xml, schema.xml, and server.xml—that define sharding rules, schema mappings, and system parameters.
This weekly report summarizes the latest DBLE, DTLE, and TXLE middleware releases, bug fixes, community Q&A, documentation updates, and previews of upcoming features, providing developers with concise information on new versions, resolved issues, and future development plans.
This article explains the layout of a DBLE installation, detailing each top‑level directory such as algorithm, bin, conf, pid, lib, logs, version.txt, viewConf, and key configuration files like wrapper.conf, rule.xml, schema.xml, and server.xml, helping users navigate and manage the middleware effectively.
The DBLE 2.19.09.0 release notes introduce eight new refactoring features, 34 bug fixes, external MySQL‑HA interface commands, a dump‑file split utility, detailed translation of all changes, and compatibility updates for the open‑source distributed database middleware.
This tutorial demonstrates how to install DBLE using a Docker‑based MySQL environment, configure its XML templates to connect to two MySQL instances, start the DBLE service, and manage databases and tables through the DBLE console, including practical code examples.
This weekly newsletter summarizes the latest DBLE, DTLE, and TXLE open‑source middleware updates, including bug fixes, new features, community Q&A, documentation releases, upcoming releases, and links to related videos and articles for developers.
This tutorial introduces DBLE middleware by covering quick Docker‑based installation, basic CRUD and sharding functions, advanced global sequencing and application management, and analysis tools for SQL query planning and slow‑query diagnostics, providing a concise hands‑on guide for developers.
This weekly bulletin from the DBLE open‑source community compiles recent news, event summaries, and detailed technical updates—including new features, bug fixes, and upcoming plans—for the DBLE, DTLE, and TXLE middleware projects, providing developers with a concise overview of the latest developments.
This weekly community newsletter highlights the open‑source launch of the TXLE distributed transaction framework, DBLE user meetups, deep dives into MySQL slow‑query analysis and EXPLAIN ANALYZE, recent DBLE feature developments, bug fixes, community Q&A, and a preview of next week's technical plans.
This weekly DBLE community roundup covers Amazon's migration away from Oracle databases, Percona's 2019 open‑source data management survey, the MySQL 8.0.18 GA release, and detailed DBLE and DTLE middleware updates including new features, bug fixes, and upcoming plans.
This weekly community digest presents the latest DB‑Engines October ranking with MSSQL’s rebound, the Archery v1.7.0 release enhancing MySQL account management, DBLE’s new features, bug fixes and community Q&A, plus DTLE’s performance improvements and upcoming roadmap, all accompanied by relevant links and images.
This article provides a detailed analysis of DBLE's memory management module, explaining its structure, configuration parameters, allocation and recycling logic, and includes annotated source code snippets for classes such as DirectByteBufferPool and ByteBufferPage, illustrating how off‑heap and on‑heap memory are handled.
The article provides a comprehensive overview of DBLE version 2.19.07.0, including project background, new features, enhanced data import/export methods, updated show commands, protocol extensions, a full translated release‑notes list, bug‑fix details, and compatibility changes for this distributed database middleware.
The iKesheng community’s weekly roundup shares upcoming events like the DBLE Beijing meet‑up, free Mycat diagnosis services, detailed DBLE and DTLE weekly reports, and technical articles on global lock detection, slave data search, and hash algorithm choices, offering valuable insights for database professionals.
This weekly MySQL community newsletter highlights September 2019 DB‑Engines rankings, offers free Mycat diagnosis, summarizes DBLE and DTLE development updates, and showcases original technical articles on WRITESET parallel replication, InnoDB primary‑key optimization, MySQL 8.0 error‑log enhancements, and query optimization, inviting community feedback.
This article provides a comprehensive examination of DBLE's backend connection module, detailing its design philosophy, data structures, initialization process, connection acquisition logic, and release mechanisms, while walking through key Java source code snippets to clarify how connections are managed within the middleware.
This weekly digest highlights the August MySQL ranking surge, Percona XtraBackup 8.0.7 features, free Mycat diagnostic support, DBLE and DTLE weekly reports, and several in‑depth technical articles covering MySQL cloning, group replication, charset performance, ZooKeeper deployment, and InnoDB index construction.
This guide walks through the complete process of building a highly available MySQL cluster by installing DBLE middleware on three nodes, configuring a ZooKeeper ensemble to coordinate the DBLE instances, and verifying the setup with configuration reloads, view synchronization, and fault‑tolerance tests.