Tagged articles

Elasticsearch

1257 articles · Page 4 of 13
Su San Talks Tech
Su San Talks Tech
Nov 16, 2024 · Databases

Why MySQL Pagination Slows Down on Large Tables and How to Fix It

This article examines how pagination queries on massive MySQL tables become dramatically slower as the offset grows, defines what constitutes a slow SQL, and presents three practical optimization techniques—including returning only primary keys, range filtering, and using Elasticsearch—to dramatically improve query performance.

ElasticsearchMySQLPerformance
0 likes · 10 min read
Why MySQL Pagination Slows Down on Large Tables and How to Fix It
dbaplus Community
dbaplus Community
Nov 12, 2024 · Databases

How to Query Elasticsearch with SQL: A Step‑by‑Step Guide

This tutorial shows how to use Elasticsearch's built‑in SQL support to run familiar MySQL‑style queries—creating an index, inserting documents, and performing SELECT, WHERE, ORDER BY, GROUP BY, LIMIT, aggregation, date and string functions—making ES data retrieval as easy as relational databases.

Data RetrievalElasticsearchQuery DSL
0 likes · 7 min read
How to Query Elasticsearch with SQL: A Step‑by‑Step Guide
Sohu Tech Products
Sohu Tech Products
Nov 6, 2024 · Operations

Design and Implementation of a Business Operation Log Management System Using Canal and Elasticsearch

The article presents a decoupled business operation log management architecture that uses Alibaba’s Canal to capture MySQL binlog changes, streams them through Kafka, and stores structured before‑and‑after records in Elasticsearch with nested mappings, enabling multi‑table correlation via transaction IDs, visual querying, and reliable rollback without modifying application code.

CanalData PipelineElasticsearch
0 likes · 12 min read
Design and Implementation of a Business Operation Log Management System Using Canal and Elasticsearch
Programmer1970
Programmer1970
Nov 5, 2024 · Backend Development

RedisSearch vs Elasticsearch: Which Full‑Text Search Engine Fits Your Needs?

The article compares RedisSearch and Elasticsearch across definition, storage model, performance, query capabilities, scalability, ease of integration, and operational considerations, helping readers decide which solution best matches requirements such as real‑time response, data volume, query complexity, and existing tech stacks.

ElasticsearchFull-text SearchPerformance
0 likes · 7 min read
RedisSearch vs Elasticsearch: Which Full‑Text Search Engine Fits Your Needs?
ITPUB
ITPUB
Nov 5, 2024 · Operations

Master EFLK: Deep‑Inspection Guide for Elasticsearch, Filebeat, Logstash & Kibana

This guide presents a comprehensive, step‑by‑step deep‑inspection plan for the EFLK stack, covering Elasticsearch health checks, node performance metrics, shard and index monitoring, Logstash and Kibana validation, DSL query examples, and automated Python‑based metric collection with cron scheduling.

ElasticsearchKibanaLogstash
0 likes · 13 min read
Master EFLK: Deep‑Inspection Guide for Elasticsearch, Filebeat, Logstash & Kibana
Efficient Ops
Efficient Ops
Nov 4, 2024 · Cloud Native

Build an ELK Log Center for Docker Containers in Minutes

This guide walks you through setting up an ELK stack to collect, centralize, and visualize logs from Dockerized applications, covering rsyslog configuration, container deployment for Elasticsearch, Logstash, Kibana, and Nginx, and demonstrates verification via Kibana queries.

DockerELKElasticsearch
0 likes · 5 min read
Build an ELK Log Center for Docker Containers in Minutes
Top Architect
Top Architect
Nov 4, 2024 · Operations

Centralized Log Collection and Monitoring with Filebeat and Graylog

This article explains how to use Filebeat as a lightweight log shipper together with Graylog for centralized log aggregation, storage, and analysis, covering installation, configuration files, Docker deployment, Spring Boot integration, and query techniques for efficient operations monitoring.

DockerElasticsearchFilebeat
0 likes · 18 min read
Centralized Log Collection and Monitoring with Filebeat and Graylog
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Nov 3, 2024 · Big Data

How to Build a Scalable Business Operation Log System with Canal and Elasticsearch

This article walks through the design and implementation of a decoupled, high‑performance business operation log solution that captures MySQL binlog changes via Canal, streams them through Kafka, and stores and queries them in Elasticsearch, addressing challenges such as batch operations, multi‑table transactions, and non‑business data filtering.

CanalData PipelineElasticsearch
0 likes · 13 min read
How to Build a Scalable Business Operation Log System with Canal and Elasticsearch
Sohu Tech Products
Sohu Tech Products
Oct 30, 2024 · Operations

Comprehensive EFLK (Elasticsearch, Filebeat, Logstash, Kibana) Deep Inspection and Monitoring Guide

This comprehensive guide details a step‑by‑step deep‑inspection and monitoring strategy for an Elasticsearch‑Filebeat‑Logstash‑Kibana (EFLK) stack, covering cluster health, node and shard metrics, index status, query profiling, Filebeat, Logstash and Kibana validation, DSL query examples, and a Python script for automated metric collection.

EFLKElasticsearchFilebeat
0 likes · 12 min read
Comprehensive EFLK (Elasticsearch, Filebeat, Logstash, Kibana) Deep Inspection and Monitoring Guide
Architect
Architect
Oct 29, 2024 · Databases

Four Pagination Strategies: MySQL LIMIT OFFSET, Primary‑Key Filtering, HasMore Scrolling, and Elasticsearch

This article compares four pagination techniques—MySQL LIMIT OFFSET, LIMIT with primary‑key filtering, HasMore scrolling, and Elasticsearch pagination—explaining their implementations, advantages, drawbacks such as deep‑page performance issues, and recommending appropriate scenarios for each method.

