BestHub
Sign in
Tagged articles
2678 articles
Page 24 of 27
Xianyu Technology
Xianyu Technology
Oct 16, 2018 · Big Data

Millisecond-Level Counting for Billion-Scale Data via Offline Batch and Online Incremental Statistics

To achieve millisecond‑level counting on billion‑scale data, the Xianyu team replaced slow MySQL count queries with an offline batch that snapshots relational tables and computes totals, then uses KV‑store incremental statistics for online updates, delivering sub‑10 ms responses with near‑100 % success.

Big DataDatabaseincremental counting
0 likes · 7 min read
Millisecond-Level Counting for Billion-Scale Data via Offline Batch and Online Incremental Statistics
Java Backend Technology
Java Backend Technology
Oct 15, 2018 · Databases

Master MySQL Indexes and Locks: Boost Performance and Avoid Pitfalls

This article explains MySQL's index structures, how indexes accelerate queries but slow down writes, the differences between B‑tree and hash indexes, clustered versus non‑clustered indexes, the left‑most prefix rule, and provides a comprehensive overview of MySQL locking mechanisms and best practices.

DatabaseInnoDBLock
0 likes · 18 min read
Master MySQL Indexes and Locks: Boost Performance and Avoid Pitfalls
Architects' Tech Alliance
Architects' Tech Alliance
Sep 11, 2018 · Databases

Understanding Distributed Transactions: Principles, 2PC, 3PC, XA, Saga, and Message‑Based Approaches

This article explains the fundamentals of database transactions, the ACID properties, and how they are implemented, then delves into distributed transaction challenges and solutions such as two‑phase and three‑phase commit, XA, Saga patterns, choreography vs. orchestration, and message‑based transaction mechanisms.

2PC3PCACID
0 likes · 16 min read
Understanding Distributed Transactions: Principles, 2PC, 3PC, XA, Saga, and Message‑Based Approaches
Architects' Tech Alliance
Architects' Tech Alliance
Sep 11, 2018 · Databases

Pessimistic vs Optimistic Locking: A Story-Based Explanation

This article uses a humorous story of two threads battling over inventory updates to illustrate the principles, advantages, and drawbacks of pessimistic and optimistic locking in distributed systems, helping readers understand when to apply each concurrency control method.

Concurrency ControlDatabaseDistributed Systems
0 likes · 8 min read
Pessimistic vs Optimistic Locking: A Story-Based Explanation
Java Backend Technology
Java Backend Technology
Sep 8, 2018 · Databases

Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls

This comprehensive guide walks you through mastering MySQL by covering server configuration choices, storage engine selection, data type recommendations, index strategies, backup methods, logging options, and practical advice on triggers, views, stored procedures, and character set handling, all aimed at boosting performance and avoiding common mistakes.

DatabaseIndexesMySQL
0 likes · 26 min read
Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls
High Availability Architecture
High Availability Architecture
Sep 7, 2018 · Databases

Understanding NoSQL and Database Selection in the Big Data Era

This article analyzes the shortcomings of traditional relational databases in big‑data scenarios and introduces five major NoSQL categories—columnar, key‑value, document, full‑text search, and graph databases—detailing their principles, advantages, disadvantages, common implementations, and appropriate use cases to guide storage technology selection.

ColumnarData StorageDatabase
0 likes · 18 min read
Understanding NoSQL and Database Selection in the Big Data Era
Zhongtong Tech
Zhongtong Tech
Aug 31, 2018 · Databases

How Aries Uses MySQL GTID Binlog to Power Real‑Time Data Sync at Scale

Aries, an internally built MySQL incremental log distribution platform, leverages GTID‑based binlog dumping to achieve stable, consistent, and real‑time data synchronization across heterogeneous systems, supporting use cases such as Elasticsearch sync, cache updates, archiving, and live statistics.

Data IntegrationDatabaseGTID
0 likes · 7 min read
How Aries Uses MySQL GTID Binlog to Power Real‑Time Data Sync at Scale
Efficient Ops
Efficient Ops
Aug 30, 2018 · Databases

What’s New in MySQL 8.0 InnoDB? Key Features and Performance Boosts

This article summarizes the major functional and performance enhancements introduced in MySQL 8.0 InnoDB, including a unified data dictionary, atomic DDL, fast column addition, encryption, improved Memcached plugin, parallel redo log writes, and future roadmap items.

