BestHub
Sign in
Tagged articles
121 articles
Page 1 of 2
IT Services Circle
IT Services Circle
May 25, 2026 · Backend Development

Druid vs HikariCP: Which Connection Pool Wins?

This article compares Druid and HikariCP, the two most popular Java database connection pools, by explaining how connection pools work, presenting benchmark results, dissecting HikariCP's lock‑free design and bytecode optimizations, detailing Druid's rich monitoring and security features, and offering a practical decision framework for different scenarios.

Connection PoolDruidHikariCP
0 likes · 19 min read
Druid vs HikariCP: Which Connection Pool Wins?
Su San Talks Tech
Su San Talks Tech
May 21, 2026 · Backend Development

Druid vs HikariCP: Which Java Connection Pool Wins?

The article compares Alibaba’s Druid and Spring Boot’s default HikariCP connection pools, explaining how connection pooling works, presenting benchmark results that show HikariCP’s lower latency and higher TPS, detailing HikariCP’s lock‑free ConcurrentBag and bytecode optimizations, and highlighting Druid’s rich monitoring, SQL firewall and leak detection features to help developers choose the right pool for different scenarios.

Connection PoolDruidHikariCP
0 likes · 18 min read
Druid vs HikariCP: Which Java Connection Pool Wins?
macrozheng
macrozheng
Dec 30, 2025 · Backend Development

Mastering Druid Connection Pool in Spring Boot: Advanced Optimization Guide

This comprehensive guide walks through preparing the environment, fine‑tuning core Druid pool parameters, building a robust monitoring system, strengthening security, detecting connection leaks, applying advanced runtime tweaks, and avoiding common pitfalls to achieve high performance and stability in production Spring Boot applications.

Connection PoolDruidMonitoring
0 likes · 12 min read
Mastering Druid Connection Pool in Spring Boot: Advanced Optimization Guide
Java Web Project
Java Web Project
Dec 25, 2025 · Databases

How to Super‑Optimize Druid Connection Pool in Spring Boot for Production

This guide walks through preparing the environment, fine‑tuning core Druid parameters, managing connection lifecycles, building a monitoring stack, hardening security, detecting leaks, applying advanced runtime tweaks, and avoiding common pitfalls to achieve stable, high‑performance database pooling in Spring Boot.

Connection PoolDruidMonitoring
0 likes · 12 min read
How to Super‑Optimize Druid Connection Pool in Spring Boot for Production
Java Companion
Java Companion
Dec 25, 2025 · Backend Development

Druid Crashed in Production? How to Optimize the Spring Boot Connection Pool

The article explains why Druid can fail in a live Spring Boot service and provides a comprehensive, step‑by‑step optimization guide covering core pool parameters, monitoring setup, security hardening, leak detection, dynamic tuning, and best‑practice pitfalls to achieve stable, high‑performance database connections.

Connection PoolDruidJava
0 likes · 12 min read
Druid Crashed in Production? How to Optimize the Spring Boot Connection Pool
Architecture Digest
Architecture Digest
Dec 24, 2025 · Databases

Mastering Druid: Extreme Performance and Security Tuning in Spring Boot

This guide walks through step‑by‑step how to prepare the environment, fine‑tune core Druid connection‑pool parameters, set up comprehensive monitoring, harden security, detect leaks, and apply advanced runtime optimizations to achieve stable, high‑throughput database access in Spring Boot applications.

Connection PoolDruidMonitoring
0 likes · 13 min read
Mastering Druid: Extreme Performance and Security Tuning in Spring Boot
Su San Talks Tech
Su San Talks Tech
Oct 8, 2025 · Databases

Master Druid: Configure, Monitor, and Optimize Java Database Connections in Spring Boot

This guide explains Druid—Alibaba's Java database connection pool—covering its core concepts, Maven dependencies, property configuration, built‑in filters, SQL and slow‑SQL monitoring, Spring AOP integration, ad removal, and how to retrieve runtime statistics via DruidStatManagerFacade, all with complete code examples.

Database Connection PoolDruidJava
0 likes · 16 min read
Master Druid: Configure, Monitor, and Optimize Java Database Connections in Spring Boot
Cognitive Technology Team
Cognitive Technology Team
Sep 21, 2025 · Databases

How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes

An unexpected data loss issue in a ShardingSphere‑JDBC setup was traced to Druid’s poolPreparedStatements cache, which reuses PreparedStatement objects across different shards, bypassing dynamic routing; disabling the cache or switching to HikariCP restores correct sharding behavior with minimal performance impact.

Connection PoolDruidPerformance tuning
0 likes · 12 min read
How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes
Selected Java Interview Questions
Selected Java Interview Questions
Sep 14, 2025 · Backend Development

Mastering Spring Boot with KingbaseES: Which Connection Pool Wins?

This article explains the importance of database connection pools in Spring Boot projects using KingbaseES, compares four popular pools (DBCP, C3P0, Druid, HikariCP), provides configuration examples, highlights common pitfalls, and offers practical tuning and monitoring guidance for optimal performance.

Database Connection PoolDruidHikariCP
0 likes · 18 min read
Mastering Spring Boot with KingbaseES: Which Connection Pool Wins?
JD Tech Talk
JD Tech Talk
Aug 13, 2025 · Backend Development

Why MySQL getUiToken Times Out: PhantomReference GC Bottleneck & Fix