ElasticsearchMySQLPagination
0 likes · 6 min read
Four Pagination Strategies: MySQL LIMIT OFFSET, Primary‑Key Filtering, HasMore Scrolling, and Elasticsearch
Top Architect
Top Architect
Oct 26, 2024 · Operations

Centralized Log Collection with Filebeat and Graylog

This article explains how to use Filebeat as a lightweight log shipper together with Graylog, Elasticsearch, and MongoDB to collect, process, and visualize logs from multiple environments, including detailed configuration examples, deployment scripts, and integration with Docker and Spring Boot.

DockerElasticsearchFilebeat
0 likes · 19 min read
Centralized Log Collection with Filebeat and Graylog
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Oct 24, 2024 · Backend Development

Full Elasticsearch 8.x Java API Client Code Ready for Immediate Project Use

This article walks through the new features of the Elasticsearch 8.x Java API client, shows how to set up the development environment, initialize the client with HTTPS or API‑key authentication, and provides complete, ready‑to‑run code examples for index creation, document indexing, searching, aggregations, and scripted sorting.

ElasticsearchElasticsearch 8.xJava
0 likes · 15 min read
Full Elasticsearch 8.x Java API Client Code Ready for Immediate Project Use
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Oct 23, 2024 · Cloud Computing

How Elasticsearch Serverless Cuts Log Analysis Costs by 50%

At the 2024 Cloud Xi Conference, Alibaba Cloud expert Jia Xinyu detailed how Elasticsearch Serverless addresses core log‑analysis pain points with out‑of‑the‑box, high‑performance, pay‑as‑you‑go capabilities, delivering significant cost savings and eliminating operational overhead.

Cloud ComputingElasticsearchPerformance
0 likes · 14 min read
How Elasticsearch Serverless Cuts Log Analysis Costs by 50%
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Oct 18, 2024 · Artificial Intelligence

Integrate Alibaba Cloud AI Search with Elasticsearch: A Step‑by‑Step Guide

This tutorial walks you through configuring Elasticsearch’s Open Inference API to connect with Alibaba Cloud AI Search, covering setup of text generation, rerank, sparse and dense vector services, and demonstrates end‑to‑end requests with code examples for building RAG and semantic search applications.

Alibaba Cloud AI SearchElasticsearchInference API
0 likes · 11 min read
Integrate Alibaba Cloud AI Search with Elasticsearch: A Step‑by‑Step Guide
Java Architecture Stack
Java Architecture Stack
Oct 15, 2024 · Backend Development

How to Build Powerful Search, Log, and Recommendation Solutions with Elasticsearch

This guide walks through five real‑world Elasticsearch use cases—including full‑text product search with highlighting, centralized log collection and analysis, personalized video recommendation, price‑range aggregation for e‑commerce, and geo‑location restaurant search—detailing index design, query syntax, Docker setup, and front‑end integration.

ElasticsearchFull-text SearchPrice Aggregation
0 likes · 35 min read
How to Build Powerful Search, Log, and Recommendation Solutions with Elasticsearch
Senior Tony
Senior Tony
Oct 12, 2024 · Backend Development

When Monolith Meets Microservices: API Composition vs CQRS for Complex Queries

This article compares API composition and CQRS patterns for handling distributed queries in evolving monolithic systems, illustrating their workflows with e‑commerce and online‑education examples, discussing performance trade‑offs, implementation details using Canal and ElasticSearch, and offering practical guidance on when to adopt each approach.

API compositionCQRSCanal
0 likes · 8 min read
When Monolith Meets Microservices: API Composition vs CQRS for Complex Queries
Programmer1970
Programmer1970
Oct 10, 2024 · Databases

Mastering Elasticsearch Aggregations: Metric, Bucket, and Pipeline Queries in Practice

This article explains Elasticsearch aggregation queries, covering metric, bucket, and pipeline aggregations, the role of doc_values and fielddata, multi‑field mapping, practical query examples such as terms, date_histogram, range, nested and pipeline aggregations, as well as sorting techniques and performance optimization tips.

AggregationsBucket AggregationElasticsearch
0 likes · 15 min read
Mastering Elasticsearch Aggregations: Metric, Bucket, and Pipeline Queries in Practice
macrozheng
macrozheng
Oct 8, 2024 · Databases

Why RediSearch Beats Elasticsearch on Low‑End Servers: A Hands‑On Comparison

This article introduces RediSearch, compares its memory usage and query performance with Elasticsearch on modest hardware, shows installation steps, demonstrates core index commands and Java integration, and concludes with practical advice on using RediSearch as a lightweight full‑text search engine.

ElasticsearchFull-text SearchJava
0 likes · 11 min read
Why RediSearch Beats Elasticsearch on Low‑End Servers: A Hands‑On Comparison
dbaplus Community
dbaplus Community
Sep 24, 2024 · Backend Development

How Ctrip Scaled Its Vacation Product Log System to Billions of Records

This article recounts the evolution of Ctrip's vacation product log platform—from a single‑table DB solution to a platformized ES + HBase architecture—detailing the challenges of massive data volume, the design of RowKey, write and query flows, and the subsequent business and supplier empowerment.

ElasticsearchHBasearchitecture
0 likes · 14 min read
How Ctrip Scaled Its Vacation Product Log System to Billions of Records
Wukong Talks Architecture
Wukong Talks Architecture
Sep 23, 2024 · Backend Development

Evolution of the Ctrip Travel Product Log System: Architecture, Challenges, and Solutions

This article describes the development trajectory of Ctrip's travel product log system, detailing its three major phases—from a single‑table DB approach to a platform‑based solution and finally an empowered version—while discussing technical challenges, design decisions, and the implementation of HBase, Elasticsearch, and related components to handle billions of log entries efficiently.

