BestHub
Sign in
Tagged articles
23 articles
Page 1 of 1
Architect's Guide
Architect's Guide
Mar 20, 2026 · Backend Development

How We Cut 1‑Second Query Times in a Legacy WAF Dashboard Using Redis Caching

Facing slow page loads in a legacy WAF reporting system, we dissected a 1000‑line Java method, introduced hourly aggregation, Redis auto‑increment counters, and scheduled synchronization, eliminating costly SQL scans and achieving sub‑second queries on 1.5 million logs, while outlining remaining optimization opportunities.

JavaPerformance OptimizationSQL
0 likes · 12 min read
How We Cut 1‑Second Query Times in a Legacy WAF Dashboard Using Redis Caching
Architect-Kip
Architect-Kip
Mar 2, 2026 · Big Data

How to Build a Scalable Tiered Archive & Query System for MySQL Data

This article presents a comprehensive design for a layered storage and unified scheduling platform that archives MySQL historical data, reduces storage costs, ensures high‑performance queries, and enables efficient data analysis through tiered hot, warm, and cold storage using big‑data technologies.

FlinkHiveSpark
0 likes · 13 min read
How to Build a Scalable Tiered Archive & Query System for MySQL Data
Architect's Guide
Architect's Guide
Feb 4, 2024 · Databases

Evaluating Large MySQL Table Size and Optimizing Query Performance with Partitioning, Sharding, and Archiving

This article explains how to assess MySQL table size through table capacity, disk usage, and instance resources, illustrates the impact of B+‑tree index depth on query speed, and presents three practical solutions—table partitioning, database sharding, and hot‑cold data archiving—to improve performance.

Database OptimizationPartitioningdata archiving
0 likes · 15 min read
Evaluating Large MySQL Table Size and Optimizing Query Performance with Partitioning, Sharding, and Archiving
Efficient Ops
Efficient Ops
Jan 8, 2024 · Databases

Eight Proven Strategies to Supercharge Database Performance

This article outlines why databases become slow, introduces a four‑layer optimization framework, and presents eight practical solutions—including data reduction, archiving, sharding, caching, and read‑replica strategies—to help engineers systematically diagnose and resolve the majority of performance bottlenecks.

CQRSDatabase OptimizationNoSQL
0 likes · 20 min read
Eight Proven Strategies to Supercharge Database Performance
DataFunTalk
DataFunTalk
Sep 22, 2023 · Big Data

Design and Practice of Baidu's Tape Library Storage Architecture Based on the Aries Cloud Storage System

This article presents a comprehensive overview of Baidu Intelligent Cloud's tape‑library solution, detailing tape and tape‑library fundamentals, the Aries cloud storage stack, data and access models, the end‑to‑end data flow, key architectural design choices, implementation details, and a real‑world case study demonstrating large‑scale cold‑data storage, backup, and retrieval performance.

ariescold datadata archiving
0 likes · 28 min read
Design and Practice of Baidu's Tape Library Storage Architecture Based on the Aries Cloud Storage System
Baidu Intelligent Cloud Tech Hub
Baidu Intelligent Cloud Tech Hub
Sep 4, 2023 · Big Data

How Baidu’s Aries Cloud Storage Leverages Tape Libraries for Massive Cold Data Archiving

This article explains Baidu Intelligent Cloud’s tape‑library based cold‑data storage architecture, covering tape media basics, the Aries cloud storage system, its modular design, data flow, write and retrieval processes, and a real‑world deployment case that demonstrates cost‑effective petabyte‑scale archival.

ariescloud storagecold data
0 likes · 31 min read
How Baidu’s Aries Cloud Storage Leverages Tape Libraries for Massive Cold Data Archiving
Top Architect
Top Architect
Mar 14, 2023 · Databases

Handling Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies

This article explains how to assess MySQL table size, identify performance issues caused by massive data volumes, and presents three practical solutions—table partitioning, database sharding, and hot‑cold data archiving—along with detailed SQL examples and considerations for implementation.

Performance Optimizationdata archivingdatabase partitioning
0 likes · 16 min read
Handling Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies
Top Architect
Top Architect
Mar 4, 2023 · Databases

How to Handle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies

This article explains why large MySQL tables cause slow queries, analyzes table size, disk usage, and instance capacity, and presents three practical solutions—table partitioning, database sharding (horizontal/vertical), and hot‑cold data archiving—helping developers choose the appropriate strategy for their workloads.