The article investigates frequent timeout alerts on the getUiToken API, tracing the issue to excessive PhantomReference objects causing long GC pauses, explains how MySQL’s AbandonedConnectionCleanupThread and default Druid pool settings generate these references, and presents configuration tweaks, JVM flags, and cleanup tasks that reduced GC pause times from 1.25 s to 0.1 s.

DruidJavaPerformance tuning
0 likes · 11 min read
Why MySQL getUiToken Times Out: PhantomReference GC Bottleneck & Fix
Architect
Architect
Jul 20, 2025 · Databases

Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot

This guide explains how to integrate Alibaba Druid as a Java database connection pool, add Maven dependencies, configure core properties, enable SQL and slow‑SQL monitoring, set up WebStatFilter and Spring AOP monitoring, remove the built‑in advertisement, and retrieve monitoring data via DruidStatManagerFacade.

Connection PoolDatabase MonitoringDruid
0 likes · 15 min read
Master Druid Monitoring: Configure, Filter, and Remove Ads in Spring Boot
macrozheng
macrozheng
Feb 12, 2025 · Databases

Mastering Spring Boot Database Connection Pools: HikariCP vs Druid

This guide explains the need for JDBC connection pools, compares popular pools like HikariCP and Druid, and provides step‑by‑step configurations for both custom property files and Spring Boot auto‑configuration, helping you efficiently manage database connections in Java applications.

Database Connection PoolDruidHikariCP
0 likes · 20 min read
Mastering Spring Boot Database Connection Pools: HikariCP vs Druid
Sohu Tech Products
Sohu Tech Products
Jan 15, 2025 · Backend Development

Deep Dive into Druid Connection Pool: Initialization, Retrieval, and Recycling Explained

This technical guide breaks down Alibaba's Druid JDBC connection pool, detailing its initialization process, how connections are fetched and returned, the internal threads and condition‑signal coordination, execution handling, recommended configurations, and monitoring integration, all illustrated with code snippets and diagrams.

Connection PoolDatabaseDruid
0 likes · 23 min read
Deep Dive into Druid Connection Pool: Initialization, Retrieval, and Recycling Explained
Zhuanzhuan Tech
Zhuanzhuan Tech
Jan 9, 2025 · Databases

Understanding Druid Connection Pool: Initialization, Connection Acquisition, Execution, and Recycling

This article provides a comprehensive technical walkthrough of the Druid database connection pool, covering its architecture, initialization flow, connection acquisition and release mechanisms, execution and exception handling, as well as recommended configurations and monitoring practices for optimal performance.

Connection PoolDatabaseDruid
0 likes · 23 min read
Understanding Druid Connection Pool: Initialization, Connection Acquisition, Execution, and Recycling
macrozheng
macrozheng
Oct 8, 2024 · Backend Development

Mastering Batch Updates in MyBatis: From foreach to ON DUPLICATE KEY

This article explores four common batch‑update techniques in MyBatis, compares their performance, shows how to configure Druid and Spring Boot to allow multi‑statement execution, and provides practical code examples and configuration tips for reliable large‑scale data updates.

Batch UpdateDruidMyBatis
0 likes · 11 min read
Mastering Batch Updates in MyBatis: From foreach to ON DUPLICATE KEY
Su San Talks Tech
Su San Talks Tech
Sep 25, 2024 · Backend Development

Mastering Batch Updates in MyBatis: From foreach to ON DUPLICATE KEY

This article walks through practical ways to perform batch updates in MyBatis, compares foreach, case‑when, and INSERT…ON DUPLICATE KEY techniques, explains common Druid WallFilter restrictions, and shows how to enable multi‑statement execution via JDBC and Spring configuration.

Batch UpdateDruidSQL
0 likes · 13 min read
Mastering Batch Updates in MyBatis: From foreach to ON DUPLICATE KEY
Deepin Linux
Deepin Linux
Aug 8, 2024 · Databases

Understanding Database Connection Pools: Principles, Mechanisms, and Popular Implementations

This article explains the concept of database connection pools, why they are needed, their core principles and runtime mechanisms, compares traditional direct connections with pooled connections, and reviews major Java pool implementations such as DBCP, C3P0, Druid and HikariCP along with configuration tips and best‑practice considerations.

C3P0Connection PoolDBCP
0 likes · 27 min read
Understanding Database Connection Pools: Principles, Mechanisms, and Popular Implementations
Wukong Talks Architecture
Wukong Talks Architecture
Aug 6, 2024 · Databases

Migrating Tencent Music's Data Infrastructure from ClickHouse and Druid to StarRocks: Strategy, Implementation, and Best Practices

This article details how Tencent Music’s data‑infrastructure team migrated thousands of ClickHouse and Druid nodes to a StarRocks compute‑storage‑separated lakehouse, achieving 40‑50% cost reduction while maintaining query performance, and shares the technical challenges, solutions, and best‑practice recommendations gathered during the process.

ClickHouseCost ReductionData Migration
0 likes · 19 min read
Migrating Tencent Music's Data Infrastructure from ClickHouse and Druid to StarRocks: Strategy, Implementation, and Best Practices
Selected Java Interview Questions
Selected Java Interview Questions
Jun 24, 2024 · Backend Development

Using Alibaba Druid Connection Pool in Spring Boot: Configuration, Monitoring, and Customization