DatabaseInnoDBMySQL
0 likes · 13 min read
What’s New in MySQL 8.0 InnoDB? Key Features and Performance Boosts
Java Captain
Java Captain
Aug 28, 2018 · Databases

Design and Implementation of a Mini Database Connection Pool

This article explains the concept, design considerations, and step‑by‑step implementation of a lightweight database connection pool in Java, covering its core components, thread‑safe management, configuration handling, and a test demonstration of its functionality.

Connection PoolDatabaseDesign Patterns
0 likes · 5 min read
Design and Implementation of a Mini Database Connection Pool
Tencent Cloud Developer
Tencent Cloud Developer
Aug 27, 2018 · Mobile Development

WeChat Mini Program Cloud Development: Overview, Advantages, and Common Pitfalls

WeChat Mini Program Cloud Development offers a serverless backend—cloud functions, database, and file storage—exclusively for Mini Programs, providing simple login, generous free tiers, and easy JavaScript integration, while developers must handle promises for async calls and supplement its limited permission model with custom logic.

DatabaseFaaSJavaScript
0 likes · 7 min read
WeChat Mini Program Cloud Development: Overview, Advantages, and Common Pitfalls
Tencent Cloud Developer
Tencent Cloud Developer
Aug 24, 2018 · Cloud Computing

Unlocking WeChat Mini Program Cloud Development: Benefits, Pitfalls & Real‑World Demo

This article introduces WeChat Mini Program Cloud Development, explains its serverless architecture, compares it with PaaS and BaaS solutions, outlines suitable scenarios, highlights advantages such as built‑in login and free storage, warns of common misconceptions, and shares practical tips and a GitHub demo project.

DatabaseJavaScriptMini Program
0 likes · 7 min read
Unlocking WeChat Mini Program Cloud Development: Benefits, Pitfalls & Real‑World Demo
21CTO
21CTO
Aug 23, 2018 · Databases

Mastering Database Transactions: From ACID to Distributed Saga

This article explains the fundamentals of database transactions, the ACID properties, and how they are implemented, then delves into distributed transaction challenges and solutions such as two‑phase commit, three‑phase commit, XA, and Saga patterns, highlighting their trade‑offs and practical usage.

2PCACIDDatabase
0 likes · 19 min read
Mastering Database Transactions: From ACID to Distributed Saga
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 21, 2018 · Databases

Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials

This article explains fundamental MySQL concepts including primary, candidate, super and foreign keys, transaction ACID properties, view creation, differences among DROP, DELETE and TRUNCATE, index structures and types, join variations, normalization forms, optimization techniques, replication mechanisms, engine distinctions, and logging formats.

DatabaseIndexesMySQL
0 likes · 29 min read
Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials
dbaplus Community
dbaplus Community
Aug 19, 2018 · Databases

Redis Deployment Options: Pros & Cons of Single, Replication, Sentinel, Cluster, and Custom Solutions

This article examines five common Redis deployment patterns—single instance, master‑slave replication, Sentinel, Cluster, and custom high‑availability solutions—detailing their architectures, advantages, drawbacks, and practical configuration tips to help engineers choose the most suitable setup for their workloads.

ClusterDatabaseRedis
0 likes · 12 min read
Redis Deployment Options: Pros & Cons of Single, Replication, Sentinel, Cluster, and Custom Solutions
Didi Tech
Didi Tech
Aug 14, 2018 · Databases

Recap of the Open Source Salon: Latest Developments in Open Source Databases and Streaming Processing

On August 4 2018, Didi Open Source and the Open Source Database Forum hosted a salon where five industry experts presented the latest advances in open‑source databases—covering Redis multi‑data‑center deployment, MySQL InnoDB Cluster, streaming‑processing architecture, PostGIS GIS solutions, and Redis 5.0 features—followed by a Q&A, a prize draw, and a showcase of Didi’s growing open‑source portfolio.

DatabaseMySQLPostGIS
0 likes · 4 min read
Recap of the Open Source Salon: Latest Developments in Open Source Databases and Streaming Processing
Python Programming Learning Circle
Python Programming Learning Circle
Aug 8, 2018 · Backend Development

10 Powerful Eloquent ORM Tricks Every Laravel Developer Should Know

Discover a collection of ten practical Eloquent ORM techniques—including increment/decrement shortcuts, conditional method chaining, boot method customizations, advanced relationship queries, and the when() helper—that empower Laravel developers to write cleaner, more efficient database code and avoid common pitfalls.