Big DataElasticsearchHBase
0 likes · 15 min read
Evolution of the Ctrip Travel Product Log System: Architecture, Challenges, and Solutions
HelloTech
HelloTech
Sep 20, 2024 · Big Data

Optimizing Elasticsearch Mapping to Reduce High CPU Usage: Challenges, Solutions, and Results

By refactoring the station‑profile index to eliminate over‑indexed and mis‑typed fields—cutting complex types from 282 to 74 and keywords from 67 to 59—the team lowered CPU peaks from 60 % to 50 %, reduced average CPU to 20 %, cut query latency to 150 ms, accelerated Flink sync to 10 minutes, and decommissioned two nodes, achieving substantial performance gains and cost savings.

CPU performanceElasticsearchIndexing
0 likes · 10 min read
Optimizing Elasticsearch Mapping to Reduce High CPU Usage: Challenges, Solutions, and Results
Code Farming
Code Farming
Sep 16, 2024 · Backend Development

Understanding Elasticsearch’s Document Retrieval Process

The article walks through Elasticsearch’s document retrieval workflow, covering single‑document GET, multi‑document mget, the two‑stage query_then_fetch mechanism, shard routing, load balancing, query and fetch phases, collectors, rescore, and pagination optimizations.

Document RetrievalElasticsearchQuery_then_fetch
0 likes · 19 min read
Understanding Elasticsearch’s Document Retrieval Process
Code Farming
Code Farming
Sep 15, 2024 · Backend Development

How Elasticsearch Indexes Documents: Step‑by‑Step Process

This article walks through Elasticsearch’s document indexing pipeline—from single‑document and bulk request routing, through the write‑refresh‑flush‑merge cycle, to the roles of Lucene, the translog, primary and replica shards, and how reliability, consistency, atomicity, isolation, real‑time visibility and performance are achieved.

Elasticsearchdocument indexingflush
0 likes · 22 min read
How Elasticsearch Indexes Documents: Step‑by‑Step Process
Code Farming
Code Farming
Sep 15, 2024 · Backend Development

Understanding Elasticsearch: Core Principles and Architecture

This article explains Elasticsearch’s overall structure, the underlying Lucene index layout, the indexing and search processing flow, and how built‑in analyzers work, illustrating each concept with diagrams, token examples, and query scenarios.

AnalyzersElasticsearchFull-text Search
0 likes · 10 min read
Understanding Elasticsearch: Core Principles and Architecture
Past Memory Big Data
Past Memory Big Data
Sep 13, 2024 · Backend Development

How Didi Scales Online Search with Elasticsearch: Architecture, Performance, and Stability

The article details Didi's comprehensive use of Elasticsearch across all online retrieval scenarios, covering its physical‑machine architecture, gateway and control layers, data synchronization methods, cross‑datacenter replication, JDK17 + ZGC performance upgrades, cost‑saving ZSTD compression, multi‑tenant isolation, custom security, and ongoing stability practices leading to a planned upgrade to Elasticsearch 8.13.

Cross‑Datacenter ReplicationDidiElasticsearch
0 likes · 16 min read
How Didi Scales Online Search with Elasticsearch: Architecture, Performance, and Stability
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Sep 10, 2024 · Artificial Intelligence

Unlocking AI Search with Alibaba Cloud Elasticsearch: Vectors, HNSW & RAG

This article details Alibaba Cloud Elasticsearch's AI search advancements, covering embedding vectors, HNSW-based approximate nearest neighbor search, hardware-accelerated vector engines, sparse vectors, hybrid retrieval, the Inference API, and RAG implementations that together boost performance, efficiency, and relevance for modern AI-driven search applications.

ElasticsearchHNSWRAG
0 likes · 11 min read
Unlocking AI Search with Alibaba Cloud Elasticsearch: Vectors, HNSW & RAG
DataFunSummit
DataFunSummit
Sep 4, 2024 · Artificial Intelligence

How Elasticsearch Powers Retrieval‑Augmented Generation (RAG) Applications

This article explains how Elasticsearch’s advanced search capabilities—including vector and semantic search, hardware acceleration, hybrid retrieval, model re‑ranking, multi‑vector support, and integrated security—enable robust RAG implementations and outlines future directions such as a new compute engine, stronger vector engines, and cloud‑native serverless deployment.

AIElasticsearchHybrid Search
0 likes · 9 min read
How Elasticsearch Powers Retrieval‑Augmented Generation (RAG) Applications
ITPUB
ITPUB
Sep 3, 2024 · Backend Development

Boost Query Speed from 20 s to 0.5 s with MQ‑Driven Elasticsearch Separation (Java)

A large table with tens of millions of rows caused 20‑second query times, but by decoupling reads through RabbitMQ and writing data asynchronously to Elasticsearch, query latency dropped to 500 ms, with Java code examples for both producer and consumer, sync handling, and migration tips.

ElasticsearchJavaQuery Optimization
0 likes · 6 min read
Boost Query Speed from 20 s to 0.5 s with MQ‑Driven Elasticsearch Separation (Java)
Efficient Ops
Efficient Ops
Sep 1, 2024 · Backend Development

Master Elasticsearch: From Basics to Advanced Performance Tuning

This article walks through Elasticsearch’s licensing history, version selection, installation, cluster health monitoring, shard routing, storage mechanisms, refresh and translog processes, segment merging, and practical performance optimizations such as disk choices, index settings, and JVM tuning.

ClusterElasticsearchIndexing
0 likes · 21 min read
Master Elasticsearch: From Basics to Advanced Performance Tuning
Top Architect
Top Architect
Aug 30, 2024 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Tools

This article examines various methods for synchronizing MySQL data with Elasticsearch, including synchronous and asynchronous dual‑write, Logstash pipelines, binlog real‑time replication, Canal, and Alibaba Cloud DTS, comparing their architectures, advantages, disadvantages, and suitable application scenarios.