This article provides a comprehensive guide on integrating Alibaba's Druid connection pool into Spring Boot applications, covering its advantages, dependency setup, detailed configuration properties, built‑in filters, monitoring pages, ad removal techniques, and programmatic access to runtime statistics.

Connection PoolDruidJava
0 likes · 13 min read
Using Alibaba Druid Connection Pool in Spring Boot: Configuration, Monitoring, and Customization
IT Architects Alliance
IT Architects Alliance
Jun 23, 2024 · Databases

Configuring Druid DataSource Monitoring and Filters in Spring Boot

This guide explains the fundamentals of Druid as a Java database connection pool, how to add required Maven dependencies, configure various Druid properties and filters for SQL and web monitoring, enable slow‑SQL logging, integrate Spring AOP monitoring, remove the default Alibaba advertisement, and retrieve monitoring data via the DruidStatManagerFacade API.

Connection PoolDatabase MonitoringDruid
0 likes · 14 min read
Configuring Druid DataSource Monitoring and Filters in Spring Boot
Architect
Architect
Jun 22, 2024 · Backend Development

Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources

This guide explains how to integrate Alibaba's Druid connection pool into Spring Boot, covering basic concepts, Maven dependencies, essential configuration properties, built‑in filters, monitoring pages, SQL and slow‑query logging, Spring AOP monitoring, ad removal, and programmatic access to Druid statistics.

Connection PoolDatabase MonitoringDruid
0 likes · 16 min read
Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources
Architect
Architect
Dec 16, 2023 · Databases

Detailed Walkthrough of Druid Connection Pool Lifecycle and Configuration

This article provides an in‑depth analysis of Druid's connection‑pool lifecycle, covering initialization, connection acquisition, validation, eviction, keep‑alive, and recycling processes, while offering performance‑related configuration recommendations and code examples for Java developers.

Connection PoolDruidJava
0 likes · 24 min read
Detailed Walkthrough of Druid Connection Pool Lifecycle and Configuration
Su San Talks Tech
Su San Talks Tech
Nov 8, 2023 · Databases

Speed Up Your SpringBoot App with Druid Connection Pool and SQL Optimization

The article walks through diagnosing a 10‑second backend loading delay, explains connection‑pool concepts, introduces Alibaba's Druid pool with its monitoring UI, shows how to identify and optimize slow SQL queries using DISTINCT and indexes, and provides step‑by‑step SpringBoot integration instructions.

DatabaseDruidSQL optimization
0 likes · 16 min read
Speed Up Your SpringBoot App with Druid Connection Pool and SQL Optimization
vivo Internet Technology
vivo Internet Technology
Aug 2, 2023 · Operations

sFlow-Based Network Traffic Analysis System Design and Implementation

The paper presents a scalable sFlow‑based traffic analysis system that combines high‑performance agents, collectors, and analyzers—extending Elastiflow with sFlowtool, Logstash, Kafka, and Elasticsearch/Kibana, while adding CMDB integration, Druid storage, and Celery stream processing to achieve sub‑30‑second latency for data‑center monitoring, anomaly detection, and IP‑level analytics, and discusses future needs for broader protocol support and adaptive collection.

DruidELKNetwork Monitoring
0 likes · 12 min read
sFlow-Based Network Traffic Analysis System Design and Implementation
21CTO
21CTO
Jul 17, 2023 · Big Data

How WeChat Cut Query Latency from Seconds to 100 ms with Druid Optimizations

This case study explains how the WeChat multi‑dimensional monitoring platform identified performance bottlenecks in its Druid‑based data layer, analyzed user query patterns, and applied sub‑query splitting, Redis caching, and segment size reductions to achieve over 85% cache‑hit rates and bring average query latency down to around 100 ms.

Big DataCachingDruid
0 likes · 13 min read
How WeChat Cut Query Latency from Seconds to 100 ms with Druid Optimizations
ITPUB
ITPUB
Jul 16, 2023 · Big Data

How WeChat Reduced Query Latency from 1000ms to 100ms in Its Multi‑Dimensional Monitoring Platform

This article explains how the WeChat multi‑dimensional monitoring platform, which processes billions of data points daily, identified performance bottlenecks in its Druid‑based data layer and applied sub‑query splitting, Redis caching, and sub‑dimension tables to achieve over 85% cache hit rate and bring average query time down to around 100 ms.

Big DataDruidPerformance Optimization
0 likes · 13 min read
How WeChat Reduced Query Latency from 1000ms to 100ms in Its Multi‑Dimensional Monitoring Platform
dbaplus Community
dbaplus Community
Jun 25, 2023 · Big Data

WeChat’s 10× Query Speedup: From 1000ms to 100ms with Druid & Redis

WeChat’s multi‑dimensional monitoring platform faced severe query latency and I/O bottlenecks, so the team analyzed user behavior and Druid architecture, then introduced sub‑query splitting, Redis caching, and segment size reductions, achieving over 85% cache hit rate and reducing average query time to around 100 ms.

Big DataCacheDruid
0 likes · 12 min read
WeChat’s 10× Query Speedup: From 1000ms to 100ms with Druid & Redis
Architect
Architect
Jun 23, 2023 · Big Data

Optimizing Query Performance in WeChat's Multi‑Dimensional Monitoring Platform