DatabaseEloquentLaravel
0 likes · 6 min read
10 Powerful Eloquent ORM Tricks Every Laravel Developer Should Know
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 3, 2018 · Databases

Understanding Redis Cluster: Architecture, Slot Sharding, Node Management, and High Availability

Redis Cluster is a distributed system that partitions its keyspace into 16,384 hash slots across up to 16,384 nodes, enabling automatic sharding, slot migration, replication, and high‑availability features such as automatic node discovery, master‑slave election, and online resharding without service interruption.

ClusterDatabaseRedis
0 likes · 5 min read
Understanding Redis Cluster: Architecture, Slot Sharding, Node Management, and High Availability
DevOps
DevOps
Aug 3, 2018 · Operations

How to Choose the Right TFS Network Topology and Plan a Data Storage Strategy

This article explains how to select an appropriate Team Foundation Server (TFS) deployment topology and design a data storage strategy, covering single, dual, and cluster deployments, hardware recommendations by team size, high‑availability options, performance testing results, and best practices for managing TFS databases.

DatabaseDevOpsTFS
0 likes · 12 min read
How to Choose the Right TFS Network Topology and Plan a Data Storage Strategy
Alibaba Cloud Developer
Alibaba Cloud Developer
Jul 27, 2018 · R&D Management

How Hangzhou’s Engineer Culture Powered China’s Tech Revolution

The article chronicles three generations of Hangzhou‑origin engineers—from gritty early Alibaba pioneers to modern cloud and blockchain specialists—showing how their relentless problem‑solving, cultural resilience, and tech‑first mindset transformed China’s internet ecosystem and positioned the city as a global engineering hub.

AlibabaBlockchainDatabase
0 likes · 27 min read
How Hangzhou’s Engineer Culture Powered China’s Tech Revolution
Java Backend Technology
Java Backend Technology
Jul 26, 2018 · Databases

7 Common Redis Misuse Scenarios and How to Fix Them

This article outlines seven frequent misuse patterns in Redis development—such as improper use of collection types, missing expirations, oversized values, inefficient batch operations, unnecessary requests, poor key naming, and unsafe commands—provides real‑world case analyses, and offers practical recommendations to improve Redis health and performance.

DatabaseOptimizationRedis
0 likes · 11 min read
7 Common Redis Misuse Scenarios and How to Fix Them
MaGe Linux Operations
MaGe Linux Operations
Jul 22, 2018 · Backend Development

Build a Full-Featured Django Library Management System from Scratch

This tutorial walks you through configuring Django templates, static files, middleware, and MySQL database settings, then defines models for publishers, books, and authors, implements CRUD views and URL routing, and creates the necessary front‑end templates to build a complete library management application.

Backend DevelopmentDatabaseDjango
0 likes · 16 min read
Build a Full-Featured Django Library Management System from Scratch
Java High-Performance Architecture
Java High-Performance Architecture
Jul 21, 2018 · Databases

Master Redis Streams: From Simple Adds to Powerful Consumer Groups

This guide walks through Redis 5's stream feature, showing how to set up a Docker Redis instance, add entries, perform range queries, use blocking reads, create and manage consumer groups, handle pending messages, claim ownership, inspect stream metadata, delete entries, and limit stream length for efficient message queue implementations.

BackendDatabaseMessage queue
0 likes · 10 min read
Master Redis Streams: From Simple Adds to Powerful Consumer Groups
Efficient Ops
Efficient Ops
Jul 18, 2018 · Databases

Mastering Redis: Advanced Types, Replication, Persistence, and Real-World Design

This article explores Redis’s advanced features—including data types, master‑slave, sentinel, and cluster architectures, transaction handling, RDB/AOF persistence, pub/sub messaging, and a practical e‑commerce search case study—providing design insights and best‑practice configurations for high‑availability and performance.

DatabasePersistenceRedis
0 likes · 10 min read
Mastering Redis: Advanced Types, Replication, Persistence, and Real-World Design
Java Captain
Java Captain
Jul 7, 2018 · Databases

Understanding MySQL Indexes, B+Tree vs Hash, Partitioning, and Redis Fundamentals