Data synchronizationElasticsearchdatabases
0 likes · 17 min read
MySQL to Elasticsearch Data Synchronization Strategies and Tools
Alibaba Cloud Big Data AI Platform
Alibaba Cloud Big Data AI Platform
Aug 23, 2024 · Artificial Intelligence

How Elasticsearch Evolved into a Hybrid AI-Powered Search Engine

This article traces Elasticsearch's transformation from a pure text search engine to a versatile hybrid platform that integrates structured, geospatial, aggregation, and vector search capabilities, highlighting its AI-driven innovations, performance optimizations, and growing adoption across enterprises and academia.

AI SearchElasticsearchHybrid Search
0 likes · 13 min read
How Elasticsearch Evolved into a Hybrid AI-Powered Search Engine
Ctrip Technology
Ctrip Technology
Aug 22, 2024 · Backend Development

Evolution of Ctrip Vacation Product Log System: From Single‑Table DB to ES + HBase Platform

This article details the three‑stage evolution of Ctrip's vacation product log system—from a simple single‑table DB approach, through a platform‑based ES + HBase solution, to a scalable V3.0 architecture that improves storage, search, and business empowerment while handling billions of log entries.

Data PipelineElasticsearchbackend
0 likes · 16 min read
Evolution of Ctrip Vacation Product Log System: From Single‑Table DB to ES + HBase Platform
High Availability Architecture
High Availability Architecture
Aug 16, 2024 · Big Data

Introduction to Elasticsearch: Core Concepts, Query Types, Pagination, and Data Synchronization

This article provides a comprehensive overview of Elasticsearch, covering its distributed storage architecture, core data model concepts, analysis and query capabilities, practical next‑token pagination techniques, join strategies, and various data synchronization methods for integrating Elasticsearch with other systems.

Big DataData synchronizationElasticsearch
0 likes · 13 min read
Introduction to Elasticsearch: Core Concepts, Query Types, Pagination, and Data Synchronization
Efficient Ops
Efficient Ops
Aug 14, 2024 · Operations

Building a Real-Time Log Monitoring System with ELK, Kafka, and Python

This article details how to construct a log‑monitoring platform using the ELK stack, Kafka buffering, and a Python scheduler to collect, process, and alert on error logs, offering practical configuration tips and performance optimizations for production environments.

ELKElasticsearchKafka
0 likes · 10 min read
Building a Real-Time Log Monitoring System with ELK, Kafka, and Python
MaGe Linux Operations
MaGe Linux Operations
Aug 9, 2024 · Operations

Mastering Elasticsearch Data Sync and Cluster Architecture: Strategies & Best Practices

This article explains how to keep MySQL and Elasticsearch data in sync using synchronous calls, asynchronous notifications, or binlog listeners, and dives deep into Elasticsearch cluster design, node roles, distributed storage, query phases, split‑brain handling, and fault‑tolerance mechanisms.

Cluster ArchitectureData synchronizationDistributed Query
0 likes · 8 min read
Mastering Elasticsearch Data Sync and Cluster Architecture: Strategies & Best Practices
Top Architect
Top Architect
Aug 6, 2024 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Tools

This article explains various methods for synchronizing MySQL data to Elasticsearch, including synchronous and asynchronous double‑write, Logstash pipelines, binlog‑based real‑time sync, Canal, and Alibaba Cloud DTS, comparing their advantages, disadvantages, and suitable scenarios.

CanalDTSDataSync
0 likes · 16 min read
MySQL to Elasticsearch Data Synchronization Strategies and Tools
Open Source Tech Hub
Open Source Tech Hub
Aug 4, 2024 · Databases

Sync RDS MySQL Data to Alibaba Cloud Elasticsearch with DTS

This guide walks you through using Alibaba Cloud Data Transmission Service (DTS) to continuously synchronize production data from an RDS MySQL instance to an Elasticsearch cluster, covering prerequisites, task creation, verification, Kibana queries, and incremental sync testing.

Alibaba CloudDTSData synchronization
0 likes · 7 min read
Sync RDS MySQL Data to Alibaba Cloud Elasticsearch with DTS
Open Source Tech Hub
Open Source Tech Hub
Aug 1, 2024 · Databases

How to Sync MySQL Data to Elasticsearch: Strategies, Pros, and Pitfalls

This article explains why MySQL‑Elasticsearch synchronization is needed, compares six practical approaches—including sync write, async write, Logstash, binlog, Canal, and Alibaba Cloud DTS—detailing their implementation methods, advantages, disadvantages, and suitable use cases for large‑scale data environments.

CanalDTSData synchronization
0 likes · 13 min read
How to Sync MySQL Data to Elasticsearch: Strategies, Pros, and Pitfalls
Sohu Tech Products
Sohu Tech Products
Jul 31, 2024 · Databases

Elasticsearch ILM Migration Performance Optimization Strategies

To prevent IO saturation during Elasticsearch ILM hot‑to‑cold migrations, the article recommends batching migrations, fine‑tuning max_bytes_per_sec, upgrading cold‑node storage and adding hot nodes, and automating monitoring with scripts that pause or resume ILM based on real‑time utilization thresholds.

ElasticsearchILMbackend development
0 likes · 7 min read
Elasticsearch ILM Migration Performance Optimization Strategies
Open Source Tech Hub
Open Source Tech Hub
Jul 27, 2024 · Backend Development

Master Elasticsearch with PHP: From Basics to Real‑World Search Implementation

This guide explains why e‑commerce platforms need a high‑performance search engine, introduces Elasticsearch fundamentals, compares it with traditional engines, and provides step‑by‑step PHP code for installing, configuring, indexing, and querying data, complete with practical examples and best‑practice tips.