This article details how the WeChat multi‑dimensional monitoring platform reduced average query latency from over 1000 ms to around 100 ms by analyzing user query patterns, redesigning the Druid data layer, splitting sub‑queries, introducing Redis caching, and employing sub‑dimension tables, achieving cache hit rates above 85%.

DruidMonitoringPerformance
0 likes · 13 min read
Optimizing Query Performance in WeChat's Multi‑Dimensional Monitoring Platform
Didi Tech
Didi Tech
Jun 14, 2023 · Big Data

Real-Time Data Development Practices and Component Selection at Didi

Didi’s unified real‑time data stack outlines best‑practice component choices for four key scenarios—metric monitoring, BI analysis, online services, and feature/tag systems—detailing pipelines from source to sink, resource‑usage guidelines, and a one‑stop development platform to build stable, high‑performance streaming solutions.

ClickHouseDruidFlink
0 likes · 17 min read
Real-Time Data Development Practices and Component Selection at Didi
FunTester
FunTester
Jun 7, 2023 · Big Data

Optimizing Query Performance in WeChat's Multi‑Dimensional Monitoring Platform with Druid and Redis

The article details how WeChat's multi‑dimensional metric monitoring platform, which handles billions of data points per minute, reduced average query latency from over 1000 ms to around 140 ms and achieved over 85% cache hit rate by analyzing query behavior, redesigning the data layer architecture, splitting queries into sub‑queries, adding Redis caching, and introducing sub‑dimension tables.

Big DataCacheDruid
0 likes · 13 min read
Optimizing Query Performance in WeChat's Multi‑Dimensional Monitoring Platform with Druid and Redis
Tencent Cloud Developer
Tencent Cloud Developer
May 31, 2023 · Big Data

Performance Optimization of WeChat's Multi‑Dimensional Monitoring Platform

By analyzing that most queries were time‑series and older than a day, the WeChat monitoring team split large Druid queries into per‑day/hour sub‑queries, introduced a multi‑granularity Redis cache and sub‑dimension tables, boosting cache hits above 85 % and cutting average latency from over 1000 ms to about 140 ms while reducing Druid load to roughly 10 % of its original volume.

CachingDruidMonitoring
0 likes · 13 min read
Performance Optimization of WeChat's Multi‑Dimensional Monitoring Platform
Java Architect Essentials
Java Architect Essentials
Apr 16, 2023 · Databases

Alibaba Druid Connection Pool in Spring Boot: Concepts, Configuration, Monitoring and Customization

This article introduces Alibaba's Druid database connection pool, explains its core features and filters, shows how to add the Maven starter, configure properties and filters in Spring Boot, demonstrates the built‑in monitoring pages, slow‑SQL logging, Spring AOP integration, and provides methods to remove the default advertisement and retrieve monitoring data via code.

Connection PoolDruidMonitoring
0 likes · 16 min read
Alibaba Druid Connection Pool in Spring Boot: Concepts, Configuration, Monitoring and Customization
dbaplus Community
dbaplus Community
Jan 10, 2023 · Big Data

Choosing the Right OLAP Engine: Druid vs ClickHouse and Optimization Tips

This article introduces OLAP concepts, compares major OLAP solutions such as Druid, Kylin, Doris, and ClickHouse, outlines their features and suitable scenarios, and shares practical optimization techniques—including materialized views, caching, node tiering, and query tuning—to improve performance for high‑concurrency analytical workloads.

Big DataClickHouseData Warehouse
0 likes · 16 min read
Choosing the Right OLAP Engine: Druid vs ClickHouse and Optimization Tips
ITPUB
ITPUB
Jan 2, 2023 · Databases

Choosing the Right OLAP Engine: Druid vs ClickHouse and Optimization Tips

This article introduces OLAP concepts, compares major OLAP engines such as Druid, Kylin, Doris, and ClickHouse, outlines real‑world application scenarios, and provides detailed optimization techniques—including materialized views, caching, tiered storage, and skip‑index configurations—to improve query performance.

AnalyticsClickHouseData Warehouse
0 likes · 16 min read
Choosing the Right OLAP Engine: Druid vs ClickHouse and Optimization Tips
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 21, 2022 · Big Data

OLAP Technology Overview, Selection, and Optimization Practices

This article introduces OLAP concepts, compares ROLAP, MOLAP, and HOLAP, evaluates mainstream OLAP engines such as Druid, Kylin, Doris, and ClickHouse, and presents practical optimization techniques including materialized views, caching, tiered storage, and query tuning for large‑scale analytical workloads.

ClickHouseData WarehouseDruid
0 likes · 17 min read
OLAP Technology Overview, Selection, and Optimization Practices
DataFunTalk
DataFunTalk
Dec 19, 2022 · Big Data

Evolution of OLAP: Key Technologies, Engine Comparison, and Future Trends

This article provides a comprehensive overview of OLAP technology evolution, covering its origins, modern requirements for massive and real‑time data, detailed comparisons of major open‑source OLAP engines such as Druid, Elasticsearch, Kylin, Doris/StarRocks, and ClickHouse, core architectural and storage techniques, and emerging trends like federated queries, hybrid storage, and lakehouse integration.

ClickHouseDruidOLAP
0 likes · 22 min read
Evolution of OLAP: Key Technologies, Engine Comparison, and Future Trends
Code Ape Tech Column
Code Ape Tech Column
Nov 28, 2022 · Backend Development