This article explains why auto‑increment primary keys are preferred in MySQL, how B+Tree and hash indexes differ, the benefits of composite and partitioned indexes, isolation levels, MVCC, row‑level locking, triggers, stored procedures, optimization tips, MyISAM vs InnoDB, table design guidelines, and also covers Redis architecture, persistence, replication, and eviction policies.

B+TreeDatabaseIndexes
0 likes · 28 min read
Understanding MySQL Indexes, B+Tree vs Hash, Partitioning, and Redis Fundamentals
Test Development Learning Exchange
Test Development Learning Exchange
Jun 26, 2018 · Backend Development

Comprehensive Django ORM Guide: Model Definition, Custom Table Names, Indexes, Relationships, Query Optimization, and Validation

This article provides an in‑depth tutorial on using Django's ORM, covering model creation, custom table names, single and composite indexes, one‑to‑many and many‑to‑many relationships, forward and reverse lookups, performance tuning with select_related and prefetch_related, and model validation techniques.

BackendDatabaseDjango
0 likes · 21 min read
Comprehensive Django ORM Guide: Model Definition, Custom Table Names, Indexes, Relationships, Query Optimization, and Validation
Java Captain
Java Captain
Jun 24, 2018 · Databases

How to Build a Redis Cluster on a Single Linux Machine

This tutorial explains how to set up a six‑node Redis cluster (three masters and three slaves) on one Linux VM by creating separate directories and configuration files for each instance, installing Ruby tools, starting the instances, and using the redis‑trib.rb script to create and verify the cluster.

BackendClusterDatabase
0 likes · 5 min read
How to Build a Redis Cluster on a Single Linux Machine
ITPUB
ITPUB
Jun 22, 2018 · Databases

How to Build a Highly Available Redis Service with Sentinel and Virtual IP

This article explains how to design and implement a highly available Redis deployment using master‑slave replication, multiple Redis Sentinel instances, and a virtual IP to provide seamless failover while maintaining simple client connectivity, covering failure scenarios, architecture choices, and practical configuration tips.

DatabaseRedisfailover
0 likes · 12 min read
How to Build a Highly Available Redis Service with Sentinel and Virtual IP
ITPUB
ITPUB
Jun 14, 2018 · Databases

Mastering Oracle Partitioning: Concepts, History, Best Practices & New Features

This article presents a comprehensive overview of Oracle partitioning, covering basic concepts, the evolution of partition features across versions, practical best‑practice scenarios, and the latest enhancements in Oracle 12c, 12.2, and 18c that improve performance, manageability, and availability.

Best PracticesDatabaseOracle
0 likes · 17 min read
Mastering Oracle Partitioning: Concepts, History, Best Practices & New Features
Tencent Cloud Developer
Tencent Cloud Developer
Jun 14, 2018 · Operations

Tencent Cloud Database Massive Operations: Team Building, Automated Operations Platform, and Intelligent Practices

Tencent Cloud Database’s massive‑operation strategy combines a dedicated architect team, a three‑layer automated platform for resource, task and health management, and AI‑driven intelligent services that customize workloads, automate tuning, and enable proactive scaling and self‑healing across hundreds of thousands of instances.

AIDatabaseOperations
0 likes · 11 min read
Tencent Cloud Database Massive Operations: Team Building, Automated Operations Platform, and Intelligent Practices
High Availability Architecture
High Availability Architecture
Jun 1, 2018 · Databases

Redis 5.0 New Features and Migration Considerations

The article outlines Redis 5.0's major new capabilities—including Streams, module APIs, enhanced RDB metadata, cluster management improvements, new sorted‑set commands, active memory defragmentation, HyperLogLog upgrades, better memory reporting, HELP sub‑commands, connection performance, bug fixes, and Jemalloc 5.1—while also detailing important migration notes from version 4.0 and providing a reference link to the Streams introduction.

DatabaseMigrationRDB
0 likes · 4 min read
Redis 5.0 New Features and Migration Considerations
Efficient Ops
Efficient Ops
May 30, 2018 · Databases

How SF Express Transformed Its Database Operations: From Legacy to Open‑Source, Distributed, and Intelligent Ops

This talk details SF Express’s journey from heterogeneous legacy databases to standardized open‑source, distributed architectures and intelligent operations, covering standardization, migration to open‑source, scaling with Mycat, automated resource pooling, and the ThinkDB platform that drives proactive, automated DBA workflows.