ElasticsearchFull-text SearchPHP
0 likes · 9 min read
Master Elasticsearch with PHP: From Basics to Real‑World Search Implementation
Su San Talks Tech
Su San Talks Tech
Jul 26, 2024 · Databases

Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools

This guide compares four MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous MQ‑based dual‑write, timer‑driven SQL extraction, and real‑time Binlog replication—and reviews popular CDC tools such as Canal, Alibaba Cloud DTS, Databus, and others to help you choose the right solution.

CDCCanalDTS
0 likes · 13 min read
Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools
Sohu Tech Products
Sohu Tech Products
Jul 17, 2024 · Backend Development

Mastering Elasticsearch: Painless Scripts for Advanced Array Operations

This article provides a step‑by‑step guide on using Elasticsearch’s Painless scripting language to create, index, and manipulate array‑type fields, covering basic operations like length and element access, as well as advanced aggregations, filtering, and weighted calculations, while highlighting performance considerations.

ArrayData ProcessingElasticsearch
0 likes · 9 min read
Mastering Elasticsearch: Painless Scripts for Advanced Array Operations
JD Cloud Developers
JD Cloud Developers
Jul 17, 2024 · Databases

Choosing the Right Database: MySQL, Redis, HBase, ClickHouse, MongoDB, Elasticsearch, Neo4j, Prometheus & Milvus Explained

Explore nine major database technologies—from traditional relational MySQL to NoSQL Redis, columnar HBase and ClickHouse, document-oriented MongoDB, search engine Elasticsearch, graph Neo4j, time‑series Prometheus, and vector Milvus—plus practical best‑practice guides, real‑world polyglot persistence scenarios, and recommended resources for mastering modern data storage.

ClickHouseElasticsearchHBase
0 likes · 50 min read
Choosing the Right Database: MySQL, Redis, HBase, ClickHouse, MongoDB, Elasticsearch, Neo4j, Prometheus & Milvus Explained
JD Tech Talk
JD Tech Talk
Jul 17, 2024 · Databases

A Comprehensive Guide to 9 Database Types and Polyglot Persistence

This article provides an in‑depth overview of nine major database categories—including relational, key‑value, columnar, document, graph, time‑series, and vector databases—detailing their strengths, weaknesses, best practices, and typical application scenarios, and explains how polyglot persistence combines multiple databases for optimal performance and scalability.

ClickHouseElasticsearchHBase
0 likes · 41 min read
A Comprehensive Guide to 9 Database Types and Polyglot Persistence
Volcano Engine Developer Services
Volcano Engine Developer Services
Jul 3, 2024 · Backend Development

How We Scaled a Billion‑Item Search Engine with Elasticsearch: From Zero to One

This article details the practical journey of building and scaling an Elasticsearch‑based search system that supports tens of millions to billions of items, covering architecture design, capacity planning, multi‑data‑center deployment, data synchronization via RocketMQ and Flink, and multi‑layer reconciliation to ensure consistency and high QPS.

ElasticsearchFlinkRocketMQ
0 likes · 15 min read
How We Scaled a Billion‑Item Search Engine with Elasticsearch: From Zero to One
JD Tech
JD Tech
Jul 2, 2024 · Big Data

Real‑Time Monitoring Dashboard for Logistics Supply Chain: Architecture, Data Modeling, and Stability Design

This article presents the design and implementation of a high‑availability, real‑time logistics supply‑chain monitoring dashboard, covering its data processing pipeline with Flink, storage choices between Elasticsearch and ClickHouse, multi‑layer architecture, metric consistency, stability mechanisms, extensibility configurations, and monitoring practices.

Big DataClickHouseDashboard
0 likes · 11 min read
Real‑Time Monitoring Dashboard for Logistics Supply Chain: Architecture, Data Modeling, and Stability Design
Open Source Linux
Open Source Linux
Jul 1, 2024 · Operations

Deploy a Full ELK Stack on a Single Ubuntu Server

This guide walks you through installing Java, Elasticsearch, Kibana, Logstash, and Filebeat on Ubuntu 18.04, configuring a dedicated data disk, adjusting service settings, and testing log collection with a complete script for a compact ELK demo environment.

ELKElasticsearchFilebeat
0 likes · 11 min read
Deploy a Full ELK Stack on a Single Ubuntu Server
Dangbei Technology Team
Dangbei Technology Team
Jun 28, 2024 · Backend Development

Boost Elasticsearch Prefix Search with Edge N‑Gram: A Practical Guide

This article explains how to overcome performance bottlenecks in high‑concurrency Elasticsearch prefix searches by applying an edge‑ngram tokenizer, detailing the problem, configuration steps, analysis results, and query recommendations for faster, more accurate search experiences.

Elasticsearchedge n-gramprefix search
0 likes · 10 min read
Boost Elasticsearch Prefix Search with Edge N‑Gram: A Practical Guide
dbaplus Community
dbaplus Community
Jun 25, 2024 · Databases

How Didi Scales Elasticsearch: Architecture, Performance Tuning, and Cost Optimization

This article details Didi’s use of Elasticsearch 7.6, covering its architecture on physical machines, gateway and control layers, user console features, deployment models, data synchronization strategies, engine iterations such as fine‑grained tiered protection, multi‑active replication, JDK 17/ZGC performance upgrades, cost reductions, multi‑tenant isolation, security enhancements, and future migration to ES 8.13.

DataSyncElasticsearchPerformance
0 likes · 17 min read
How Didi Scales Elasticsearch: Architecture, Performance Tuning, and Cost Optimization
IT Services Circle
IT Services Circle
Jun 24, 2024 · Databases

Understanding Elasticsearch Architecture: Inverted Index, Term Dictionary, Segments, and Distributed Search