Resolving Long Transactions and Connection‑Closed Issues in Spring with Druid

This article analyzes why a Spring service encounters "connection closed" errors during long‑running transactions, explains how MyBatis and Druid manage connections, and provides a programmatic‑transaction solution that splits large operations into smaller units to prevent connection leaks and timeouts.

Backend DevelopmentDatabase ConnectionDruid
0 likes · 11 min read
Resolving Long Transactions and Connection‑Closed Issues in Spring with Druid
Code Ape Tech Column
Code Ape Tech Column
Oct 26, 2022 · Databases

In‑Depth Analysis of Druid Connection‑Pool Lifecycle and Internal Processes

This article provides a comprehensive walkthrough of Druid's connection‑pool architecture, detailing the initialization, acquisition, validation, eviction, and recycling of connections, while explaining key configuration options, thread‑safety mechanisms, and performance considerations for Java database applications.

Connection PoolDatabaseDruid
0 likes · 23 min read
In‑Depth Analysis of Druid Connection‑Pool Lifecycle and Internal Processes
Huolala Tech
Huolala Tech
Oct 13, 2022 · Big Data

How Druid Uses Bitmap Indexes for Fast Queries and Precise Deduplication

This article explains how Apache Druid builds and queries bitmap indexes for efficient OLAP analysis, and describes a dictionary‑encoding plus bitmap solution—adapted from Kuaishou—to achieve exact deduplication even on high‑cardinality dimensions.

Bitmap IndexDictionary EncodingDruid
0 likes · 14 min read
How Druid Uses Bitmap Indexes for Fast Queries and Precise Deduplication
DataFunTalk
DataFunTalk
Sep 1, 2022 · Big Data

Evolution and Construction of Huolala's OLAP System Based on Doris

This presentation details Huolala's journey from its initial OLAP architecture to a multi‑engine platform, describing background, data‑flow layers, technical research, engine selection (Druid, ClickHouse, Doris), POC validation, performance tuning, stability measures, production rollout, problem analysis, and future roadmap.

ClickHouseDruidHuolala
0 likes · 17 min read
Evolution and Construction of Huolala's OLAP System Based on Doris
Shopee Tech Team
Shopee Tech Team
Aug 18, 2022 · Cloud Native

Shopee Druid Cloud Native Architecture Evolution: Design and Implementation

Shopee transformed its Druid analytics platform from a fragile physical‑machine setup into a cloud‑native, Kubernetes‑orchestrated solution that adds independent clusters, automatic scaling, traffic management, GitOps‑driven deployment, and container isolation, delivering higher stability, efficiency, lower cost, and stronger security alongside integrated monitoring and visualization tools.

DruidKubernetesMonitoring
0 likes · 20 min read
Shopee Druid Cloud Native Architecture Evolution: Design and Implementation
Youzan Coder
Youzan Coder
Jul 7, 2022 · Big Data

Optimizing Apache Doris Performance: A Case Study in Query Processing

Youzan replaced ClickHouse and Druid with Apache Doris, refined its vectorized engine by eliminating deserialization overhead in the merge‑aggregation phase, achieving roughly a 30 % query‑time boost, and validated compatibility through SQL rewriting and traffic replay, while planning further SIMD‑based optimizations and broader adoption.

Apache DorisClickHouseDruid
0 likes · 8 min read
Optimizing Apache Doris Performance: A Case Study in Query Processing
Architect's Tech Stack
Architect's Tech Stack
Jun 28, 2022 · Backend Development

Using Alibaba Druid Connection Pool with Spring Boot: Dependencies, Configuration, Monitoring, and Customization

This article explains how to integrate Alibaba's Druid database connection pool into a Spring Boot application, covering Maven dependencies, YAML configuration, built‑in filters, monitoring pages, ad removal techniques, and programmatic access to Druid statistics for comprehensive backend performance management.

Database Connection PoolDruidJava
0 likes · 14 min read
Using Alibaba Druid Connection Pool with Spring Boot: Dependencies, Configuration, Monitoring, and Customization
Zhuanzhuan Tech
Zhuanzhuan Tech
Jun 23, 2022 · Databases

Resolving Connection Invalidations in MySQL Read/Write Splitting with Druid and ReplicationConnection

This article analyzes why MySQL connections become invalid when using Druid with ReplicationConnection for read/write splitting, explains the underlying proxy mechanics, and presents a practical solution by extending MySqlValidConnectionChecker to correctly validate both master and slave connections.

Connection ValidationDruidReplicationConnection
0 likes · 10 min read
Resolving Connection Invalidations in MySQL Read/Write Splitting with Druid and ReplicationConnection
政采云技术
政采云技术
Jun 14, 2022 · Backend Development

Performance Testing, Response Time Analysis, and Database Connection Pool Optimization for a Multi‑Table Query Service

This article presents a comprehensive performance testing case study of a multi‑table database query interface, detailing common performance metrics, response‑time classifications, step‑by‑step load‑test results, root‑cause analysis of CPU, memory, and connection‑pool bottlenecks, and demonstrates how tuning Druid’s maxActive and maxWait parameters optimizes throughput and reduces latency.

Database Connection PoolDruidMyBatis
0 likes · 12 min read
Performance Testing, Response Time Analysis, and Database Connection Pool Optimization for a Multi‑Table Query Service
vivo Internet Technology
vivo Internet Technology
May 25, 2022 · Big Data