DatabaseDistributed SystemsMycat
0 likes · 18 min read
How SF Express Transformed Its Database Operations: From Legacy to Open‑Source, Distributed, and Intelligent Ops
ITPUB
ITPUB
May 30, 2018 · Databases

How to Monitor SQL Server Backup and Restore Progress Effectively

This guide explains three practical ways to track SQL Server backup and restore operations—using SSMS UI, T‑SQL with the STATS option, and dynamic management views—plus how to retrieve backup history and avoid common pitfalls.

DMVDatabaseRestore
0 likes · 7 min read
How to Monitor SQL Server Backup and Restore Progress Effectively
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 27, 2018 · Databases

Best Practices for Using Alibaba Cloud Redis: Key Design, Command Usage, Client Configuration, and Tools

This article outlines Alibaba Cloud Redis development guidelines, covering key naming conventions, value design, command usage, client configuration, lifecycle management, and recommended tools, providing practical recommendations to avoid common pitfalls, improve performance, and ensure reliable operation of Redis in production environments.

Alibaba CloudBest PracticesDatabase
0 likes · 9 min read
Best Practices for Using Alibaba Cloud Redis: Key Design, Command Usage, Client Configuration, and Tools
Practical DevOps Architecture
Practical DevOps Architecture
May 22, 2018 · Databases

Step-by-Step Guide to Installing MySQL 5.7 on Linux

This article provides a detailed, command-line tutorial for installing MySQL 5.7 on a Linux system, covering directory creation, downloading and extracting the binary package, user setup, initialization, configuration file adjustments, service startup, and password configuration.

DatabaseInstallationLinux
0 likes · 5 min read
Step-by-Step Guide to Installing MySQL 5.7 on Linux
Efficient Ops
Efficient Ops
May 21, 2018 · Databases

Why Do Database Failures Happen and How to Prevent Them?

This article examines common hardware and network failures in data centers, analyzes real‑world outage cases, classifies fault domains, and presents comprehensive strategies for database fault handling—including logging, checkpointing, backup, replication, and high‑availability architectures—to improve reliability and reduce downtime.

DatabaseDistributed SystemsLogging
0 likes · 22 min read
Why Do Database Failures Happen and How to Prevent Them?
Java Captain
Java Captain
May 19, 2018 · Databases

MySQL Index Optimization and Performance Analysis

This article explains MySQL index fundamentals, demonstrates performance issues with slow queries, and walks through practical optimization cases using EXPLAIN, covering index creation, covering indexes, and composite indexes, and best practices for when to add or avoid indexes.

DatabaseEXPLAINIndex Optimization
0 likes · 17 min read
MySQL Index Optimization and Performance Analysis
Meituan Technology Team
Meituan Technology Team
May 17, 2018 · Databases

Understanding MySQL SQL Parsing and Optimization Techniques

The article explains how to extend MySQL’s built‑in lexer and Bison‑based parser to expose table names, query features, and optimization advice via a simple language‑agnostic service, illustrating core data structures, useless‑condition elimination, feature generation for slow‑query analysis, and practical learning tips.

CompilerDBADatabase
0 likes · 15 min read
Understanding MySQL SQL Parsing and Optimization Techniques
dbaplus Community
dbaplus Community
May 16, 2018 · Databases

Master MySQL: Essential Commands, Indexes, Stored Procedures & Triggers

This guide provides a comprehensive overview of MySQL fundamentals—including CRUD statements, table creation, index management, data manipulation, transaction control, stored procedures, and trigger creation—complete with syntax examples and practical tips for reliable database development.

CRUDDatabaseMySQL
0 likes · 26 min read
Master MySQL: Essential Commands, Indexes, Stored Procedures & Triggers
Ops Development Stories
Ops Development Stories
May 11, 2018 · Databases

How to Set Up MySQL Master‑Slave Replication with Docker

This guide walks through configuring MySQL master‑slave replication inside Docker containers, covering environment setup, container creation, MySQL configuration changes, replication user creation, synchronization commands, troubleshooting tips, and verification of data replication between the master and slave instances.

DatabaseDockerMaster‑Slave
0 likes · 4 min read
How to Set Up MySQL Master‑Slave Replication with Docker
Efficient Ops
Efficient Ops
May 10, 2018 · Operations

How Ele.me Scaled to 10M+ Daily Orders with Multi‑Active Architecture