Performance Optimizationdata archivingdatabase partitioning
0 likes · 18 min read
How to Handle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies
dbaplus Community
dbaplus Community
Jul 26, 2022 · Databases

Master MySQL Data Archiving with pt-archiver: Install, Run, and Optimize

This guide explains how to use Percona Toolkit's pt-archiver for MySQL data archiving, covering installation, basic and bulk commands, underlying two‑phase‑commit logic, performance trade‑offs of various parameters, and best‑practice tips for safe, efficient archiving and deletion.

Replication LagSQLbulk operations
0 likes · 19 min read
Master MySQL Data Archiving with pt-archiver: Install, Run, and Optimize
Selected Java Interview Questions
Selected Java Interview Questions
May 6, 2022 · Databases

Eight Database Optimization Strategies for Performance Improvement

This article presents a systematic overview of eight practical database optimization techniques—including data reduction, serialization, archiving, intermediate tables, sharding, distributed caching, master‑slave replication, and appropriate storage selection—to help backend engineers diagnose and resolve the majority of performance bottlenecks caused by data volume, high load, and search complexity.

CQRSNoSQLcaching
0 likes · 19 min read
Eight Database Optimization Strategies for Performance Improvement
Java Backend Technology
Java Backend Technology
May 1, 2022 · Databases

Mastering Database Performance: 8 Proven Optimization Strategies

This article explains why databases become slow, introduces a four‑layer thinking model, and presents eight practical solutions—including reducing data volume, leveraging space for performance, and selecting the right storage system—to help backend engineers resolve 80‑90% of common performance problems.

CQRSDatabase OptimizationNoSQL
0 likes · 19 min read
Mastering Database Performance: 8 Proven Optimization Strategies
Qingyun Technology Community
Qingyun Technology Community
Jan 10, 2022 · Cloud Native

How OpenFunction Enables Serverless Data Archiving for Scalable Cloud‑Native Systems

This article explores the business scenario of data archiving in autonomous driving platforms, explains why a serverless architecture was chosen, and details how OpenFunction combined with Dapr, KEDA, and microservices addresses challenges such as diverse storage types, scaling, and observability, providing a flexible, elastic solution.

DaprKEDAOpenFunction
0 likes · 10 min read
How OpenFunction Enables Serverless Data Archiving for Scalable Cloud‑Native Systems
DevOps
DevOps
Dec 10, 2020 · Fundamentals

GitHub’s Arctic Code Vault and Future Glass Storage for Open Source Code

GitHub’s Arctic Code Vault initiative has archived millions of open‑source projects on film stored in a Norwegian Arctic facility, and the company now plans to preserve code for millennia using quartz glass through Microsoft’s Project Silica, highlighting long‑term data preservation strategies for software.

Arctic Code VaultGitHubProject Silica
0 likes · 4 min read
GitHub’s Arctic Code Vault and Future Glass Storage for Open Source Code
Architects' Tech Alliance
Architects' Tech Alliance
Dec 24, 2017 · Industry Insights

Can DNA Become the Next Super‑High‑Density Storage Medium?

The article explains how DNA storage encodes binary data using nucleobases, outlines its massive theoretical density and longevity, describes the required codec, synthesis, and sequencing components, and examines current technical challenges, recent research milestones, and future prospects for commercial adoption.

DNA storageSynthetic Biologydata archiving
0 likes · 8 min read
Can DNA Become the Next Super‑High‑Density Storage Medium?
ITPUB
ITPUB
Apr 20, 2016 · Databases

How to Shrink a 130GB Logistics JSON Column in MySQL

This article examines a MySQL table storing large JSON logistics data, analyzes why its size grows to 130 GB, and presents practical optimizations such as data archiving, JSON field reduction, and schema redesign to keep the table manageable.

JSONLogisticsSchema Optimization
0 likes · 8 min read
How to Shrink a 130GB Logistics JSON Column in MySQL
MaGe Linux Operations
MaGe Linux Operations
Feb 25, 2015 · Big Data

Do You Really Need Hadoop? 10 Alternatives to Consider First

This article explains why many companies over‑invest in Hadoop, outlines how to evaluate data size, growth, and relevance, and presents practical alternatives such as archiving, data sampling, database sharding, and hiring business‑savvy analysts before committing to a Hadoop deployment.

Big Data AlternativesData ArchitectureHadoop
0 likes · 9 min read
Do You Really Need Hadoop? 10 Alternatives to Consider First