This article explains how Elasticsearch transforms simple keyword matching into a high‑performance, scalable search engine by using inverted indexes, term dictionaries, posting lists, term indexes, stored fields, doc values, segments, and distributed node architectures to achieve fast, reliable full‑text search on massive data sets.

ElasticsearchLuceneSegment
0 likes · 16 min read
Understanding Elasticsearch Architecture: Inverted Index, Term Dictionary, Segments, and Distributed Search
Top Architect
Top Architect
Jun 17, 2024 · Backend Development

High‑Availability Architecture and Performance Optimization for a Large‑Scale Membership System

This article describes how a unified membership system serving billions of users across multiple platforms achieves high performance and high availability through dual‑center Elasticsearch clusters, traffic isolation, deep ES optimizations, Redis caching, dual‑center MySQL partitioning, seamless migration, and fine‑grained flow‑control and degradation strategies.

ElasticsearchRedisSystem Architecture
0 likes · 22 min read
High‑Availability Architecture and Performance Optimization for a Large‑Scale Membership System
Zhuanzhuan Tech
Zhuanzhuan Tech
Jun 12, 2024 · Databases

Designing a Scalable Persistence Layer: Sharding, Query Optimization, and Read/Write Splitting

This article shares a practical case study on how a coupon‑distribution system evolved from a single‑table design to a sharded, multi‑database architecture with query optimization, ElasticSearch integration, and read/write splitting to handle growing data volume, complex queries, and increasing request traffic.

Elasticsearchdatabasesread‑write splitting
0 likes · 12 min read
Designing a Scalable Persistence Layer: Sharding, Query Optimization, and Read/Write Splitting
IT Services Circle
IT Services Circle
Jun 12, 2024 · Databases

MySQL to Elasticsearch Data Synchronization: Strategies and Tool Selection

This article reviews four common MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous dual‑write via MQ, timer‑based SQL extraction, and real‑time Binlog replication—evaluates their pros and cons, and compares popular migration tools such as Canal, Alibaba DTS, Databus and others.

CDCData Migration ToolsData synchronization
0 likes · 11 min read
MySQL to Elasticsearch Data Synchronization: Strategies and Tool Selection
TAL Education Technology
TAL Education Technology
Jun 11, 2024 · Cloud Native

Containerizing Elasticsearch: Architecture Upgrade, API Gateway Integration, and Cloud‑Native Migration

This article details how a large‑scale Elasticsearch deployment was transformed from physical servers to a Kubernetes‑based, containerized architecture, addressing cost, scalability, API compatibility, security, observability, and multi‑cloud migration using the 极限网关 API gateway.

API GatewayElasticsearchKubernetes
0 likes · 11 min read
Containerizing Elasticsearch: Architecture Upgrade, API Gateway Integration, and Cloud‑Native Migration
MaGe Linux Operations
MaGe Linux Operations
Jun 10, 2024 · Cloud Native

Deploy NFS, ECK, Elasticsearch, Kibana & Filebeat on Kubernetes

This guide walks through installing NFS on all nodes, creating a dynamic storage class with Helm, setting up Elastic Cloud on Kubernetes (ECK) operator, deploying Elasticsearch and Kibana clusters, configuring Filebeat for log collection, and tuning system parameters for a production‑ready Kubernetes environment.

ECKElasticsearchFilebeat
0 likes · 18 min read
Deploy NFS, ECK, Elasticsearch, Kibana & Filebeat on Kubernetes
Su San Talks Tech
Su San Talks Tech
Jun 10, 2024 · Databases

Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools

This article compares four MySQL‑to‑Elasticsearch synchronization methods—synchronous dual‑write, asynchronous dual‑write, SQL extraction, and Binlog‑based real‑time sync—evaluates their pros and cons, and reviews popular migration tools such as Canal, Alibaba DTS, Databus, Flink, CloudCanal, Maxwell, and DRDS.

CDCData synchronizationElasticsearch
0 likes · 14 min read
Mastering MySQL‑to‑Elasticsearch Sync: 4 Strategies & Top Migration Tools
ZhongAn Tech Team
ZhongAn Tech Team
Jun 4, 2024 · Databases

Elasticsearch 8.x Performance Boosts, New Features, and Migration Guide

This article details how upgrading from Elasticsearch 5.x/2.x to 8.x dramatically improves search, aggregation, and write performance while reducing storage costs, introduces vector KNN, synthetic _source, TSDS, searchable snapshots, security enhancements, and provides migration examples and code snippets for enterprise search platforms.

Data MigrationElasticsearchHybrid Ranking
0 likes · 18 min read
Elasticsearch 8.x Performance Boosts, New Features, and Migration Guide
Code Ape Tech Column
Code Ape Tech Column
May 28, 2024 · Databases

Query Separation: A Practical Approach to Optimizing Large Table Reads

This article explains the concept of query separation, outlines its suitable scenarios, compares implementation methods such as synchronous, asynchronous, and binlog approaches, discusses storage system choices like MongoDB, HBase, and Elasticsearch, and addresses consistency and operational challenges when decoupling read workloads from write workloads.

ElasticsearchMQdata architecture
0 likes · 8 min read
Query Separation: A Practical Approach to Optimizing Large Table Reads
ITPUB
ITPUB
May 26, 2024 · Cloud Native

Containerizing Elasticsearch & ClickHouse on Kubernetes: Bilibili’s Scalable, Low‑Cost Solution

This article details Bilibili’s journey of containerizing Elasticsearch and ClickHouse on Kubernetes, covering the challenges of stateful services, architectural decisions, custom operators, storage and network solutions, deployment steps, observability enhancements, and the resulting cost, quality, and efficiency gains.