Understanding Druid Metadata Management and Architecture

Apache Druid manages metadata through a layered, distributed system where the Overlord coordinates ingestion tasks, MiddleManagers launch Peons to create segments, Coordinators and Historical nodes store and serve segment data, Brokers route queries, while MySQL, Zookeeper, memory, and local files synchronize metadata for fault‑tolerant, high‑performance OLAP analytics.

Big DataDruidMetadata Management
0 likes · 19 min read
Understanding Druid Metadata Management and Architecture
Code Ape Tech Column
Code Ape Tech Column
Mar 17, 2022 · Databases

Understanding the Druid Connection Pool Lifecycle and Management

This article provides a comprehensive walkthrough of Druid's connection pool lifecycle, detailing how getConnection initiates the process, the role of initialization, filter chains, connection validation, thread‑blocking strategies, and the various guardian threads that add, evict, and recycle connections to ensure performance and stability.

Connection PoolDatabaseDruid
0 likes · 24 min read
Understanding the Druid Connection Pool Lifecycle and Management
Java Architect Essentials
Java Architect Essentials
Feb 28, 2022 · Databases

Configuring Alibaba Druid DataSource and Monitoring in Spring Boot

This article explains the fundamentals of Alibaba Druid as a Java database connection pool, shows how to add Maven dependencies, configure properties and filters in Spring Boot, set up monitoring pages, remove built‑in ads, and retrieve runtime statistics via DruidStatManagerFacade.

Database Connection PoolDruidMonitoring
0 likes · 15 min read
Configuring Alibaba Druid DataSource and Monitoring in Spring Boot
Top Architect
Top Architect
Feb 19, 2022 · Databases

Comprehensive Guide to Configuring Druid DataSource in Spring Boot

This article provides a detailed tutorial on Druid, the Alibaba‑developed Java database connection pool, covering its core concepts, Maven dependencies, extensive Spring Boot configuration options, filter setup, monitoring UI, SQL and slow‑query logging, ad removal techniques, and programmatic access to monitoring data.

DruidJavaSpring Boot
0 likes · 15 min read
Comprehensive Guide to Configuring Druid DataSource in Spring Boot
dbaplus Community
dbaplus Community
Jul 11, 2021 · Big Data

Scaling Real‑Time & Offline Analytics with Druid: Architecture, Optimizations, and Lessons

This article explains how Beike adopted the Druid OLAP engine to handle massive real‑time and offline query workloads, detailing its four‑component architecture, key technologies such as deep storage and metadata storage, practical optimizations for data ingestion, query caching, dynamic throttling, timeout control, and a roadmap for future enhancements.

Big DataDruidOLAP
0 likes · 19 min read
Scaling Real‑Time & Offline Analytics with Druid: Architecture, Optimizations, and Lessons
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 5, 2021 · Databases

Integrating Alibaba Druid Connection Pool with Spring Boot: Configuration and Monitoring Guide

This article provides a comprehensive guide on integrating the Alibaba Druid JDBC connection pool into a Spring Boot application, covering its components, powerful monitoring features, password encryption, SQL parsing, Maven and YAML configuration, filter setup, and how to access the Druid monitoring console.

Database Connection PoolDruidMonitoring
0 likes · 11 min read
Integrating Alibaba Druid Connection Pool with Spring Boot: Configuration and Monitoring Guide
Youzan Coder
Youzan Coder
Jun 23, 2021 · Industry Insights

How Youzan Built a Real‑Time Data Warehouse: Architecture, ETL, and Use Cases

This article details Youzan's end‑to‑end experience building a real‑time data warehouse, covering background, application scenarios, layered architecture, streaming ETL techniques, data validation, recovery processes, and three production projects that illustrate the solution in action.

ClickHouseDruidFlinkSQL
0 likes · 18 min read
How Youzan Built a Real‑Time Data Warehouse: Architecture, ETL, and Use Cases
macrozheng
macrozheng
May 17, 2021 · Databases

Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested

This article introduces the importance of database connections, compares three popular Java connection pools (DBCP, C3P0, Druid) with code examples, runs performance tests inserting 100 k and 1 M rows on MySQL, Oracle and PostgreSQL, and concludes with recommendations on the most stable pool and optimal databases.

Connection PoolDatabaseDruid
0 likes · 11 min read
Which Java Connection Pool Wins? Druid vs C3P0 vs DBCP Performance Tested
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 7, 2021 · Databases

Resolving MySQL wait_timeout Issues with Druid Connection Pool Configuration

This article analyzes the root causes of MySQL 'wait_timeout' related exceptions in a backend system using MHA read/write separation, explains how oversized connection pool timeout settings and MySQL wait_timeout lead to idle connections being closed, and provides practical Druid configuration adjustments and alternative solutions to eliminate the errors.

Connection PoolDruidJDBC
0 likes · 7 min read
Resolving MySQL wait_timeout Issues with Druid Connection Pool Configuration
Big Data Technology Architecture
Big Data Technology Architecture
Mar 30, 2021 · Big Data

Beike OLAP Platform: Druid Adoption, Architecture, Performance Comparison, and Operational Optimizations