The talk details Ele.me’s rapid growth from 300k to over 10 million daily orders, describing the challenges of high‑concurrency, multi‑active micro‑service architecture, IDC planning, database refactoring, disaster‑recovery, NOC operations, and the systematic processes that enabled stable, scalable delivery across two data centers.

Cloud ComputingDatabaseIDC planning
0 likes · 19 min read
How Ele.me Scaled to 10M+ Daily Orders with Multi‑Active Architecture
Hujiang Technology
Hujiang Technology
May 8, 2018 · Databases

Understanding Consistent Reads and MVCC in MySQL InnoDB

This article explains how MySQL InnoDB implements consistent reads using multi‑version concurrency control (MVCC), detailing isolation levels, undo‑log mechanics, hidden columns, rollback segments, transaction commit behavior, and the impact on SELECT, INSERT, UPDATE, and DELETE operations.

Consistent ReadDatabaseInnoDB
0 likes · 14 min read
Understanding Consistent Reads and MVCC in MySQL InnoDB
Architecture Digest
Architecture Digest
Apr 28, 2018 · Databases

HBase Architecture Components and Operational Overview

This article provides a comprehensive overview of HBase's architecture, detailing the roles of RegionServers, HMaster, ZooKeeper, Regions, the META table, write and read paths, compaction processes, region splitting, load balancing, HDFS replication, crash recovery, and the system's advantages and challenges.

DatabaseNoSQL
0 likes · 17 min read
HBase Architecture Components and Operational Overview
21CTO
21CTO
Apr 27, 2018 · Backend Development

How Stack Overflow Achieves Lightning‑Fast Pagination

This article explains the sophisticated pagination system used by Stack Overflow, covering offset‑based queries, a custom Tag Engine, database joins, in‑memory sorting, and caching techniques that together deliver rapid page navigation even over billions of records.

BackendDatabasepagination
0 likes · 6 min read
How Stack Overflow Achieves Lightning‑Fast Pagination
Java Backend Technology
Java Backend Technology
Apr 25, 2018 · Backend Development

Master Java Interview Prep: 100+ Essential Backend Questions & Answers

This article compiles a comprehensive set of Java interview topics—including core language concepts, concurrency, JVM tuning, database optimization, data structures, operating‑system fundamentals, networking, frameworks, distributed systems, and design challenges—to help developers deepen their understanding and excel in technical interviews.

ConcurrencyDatabaseJava
0 likes · 11 min read
Master Java Interview Prep: 100+ Essential Backend Questions & Answers
dbaplus Community
dbaplus Community
Apr 23, 2018 · Operations

Insights and Highlights from the 2018 Gdevops Global Agile Ops Summit

The 2018 Gdevops Global Agile Operations Summit in Chengdu gathered industry experts who shared practical insights on AIOps implementation, sharding database ecosystems, DevOps adoption in traditional enterprises, large‑scale data management, ElasticSearch clustering, AWS blue‑green deployments, cloud database operations, Alibaba's double‑11 ops platform, 58 delivery mini‑program architecture, and scalable game service design.

Big DataDatabaseDevOps
0 likes · 13 min read
Insights and Highlights from the 2018 Gdevops Global Agile Ops Summit
Qunar Tech Salon
Qunar Tech Salon
Apr 18, 2018 · Databases

FPGA-Accelerated X-Engine Storage Engine for High‑Performance OLTP

This article presents the design, implementation, and evaluation of X‑Engine, a next‑generation LSM‑Tree based storage engine that offloads compaction to FPGA, achieving up to 50% KV‑interface and 40% SQL‑interface performance gains for write‑intensive OLTP workloads.

DatabaseFPGALSM‑Tree
0 likes · 19 min read
FPGA-Accelerated X-Engine Storage Engine for High‑Performance OLTP
ITPUB
ITPUB
Apr 14, 2018 · Databases

Designing a Highly Available Redis Service with Sentinel and Multi‑Sentinel Architecture

This article explains how to define high availability for Redis, enumerates typical failure scenarios, compares four deployment patterns—from a single instance to a three‑sentinel setup—and provides practical steps, diagrams, and tips for achieving reliable Redis service using Sentinel and virtual IP failover.

DatabaseRedisarchitecture
0 likes · 14 min read
Designing a Highly Available Redis Service with Sentinel and Multi‑Sentinel Architecture
Java Backend Technology
Java Backend Technology
Apr 11, 2018 · Backend Development