ClickHouseElasticsearchKubernetes
0 likes · 38 min read
Containerizing Elasticsearch & ClickHouse on Kubernetes: Bilibili’s Scalable, Low‑Cost Solution
MaGe Linux Operations
MaGe Linux Operations
May 23, 2024 · Big Data

Master Kibana: From Installation to Advanced Data Visualization

Learn how to install, configure, and connect Kibana with Elasticsearch, explore data using Discover, craft powerful queries with Lucene syntax, create visualizations and dashboards, and monitor your logs—all illustrated with step‑by‑step screenshots and practical tips for effective data analysis.

DashboardElasticsearchKibana
0 likes · 13 min read
Master Kibana: From Installation to Advanced Data Visualization
Su San Talks Tech
Su San Talks Tech
May 18, 2024 · Databases

Boost Large Table Queries with Query Separation: When and How to Implement

This article explains query separation as a strategy to accelerate slow large‑table queries by duplicating data to a dedicated query store, outlines when to adopt it, compares synchronous, asynchronous, and binlog approaches, discusses storage choices such as MongoDB, HBase, Elasticsearch, and addresses consistency and MQ challenges.

Asynchronous ReplicationElasticsearchMessage Queue
0 likes · 10 min read
Boost Large Table Queries with Query Separation: When and How to Implement
Didi Tech
Didi Tech
May 14, 2024 · Databases

Didi Elasticsearch Overview: Architecture, Deployment, Performance, and Operations

Didi’s Elasticsearch platform, built on ES 7.6 and deployed on physical machines with containerized gateway and control layers, provides a multi‑tenant, high‑performance search service—featuring a user console, operational controls, ZGC‑based latency reductions, cost‑saving compression, custom security, real‑time cross‑datacenter replication, and a roadmap toward ES 8.13.

Big DataDidiElasticsearch
0 likes · 17 min read
Didi Elasticsearch Overview: Architecture, Deployment, Performance, and Operations
Lobster Programming
Lobster Programming
May 9, 2024 · Backend Development

Detect Hot Items in High‑Concurrency Sales Using OpenResty, Kafka & Elasticsearch

During flash‑sale events like JD or Taobao, a tiny fraction of products generate the majority of traffic, causing server overload; this guide explains how to identify and collect hotspot product data in real time using an OpenResty‑Lua front‑end, Kafka for messaging, and Elasticsearch for storage and analysis.

ElasticsearchHot ItemsKafka
0 likes · 5 min read
Detect Hot Items in High‑Concurrency Sales Using OpenResty, Kafka & Elasticsearch
DataFunSummit
DataFunSummit
Apr 26, 2024 · Big Data

Didi's Big Data Cost Governance Practices

This article details Didi's comprehensive big data cost governance framework, covering its data architecture, asset management scoring, Hadoop and Elasticsearch cost optimization methods, and practical insights on organizational processes and incentives for effective cost control.

ElasticsearchHadoopResource Optimization
0 likes · 17 min read
Didi's Big Data Cost Governance Practices
Architect
Architect
Apr 25, 2024 · Backend Development

Design and Implementation of an Elasticsearch Data Synchronization Service (ECP)

This article describes the challenges of synchronizing billions of order records to Elasticsearch and presents the design, architecture, and key technical details of a generic data‑sync service (ECP) that supports multiple data sources, dynamic rate limiting, retry strategies, SPI‑based extensibility, environment isolation, health‑check, fault recovery, smooth migration, and elegant logging.

Data synchronizationDynamic Rate LimitingElasticsearch
0 likes · 22 min read
Design and Implementation of an Elasticsearch Data Synchronization Service (ECP)
macrozheng
macrozheng
Apr 25, 2024 · Backend Development

How to Upgrade the Mall Project to Spring Boot 3 & JDK 17 – Complete Guide

This article walks through upgrading the open‑source Mall e‑commerce system to Spring Boot 3 and JDK 17, covering dependency version updates, migration from SpringFox to SpringDoc, new Spring Data Elasticsearch usage, revised Spring Security configuration, Docker deployment tips, and essential code changes.

ElasticsearchJavaSpring Boot 3
0 likes · 19 min read
How to Upgrade the Mall Project to Spring Boot 3 & JDK 17 – Complete Guide
ITPUB
ITPUB
Apr 11, 2024 · Big Data

Query 100K Items from 10M+ Records: CK, ES Scroll, HBase, RediSearch

When faced with a business requirement to filter up to 100 000 records from a pool of tens of millions and then sort and de‑duplicate them, this article explores four technical solutions—multithreaded ClickHouse pagination, Elasticsearch scroll‑scan, a combined Elasticsearch‑HBase approach, and RediSearch with RedisJSON—detailing their design, implementation, performance testing, and trade‑offs.

Big DataClickHouseElasticsearch
0 likes · 12 min read
Query 100K Items from 10M+ Records: CK, ES Scroll, HBase, RediSearch
dbaplus Community
dbaplus Community
Apr 9, 2024 · Backend Development

Building a Scalable Order‑to‑Elasticsearch Sync Service (ECP)

This article explains the challenges of synchronizing billions of order records to Elasticsearch, outlines the design of the ECP service that automates heterogeneous data integration, and details its implementation including multi‑source reading, SQL parsing, dynamic rate limiting, retry mechanisms, SPI‑based extensibility, environment isolation, health‑check, smooth migration, and logging.

ElasticsearchJavaSPI
0 likes · 19 min read
Building a Scalable Order‑to‑Elasticsearch Sync Service (ECP)
dbaplus Community
dbaplus Community
Apr 8, 2024 · Cloud Native

Containerizing Elasticsearch & ClickHouse on Kubernetes: Challenges & Solutions

Facing the complexities of running stateful services like Elasticsearch and ClickHouse in production, Bilibili’s infrastructure team detailed their migration to Kubernetes, describing the architectural design, custom operators, storage provisioning with LVM, network configuration, high‑availability strategies, observability, and the resulting cost, quality, and efficiency gains.