The article details Beike's OLAP platform built on Druid, covering its four‑layer architecture, selection criteria, performance comparisons with Kylin, data ingestion workflows, custom improvements for data import and real‑time distinct counting, and operational measures such as caching, dynamic throttling, and HDFS storage optimization.

BeikeData PlatformDruid
0 likes · 18 min read
Beike OLAP Platform: Druid Adoption, Architecture, Performance Comparison, and Operational Optimizations
DataFunTalk
DataFunTalk
Mar 29, 2021 · Big Data

Beike's OLAP Platform: Druid Adoption, Architecture, Performance Comparison, and Operational Optimizations

This article details Beike's large‑scale OLAP platform, explaining why Druid was chosen over Kylin, describing the platform's four‑layer architecture, presenting performance and storage benchmarks, and outlining practical improvements to data ingestion, real‑time distinct counting, and cluster stability for high‑concurrency business scenarios.

Big DataDruidOLAP
0 likes · 19 min read
Beike's OLAP Platform: Druid Adoption, Architecture, Performance Comparison, and Operational Optimizations
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 8, 2021 · Information Security

How to Encrypt MySQL Passwords in Spring Boot Using Alibaba Druid

This article explains why database passwords should be encrypted, introduces Alibaba's Druid as a simple solution for Java Spring Boot projects, and provides step‑by‑step instructions—including generating ciphertext with ConfigTools, configuring application.yml, and securely handling public keys—to protect MySQL credentials.

ConfigToolsDruidJava
0 likes · 10 min read
How to Encrypt MySQL Passwords in Spring Boot Using Alibaba Druid
dbaplus Community
dbaplus Community
Jan 11, 2021 · Databases

Why eBay Switched Its Ad Analytics from Druid to ClickHouse – A Deep Dive

eBay’s ad data platform, originally built on a custom SQL engine and later migrated to Druid, was re‑engineered to use ClickHouse, highlighting challenges such as massive data volume, atomic offline replacements, schema design, compression, and operational simplifications, and demonstrating performance and scalability gains for advertisers.

Ad AnalyticsBig DataClickHouse
0 likes · 18 min read
Why eBay Switched Its Ad Analytics from Druid to ClickHouse – A Deep Dive
DataFunSummit
DataFunSummit
Dec 11, 2020 · Big Data

58.com Big Data Application Practice: Architecture, Challenges, and Solutions

This article presents 58.com’s large‑scale big data platform, detailing its business scope, the WMDA one‑stop analytics system, the Wanxiang user‑portrait service, the technical challenges of massive daily data ingestion, multi‑dimensional analysis, OLAP engine selection (Kylin, Druid), bitmap‑based user‑group processing, scheduling, and overall data service architecture.

Data PlatformDruidKylin
0 likes · 13 min read
58.com Big Data Application Practice: Architecture, Challenges, and Solutions
Beike Product & Technology
Beike Product & Technology
Nov 18, 2020 · Big Data

Evolution and Practice of BEIKE OLAP Platform Architecture and Engine Selection

This article details the three‑stage evolution of BEIKE's OLAP platform—from the early Hive‑to‑MySQL phase, through a Kylin‑based architecture, to a flexible multi‑engine design—explaining metric modeling, engine selection, performance trade‑offs, and future roadmap for supporting Druid, ClickHouse, Doris and real‑time analytics.

Data WarehouseDruidEngine Selection
0 likes · 18 min read
Evolution and Practice of BEIKE OLAP Platform Architecture and Engine Selection
iQIYI Technical Product Team
iQIYI Technical Product Team
Nov 6, 2020 · Big Data

Recommended Technical Articles: iQiyi Effect Advertising Exploration and Druid Practice

This recommendation highlights two iTech Forum pieces—one detailing iQiyi’s effect advertising exploration and implementation, and another documenting the company’s Druid practice and technical evolution—providing readers with in‑depth case studies, performance insights, and practical guidance for similar large‑scale data and advertising systems.

AdvertisingBig DataData Analytics
0 likes · 1 min read
Recommended Technical Articles: iQiyi Effect Advertising Exploration and Druid Practice
Senior Brother's Insights
Senior Brother's Insights
Oct 21, 2020 · Backend Development

Why SpringBoot’s Default Druid Settings Fail and How to Fix Them

The article explains how default Druid connection‑pool settings in a SpringBoot project can leave the pool uninitialized, shows the hidden pitfalls, and provides the exact Maven dependencies and configuration properties needed to correctly enable and tune Druid, including enabling its monitoring console.

DatabaseConnectionPoolDruidJava
0 likes · 8 min read
Why SpringBoot’s Default Druid Settings Fail and How to Fix Them
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 15, 2020 · Databases

Resolving MySQL wait_timeout and JDBC Connection‑Pool Exceptions with Druid Configuration

This article analyses the root cause of generic "exception" errors during article publishing caused by mismatched MySQL wait_timeout and Druid JDBC pool settings, explains the impact of these parameters, and provides step‑by‑step configuration adjustments and alternative solutions to stabilise the backend database connection pool.

Connection PoolDatabase OptimizationDruid
0 likes · 6 min read
Resolving MySQL wait_timeout and JDBC Connection‑Pool Exceptions with Druid Configuration
Programmer DD
Programmer DD
Aug 21, 2020 · Backend Development

Mastering SpringBoot: Multi-DataSource, Druid Pool, and PageHelper Pagination