Unlock Java Interview Success: Core JVM, Concurrency, DB & Linux Questions

This guide compiles over a hundred essential interview questions covering Java fundamentals, JVM tuning, thread pools, memory management, databases, Linux system internals, networking basics, and popular frameworks like Spring and Dubbo, helping candidates prepare comprehensively for backend development roles.

ConcurrencyDatabaseJava
0 likes · 9 min read
Unlock Java Interview Success: Core JVM, Concurrency, DB & Linux Questions
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 9, 2018 · Databases

How FPGA Acceleration Supercharges X-Engine’s Compaction for 10× MySQL Performance

This article introduces Alibaba’s X‑Engine storage engine, the foundation of the next‑generation distributed database X‑DB, and explains how FPGA‑accelerated compaction and asynchronous scheduling dramatically improve write‑intensive OLTP performance, reduce CPU contention, and achieve up to 50 % throughput gains while maintaining fault tolerance.

DatabaseFPGALSM‑Tree
0 likes · 21 min read
How FPGA Acceleration Supercharges X-Engine’s Compaction for 10× MySQL Performance
ITPUB
ITPUB
Apr 6, 2018 · Databases

Understanding MySQL InnoDB: Architecture, Storage, Indexes, Locks, and Transactions

This article provides a comprehensive, step‑by‑step overview of MySQL's InnoDB storage engine, covering database vs instance definitions, internal processes, tablespace layout, file formats, record layouts, B‑tree indexes, lock types, and transaction isolation levels for developers seeking a solid foundation.

DatabaseIndexesInnoDB
0 likes · 26 min read
Understanding MySQL InnoDB: Architecture, Storage, Indexes, Locks, and Transactions
ITPUB
ITPUB
Mar 30, 2018 · Databases

Step‑by‑Step Oracle Multi‑Master Replication Setup with Full SQL Scripts

This guide walks through configuring Oracle multi‑master data replication, covering site creation, group objects, propagator and receiver setup, purge scheduling, database link creation, replication group definition, table registration, conflict handling, and finally resuming replication, all illustrated with complete SQL code examples.

DatabaseOraclemulti-master
0 likes · 7 min read
Step‑by‑Step Oracle Multi‑Master Replication Setup with Full SQL Scripts
Java Backend Technology
Java Backend Technology
Mar 22, 2018 · Backend Development

Ultimate Java Interview Guide: 100+ Essential Questions & Answers

This comprehensive guide compiles over a hundred critical Java interview questions covering core language concepts, multithreading, JVM internals, databases, caching, distributed systems, system design, and security to help candidates prepare thoroughly and confidently for technical interviews.

DatabaseJava
0 likes · 13 min read
Ultimate Java Interview Guide: 100+ Essential Questions & Answers
ITPUB
ITPUB
Mar 19, 2018 · Databases

Why Oracle EM Fails with a Static Listener and How to Fix It

The article explains that Oracle Enterprise Manager requires listeners with dynamic registration, shows how a static listener on a non‑default port causes a "database is down" error, and provides step‑by‑step commands to modify the local_listener parameter so both listeners register dynamically and EM works correctly.

DatabaseDynamic RegistrationEnterprise Manager
0 likes · 9 min read
Why Oracle EM Fails with a Static Listener and How to Fix It
Test Development Learning Exchange
Test Development Learning Exchange
Mar 17, 2018 · Databases

How to Set Up a Redis Cluster on macOS

This guide explains why a Redis cluster is needed for large data sets, describes the hash‑slot architecture introduced in Redis 3.0, and provides step‑by‑step instructions—including directory creation, configuration changes, instance startup, Ruby gem installation, and cluster creation commands—to build a functional Redis cluster on a Mac.

ClusterDatabaseRedis
0 likes · 8 min read
How to Set Up a Redis Cluster on macOS
Tencent Cloud Developer
Tencent Cloud Developer
Mar 14, 2018 · Cloud Computing

Business Continuity Solutions on Tencent Cloud: High Availability and Disaster Recovery

Tencent Cloud’s business continuity solutions combine high‑availability clusters, multi‑AZ load balancing, and cross‑region disaster‑recovery architectures—such as CLB‑CVM‑MySQL configurations, CDB hot‑standby instances, DNS‑based failover, and data‑sync services—to ensure continuous operation and rapid recovery from localized or regional failures.