ClickHouseCloudNativeElasticsearch
0 likes · 37 min read
Containerizing Elasticsearch & ClickHouse on Kubernetes: Challenges & Solutions
Ops Development Stories
Ops Development Stories
Apr 8, 2024 · Cloud Native

Mastering Kubernetes Event Monitoring: Alerts, Collection, and Analysis

This guide explains how to monitor Kubernetes events, differentiate normal and warning events, and use tools like kube-eventer and kube-event-exporter to collect, alert on, and analyze cluster events through webhook, Kafka, Logstash, and Elasticsearch, enabling comprehensive observability and troubleshooting.

ElasticsearchEvent MonitoringKubernetes
0 likes · 18 min read
Mastering Kubernetes Event Monitoring: Alerts, Collection, and Analysis
JD Tech
JD Tech
Mar 29, 2024 · Databases

Root Cause Analysis and Optimization of a Slow MySQL Query Using Index Selection and Force Index

This article examines a MySQL slow‑query incident caused by the optimizer using the primary clustered index instead of an appropriate secondary index, explains the underlying index structures, and presents solutions such as FORCE INDEX and migrating complex queries to Elasticsearch for long‑term performance improvement.

DatabaseElasticsearchSlow Query
0 likes · 9 min read
Root Cause Analysis and Optimization of a Slow MySQL Query Using Index Selection and Force Index
DataFunTalk
DataFunTalk
Mar 24, 2024 · Big Data

Didi's Big Data Asset Governance Practices: Hadoop and Elasticsearch Governance

This article details Didi's comprehensive big‑data asset governance platform, covering its architectural layers, Hadoop and Elasticsearch governance practices, health‑score models, lifecycle recommendations, and future plans for automated and intelligent data governance to reduce cost and manual effort.

Big DataElasticsearchHadoop
0 likes · 17 min read
Didi's Big Data Asset Governance Practices: Hadoop and Elasticsearch Governance
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Mar 22, 2024 · Artificial Intelligence

Improving Document Search with Vector Search: From Elasticsearch Limitations to Milvus Integration

This article explains how traditional keyword search with Elasticsearch often yields inaccurate or incomplete results for document retrieval, introduces vectorization and semantic search using NLP embeddings, and demonstrates a practical workflow that combines these techniques with the Milvus vector database to achieve more accurate and efficient document search.

AIDocument RetrievalElasticsearch
0 likes · 13 min read
Improving Document Search with Vector Search: From Elasticsearch Limitations to Milvus Integration
dbaplus Community
dbaplus Community
Mar 19, 2024 · Big Data

How JD’s Mini‑Program Data Center Powers Real‑Time Analytics and Monitoring

JD’s Mini‑Program Data Center integrates data collection, storage, and real‑time analysis using Flink, ClickHouse, and Elasticsearch to provide comprehensive monitoring, user behavior insights, and scalable analytics for mini‑programs across JD’s ecosystem, enabling precise operations and future AI‑driven enhancements.

ClickHouseData CenterElasticsearch
0 likes · 19 min read
How JD’s Mini‑Program Data Center Powers Real‑Time Analytics and Monitoring
Code Ape Tech Column
Code Ape Tech Column
Mar 18, 2024 · Backend Development

Implementing File Upload and Text Extraction with Elasticsearch Ingest Attachment Plugin in Spring Boot

This tutorial explains how to let users upload PDF, Word, or TXT files, install the Elasticsearch Ingest Attachment Processor Plugin, create an ingest pipeline and index mapping, convert files to Base64, and perform fuzzy searches with highlighted results using Spring Boot and Java code examples.

ElasticsearchIngest AttachmentJava
0 likes · 21 min read
Implementing File Upload and Text Extraction with Elasticsearch Ingest Attachment Plugin in Spring Boot
dbaplus Community
dbaplus Community
Mar 17, 2024 · Backend Development

How to Build a Scalable Billion‑Item Elasticsearch Search System from Scratch

This article walks through the end‑to‑end design and implementation of a searchable system that scales from millions to hundreds of millions of products, covering business background, data‑center architecture, ES cluster sizing, multi‑room data sync, RocketMQ‑Flink pipelines, and multi‑layer reconciliation to achieve high QPS and strong consistency.

Data synchronizationElasticsearchRocketMQ
0 likes · 16 min read
How to Build a Scalable Billion‑Item Elasticsearch Search System from Scratch
JD Tech
JD Tech
Mar 14, 2024 · Databases

JD ElasticSearch Supports ZSTD Compression: Implementation, Performance Evaluation, and Usage Guide

This article explains how JD ElasticSearch has integrated the high‑performance ZSTD compression algorithm, details the motivations behind its adoption, presents benchmark results comparing it with LZ4 and best_compression, and provides step‑by‑step instructions and code snippets for configuring and using the new jd_zstd codec in Elasticsearch.

ElasticsearchJavaLucene
0 likes · 14 min read
JD ElasticSearch Supports ZSTD Compression: Implementation, Performance Evaluation, and Usage Guide
Bilibili Tech
Bilibili Tech
Mar 12, 2024 · Cloud Native

Containerizing Elasticsearch and ClickHouse on Kubernetes: Architecture, Implementation, and Benefits

Bilibili migrated its Elasticsearch and ClickHouse clusters to Kubernetes using custom operators, CRDs, LVM‑based local storage, MacVLAN networking, and pod anti‑affinity, achieving higher resource utilization, isolation, and automation that cut server count, reduced latency spikes, and lowered operational costs dramatically.

ClickHouseElasticsearchKubernetes
0 likes · 38 min read
Containerizing Elasticsearch and ClickHouse on Kubernetes: Architecture, Implementation, and Benefits