This tutorial walks through integrating SpringBoot with MyBatis, configuring the Druid connection pool, setting up multiple data sources, and enabling pagination using PageHelper, complete with Maven dependencies, property files, Java configuration classes, and sample API requests and responses.

DruidMulti-DataSourceMyBatis
0 likes · 18 min read
Mastering SpringBoot: Multi-DataSource, Druid Pool, and PageHelper Pagination
Youzan Coder
Youzan Coder
Jul 8, 2020 · Backend Development

Druid Connection Pool Performance Optimization: Fair Lock vs Unfair Lock

The article explains how a Druid 1.1.20 connection pool was throttled to ~10k RPS by fair‑locking in recycle(), and how enabling the unfair lock (setUseUnfairLock(true)) doubled single‑machine TPS, raised CPU usage to near 100 % and boosted cluster throughput by about 70 %.

ArthasDatabaseDruid
0 likes · 7 min read
Druid Connection Pool Performance Optimization: Fair Lock vs Unfair Lock
Programmer DD
Programmer DD
May 20, 2020 · Backend Development

Why Does Druid Throw “Connection Holder Is Null” and How to Fix It?

This article examines recurring “connection holder is null” errors in Druid’s connection pool, explains how the holder is assigned and cleared, analyzes two real‑world cases—long‑running transactions and killed connections—and offers practical configuration recommendations to prevent the issue.

Connection PoolDatabaseDruid
0 likes · 7 min read
Why Does Druid Throw “Connection Holder Is Null” and How to Fix It?
Youzan Coder
Youzan Coder
Apr 15, 2020 · Databases

Optimizing Druid Connection Pool: Practical Configurations and Tuning Guide

This article explains how to size and tune Druid's connection pool for high‑traffic Java applications, covering pool‑size formulas, timeout settings, keep‑alive behavior, essential XML properties, and version recommendations to prevent misleading SQL latency and improve overall database stability.

Connection PoolDatabaseDruid
0 likes · 10 min read
Optimizing Druid Connection Pool: Practical Configurations and Tuning Guide
DataFunTalk
DataFunTalk
Mar 8, 2020 · Big Data

Real-Time Log Monitoring and Alerting System for iQIYI Membership Services

This article describes how iQIYI built a real‑time, multi‑dimensional log monitoring platform using Spark Streaming, Flink, Kafka and Druid to handle billions of logs, improve alerting accuracy, reduce incident response time, and outline future intelligent monitoring enhancements.

DruidFlinkLog Analytics
0 likes · 10 min read
Real-Time Log Monitoring and Alerting System for iQIYI Membership Services
Wukong Talks Architecture
Wukong Talks Architecture
Mar 4, 2020 · Backend Development

Integrating MyBatis with Spring Boot: Annotation and XML Configuration Guide

This tutorial explains how to integrate MyBatis into a Spring Boot project, covering the framework's basics, Maven dependencies, annotation‑based CRUD operations, XML‑based mappings, entity definitions, controller implementations, Swagger testing, and Druid monitoring, with complete code examples and download links.

Backend DevelopmentDruidJava
0 likes · 13 min read
Integrating MyBatis with Spring Boot: Annotation and XML Configuration Guide
58 Tech
58 Tech
Mar 4, 2020 · Big Data

Applying Flink State Management to Real‑Time Recommendation Scenarios

This article explains how Flink's flexible state management, including Broadcast, Keyed, and Operator states, can be used to solve real‑time recommendation challenges such as per‑minute UV, click, and exposure counting, while addressing locality mapping and data‑delay issues with Druid as the downstream store.

Broadcast StateDruidFlink
0 likes · 13 min read
Applying Flink State Management to Real‑Time Recommendation Scenarios
Programmer DD
Programmer DD
Feb 10, 2020 · Backend Development

How to Configure Druid DataSource and Monitoring in Spring Boot

This guide walks you through adding Alibaba's Druid connection pool to a Spring Boot project, configuring its properties, enabling built‑in monitoring via Actuator, and accessing the Druid dashboard to observe datasource and SQL performance metrics.

DataSourceDruidJDBC
0 likes · 12 min read
How to Configure Druid DataSource and Monitoring in Spring Boot
DataFunTalk
DataFunTalk
Jan 10, 2020 · Big Data

Design and Evolution of iQIYI's Real-Time Analytics Platform (RAP)

The article details iQIYI's Real-Time Analysis Platform (RAP), describing its motivation, architecture evolution from RAP 1.x to 2.x, OLAP engine selection, product design workflow, integration of Druid KIS and Flink, enhanced diagnostics, and real-world applications in membership monitoring, recommendation evaluation, and smart TV alerting.

DruidFlinkOLAP
0 likes · 12 min read
Design and Evolution of iQIYI's Real-Time Analytics Platform (RAP)
dbaplus Community
dbaplus Community
Dec 17, 2019 · Databases

Which Database Connection Pool Performs Best? A Real-World Multi-Threaded Test

This article presents a comprehensive multi‑threaded performance and safety evaluation of four popular database connection pools—Druid, JNDI, Tomcat, and Oracle UCP—across Tomcat, WebSphere, and JWS servers, detailing test setup, methodology, results, and best‑practice recommendations for proper pool usage.

Database Connection PoolDruidJDBC
0 likes · 9 min read
Which Database Connection Pool Performs Best? A Real-World Multi-Threaded Test