DatabaseHATencent Cloud
0 likes · 10 min read
Business Continuity Solutions on Tencent Cloud: High Availability and Disaster Recovery
Java Captain
Java Captain
Mar 9, 2018 · Backend Development

Comprehensive Java Interview Topics and Core Concepts

This guide compiles a thorough list of Java interview questions and key concepts, ranging from basic collections and JVM memory to concurrency, database optimization, messaging systems, NoSQL, Zookeeper, Linux commands, and system design challenges, providing a solid study roadmap for developers.

BackendDatabaseDesign Patterns
0 likes · 7 min read
Comprehensive Java Interview Topics and Core Concepts
ITPUB
ITPUB
Feb 27, 2018 · Databases

Designing Robust Oracle Backup and Recovery Strategies for Large Databases

This guide answers common Oracle backup questions, covering planning for 50‑TB databases, speed calculations, backup window design, RMAN versus Data Pump, multi‑user and RAC scenarios, catalog usage, performance troubleshooting, and practical SQL queries for monitoring backup status.

Data PumpDatabaseOracle
0 likes · 18 min read
Designing Robust Oracle Backup and Recovery Strategies for Large Databases
ITPUB
ITPUB
Jan 27, 2018 · Databases

Why NewSQL Matters: From Relational Roots to Modern HTAP

This article traces the evolution of database systems—from early navigational models and Codd's relational theory through the rise of NoSQL and sharding, to the resurgence of NewSQL and the emerging HTAP paradigm—highlighting technical motivations, design trade‑offs, and future directions.

DatabaseHTAPNewSQL
0 likes · 21 min read
Why NewSQL Matters: From Relational Roots to Modern HTAP
Programmer DD
Programmer DD
Jan 14, 2018 · Backend Development

Integrating Spring Security with MyBatis for Database‑Based Login

This guide shows how to combine Spring Security and MyBatis to implement username‑password authentication backed by a MariaDB database, covering repository cloning, database setup, Maven execution, and a deep dive into the underlying authentication filter and provider classes with code examples.

AuthenticationDatabaseJava
0 likes · 9 min read
Integrating Spring Security with MyBatis for Database‑Based Login
UCloud Tech
UCloud Tech
Jan 12, 2018 · Databases

How to Diagnose and Resolve MySQL Replication Errors in High‑Availability Environments

This article explains step‑by‑step how to collect replication status, examine MySQL error logs and binary logs, understand common replication failures such as duplicate databases or missing binlog files, and apply GTID and configuration best practices to troubleshoot and fix MySQL replication problems in high‑availability setups.

DatabaseError TroubleshootingGTID
0 likes · 25 min read
How to Diagnose and Resolve MySQL Replication Errors in High‑Availability Environments
Java Captain
Java Captain
Jan 6, 2018 · Backend Development

Database Connection Pooling in Java: Concepts, Implementation, and Configuration

This article explains why creating a database connection for each request is inefficient, introduces the concept and configuration of connection pools, provides a custom Java DataSource implementation, and demonstrates the use of popular open‑source pools such as DBCP, C3P0, and Tomcat JNDI with complete code examples.

Connection PoolDatabaseJDBC
0 likes · 24 min read
Database Connection Pooling in Java: Concepts, Implementation, and Configuration
ITPUB
ITPUB
Jan 5, 2018 · Databases

Why PostgreSQL Stands Out: Essential Features and Extensions Explained

This article outlines the most compelling reasons to choose PostgreSQL, covering its advanced data types like JSONB and Range, powerful extensions such as Citus, HyperLogLog and PostGIS, logical replication, rich indexing options, upsert support, foreign data wrappers, and a host of legacy capabilities.

DatabaseIndexesJSONB
0 likes · 10 min read
Why PostgreSQL Stands Out: Essential Features and Extensions Explained
dbaplus Community
dbaplus Community
Dec 28, 2017 · Operations

Designing Scalable System Architecture: From Access Chains to Cloud‑Native Infrastructure

This comprehensive guide walks through the full lifecycle of enterprise system architecture, covering access‑chain analysis, network and hardware foundations, virtualization and container strategies, layered design, load‑balancing, database high‑availability, service segmentation, and operational safeguards such as CMDB, monitoring, and disaster‑recovery.

CMDBDatabaseOperations
0 likes · 34 min read
Designing Scalable System Architecture: From Access Chains to Cloud‑Native Infrastructure