BestHub
Sign in
Tagged articles

database

2754 articles · Page 25 of 28
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.

ClusterRedisSlot Migration
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.

DevOpsPerformanceTFS
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.

AlibabaTech historyblockchain
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.

OptimizationPerformanceRedis
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 DevelopmentDjangoORM
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.

Backendconsumer groupsdatabase
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.

PersistenceRedisReplication
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+ TreeMySQLPartitioning
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.

BackendDjangoModel
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.

BackendClusterLinux
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.

RedisSentineldatabase
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.

OraclePartitioningPerformance
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.

AIOperationsautomation
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.

RDBRedisVersion 5
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.

MycatOperationsautomation
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.

DMVRestoreSQL Server
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 CloudKey DesignPerformance
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.

InstallationLinuxMySQL
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.

backupdatabasedistributed systems
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.

EXPLAINIndex OptimizationMySQL
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.

DBAMySQLOptimization
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.

CRUDMySQLSQL
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.

DockerMaster‑SlaveMySQL
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 ComputingIDC planningMulti-Active
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 ReadInnoDBMVCC
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.

NoSQLdatabase
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.

BackendPerformancedatabase
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.

Javaconcurrencydatabase
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.

AIOpsDevOpsbig data
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.

FPGALSM TreeX-Engine
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.

ArchitectureRedisSentinel
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.

Javaconcurrencydatabase
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.

FPGALSM TreePerformance
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.

InnoDBLocksMySQL
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.

OracleReplicationSQL
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.

Javadatabase
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.

Enterprise ManagerOracleSQL
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.

ClusterRedisTutorial
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.

HATencent Cloudbusiness continuity
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.

BackendDesign PatternsJava
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 PumpOracleRMAN
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.

HTAPNewSQLSQL
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.

JavaMyBatisSpring Boot
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.

Error TroubleshootingGTIDMySQL
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.

JDBCJNDITomcat
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.

JSONBLogical ReplicationPostgreSQL
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.

CMDBOperationsdatabase
0 likes · 34 min read
Designing Scalable System Architecture: From Access Chains to Cloud‑Native Infrastructure
ITPUB
ITPUB
Dec 27, 2017 · Databases

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

This article explains the four MySQL transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a sample table and running step‑by‑step command‑line sessions that demonstrate dirty reads, non‑repeatable reads, phantom reads, and the practical limits of InnoDB's MVCC implementation.

InnoDBMySQLSQL
0 likes · 9 min read
Understanding MySQL Transaction Isolation Levels with Real‑World Examples
Alibaba Cloud Developer
Alibaba Cloud Developer
Dec 27, 2017 · Databases

How Alibaba’s Next‑Gen Database Powered Double 11: Elasticity, Cloud & AI

Alibaba’s database team explains how their next‑generation X‑DB system achieved extreme elasticity, high performance, and cost efficiency during the Double 11 shopping festival by leveraging cloud‑native hybrid deployment, containerization, storage‑compute separation, Paxos‑based consistency, and AI‑driven self‑optimizing DBA tools, while outlining key challenges and solutions.

AI OpsCloud ComputingPerformance Optimization
0 likes · 12 min read
How Alibaba’s Next‑Gen Database Powered Double 11: Elasticity, Cloud & AI
Efficient Ops
Efficient Ops
Dec 26, 2017 · Operations

From Oracle DBA to DevOps Leader: A 20‑Year Ops Journey and Lessons

This memoir chronicles a Chinese IT professional’s two‑decade evolution from a university student and Oracle DBA to a DevOps and cloud operations leader, sharing career milestones, technical choices, and practical insights for anyone pursuing a long‑term operations career.

Operationsdatabase
0 likes · 14 min read
From Oracle DBA to DevOps Leader: A 20‑Year Ops Journey and Lessons
ITPUB
ITPUB
Dec 22, 2017 · Databases

Mastering Redis: Key Design and Data‑Type Use Cases

This guide explains Redis’s core features, shows how to design clear key naming conventions, and demonstrates practical applications of the string, hash, list, set, and sorted‑set data types with concrete commands and examples for building fast, memory‑based caches.

Backend DevelopmentData TypesKey Design
0 likes · 10 min read
Mastering Redis: Key Design and Data‑Type Use Cases
Hujiang Technology
Hujiang Technology
Dec 18, 2017 · Mobile Development

An Introduction to Android Room: Entities, DAO, Database, Migrations, and Advanced Usage

This article provides a comprehensive guide to Android's Room persistence library, covering the creation of Entity classes, defining Data Access Objects (DAO), building the RoomDatabase, handling foreign keys, embedded objects, query methods, LiveData and RxJava return types, as well as database migrations and type converters for complex data types.

AndroidMobile DevelopmentORM
0 likes · 11 min read
An Introduction to Android Room: Entities, DAO, Database, Migrations, and Advanced Usage
ITPUB
ITPUB
Dec 12, 2017 · Databases

Understanding PostgreSQL’s Subquery Planner: How Query Optimization Works

This article explains how PostgreSQL transforms and rewrites query trees, why a completed transform‑rewrite tree may not be optimal, and details the subquery_planner’s role, tuple_fraction handling, and the step‑by‑step logical optimization process used to generate efficient execution plans.

Planner HookPostgreSQLQuery Optimization
0 likes · 7 min read
Understanding PostgreSQL’s Subquery Planner: How Query Optimization Works
ITPUB
ITPUB
Dec 7, 2017 · Databases

Master MySQL Query Optimization: From Architecture to High‑Performance Indexing

This article explains MySQL's logical architecture, the step‑by‑step query execution process, and provides practical performance‑tuning advice—including schema design, data‑type choices, index strategies, and specific query optimizations such as COUNT, JOIN, LIMIT pagination, and UNION—backed by code examples and diagrams.

MySQLPerformanceQuery Optimization
0 likes · 36 min read
Master MySQL Query Optimization: From Architecture to High‑Performance Indexing
ITPUB
ITPUB
Dec 6, 2017 · Databases

Mastering Oracle Data Dictionary: Types, Views, and Practical Queries

This article explains the classification of Oracle data dictionary objects, demonstrates how to query static and dynamic dictionary tables and views, lists common view families and permission views, and provides numerous SQL examples for inspecting users, tables, indexes, sequences, constraints, and PL/SQL objects.

OraclePerformanceSQL
0 likes · 13 min read
Mastering Oracle Data Dictionary: Types, Views, and Practical Queries
Senior Brother's Insights
Senior Brother's Insights
Nov 29, 2017 · Databases

Mastering SQL Performance: Proven Optimization Techniques and Best Practices

Learn a comprehensive methodology for SQL performance tuning, from identifying resource bottlenecks and understanding query processing stages to applying practical optimization tactics such as efficient joins, index usage, avoiding costly operations, and best‑practice guidelines that improve execution speed and resource consumption.

OptimizationPerformanceQuery Tuning
0 likes · 13 min read
Mastering SQL Performance: Proven Optimization Techniques and Best Practices
ITPUB
ITPUB
Nov 15, 2017 · Databases

Master MySQL JSON: Create, Query, Update, and Index JSON Data in MySQL 5.7+

This guide walks you through using MySQL's native JSON data type—creating tables with JSON columns, inserting simple and complex JSON values, updating nested structures, generating indexed columns from JSON fields, converting strings to JSON, and a comprehensive list of built‑in JSON functions.

JSONMySQLSQL
0 likes · 6 min read
Master MySQL JSON: Create, Query, Update, and Index JSON Data in MySQL 5.7+
ITPUB
ITPUB
Nov 9, 2017 · Databases

34 Proven Oracle SQL Optimization Tips to Boost Query Performance

This guide presents thirty‑four practical Oracle SQL optimization techniques—from choosing the most efficient table order and rewriting WHERE clauses to leveraging indexes, avoiding SELECT *, using DECODE, and replacing costly operations—helping developers dramatically improve query speed and resource usage.

OptimizationOraclePerformance
0 likes · 16 min read
34 Proven Oracle SQL Optimization Tips to Boost Query Performance
ITPUB
ITPUB
Nov 6, 2017 · Databases

How to Set Up MySQL Master‑Slave Replication with Docker in Minutes

This guide walks you through building custom MySQL Docker images, configuring master and slave my.cnf files, launching the containers, creating a replication user, and synchronizing the slave using Docker commands and a ready‑made shell script, all with detailed code examples.

DockerMaster‑SlaveMySQL
0 likes · 10 min read
How to Set Up MySQL Master‑Slave Replication with Docker in Minutes
Architecture Digest
Architecture Digest
Nov 6, 2017 · Backend Development

Understanding Concurrency, Synchronization, and Locking Mechanisms in Java and Hibernate

This article explains the concepts of synchronous and asynchronous execution, common concurrency problems such as dirty reads and non‑repeatable reads, and presents practical solutions using Java synchronized blocks, database pessimistic and optimistic locks, Hibernate lock modes, and performance‑optimizing techniques for high‑traffic web applications.

HibernateJavaconcurrency
0 likes · 25 min read
Understanding Concurrency, Synchronization, and Locking Mechanisms in Java and Hibernate
ITPUB
ITPUB
Oct 30, 2017 · Databases

How to Speed Up MySQL Queries with Covering Indexes: A Step‑by‑Step Guide

This article walks through a real MySQL case where a simple SELECT query runs slowly despite an existing index, explains why the optimizer chooses a full‑table scan, and demonstrates how adding a covering composite index reduces execution time from 260 ms to 13 ms.

Covering IndexMySQLdatabase
0 likes · 6 min read
How to Speed Up MySQL Queries with Covering Indexes: A Step‑by‑Step Guide
21CTO
21CTO
Oct 20, 2017 · Databases

Master MySQL Indexes: Boost Query Performance with Smart B+Tree Strategies

This guide explains MySQL B+Tree index structures, their advantages, how to create primary, unique, ordinary, full‑text, composite and prefix indexes, and provides practical rules and tips for designing efficient indexes, query patterns, and sorting strategies to dramatically improve database performance.

B+ TreeMySQLPerformance
0 likes · 14 min read
Master MySQL Indexes: Boost Query Performance with Smart B+Tree Strategies
ITPUB
ITPUB
Oct 9, 2017 · Databases

What’s New in PostgreSQL 10? Key Features and Improvements Explained

PostgreSQL 10, released after months of beta testing, brings logical replication, declarative table partitioning, higher query concurrency, notable performance gains, stronger SCRAM‑SHA‑256 authentication, and enhanced monitoring and control capabilities, marking a significant evolution for the open‑source database.

Logical ReplicationPostgreSQLTable Partitioning
0 likes · 3 min read
What’s New in PostgreSQL 10? Key Features and Improvements Explained
ITPUB
ITPUB
Oct 5, 2017 · Databases

Recover Accidentally Deleted Oracle Data with Backup, LogMiner, and Flashback

Oracle provides several powerful recovery mechanisms—logical backups with the import tool, physical file restoration with incomplete recovery, LogMiner analysis of redo logs, and Flashback Query—each illustrated through a scenario where a mistaken update to the TFUNDASSET table is corrected using step‑by‑step procedures and commands.

FlashbackLogMinerOracle
0 likes · 13 min read
Recover Accidentally Deleted Oracle Data with Backup, LogMiner, and Flashback
Qunar Tech Salon
Qunar Tech Salon
Sep 27, 2017 · Databases

Qunar Database High Availability and Backup Recovery Architecture

The article describes Qunar's 99.99% high‑availability goal for MySQL databases, outlines its HA designs (MMM, PXC, QMHA), compares hot and cold backup methods, discusses common backup challenges, and details Qunar's comprehensive backup and recovery solution including Percona XtraBackup, dedicated backup nodes, centralized management, and consistency verification.

MySQLbackupdatabase
0 likes · 8 min read
Qunar Database High Availability and Backup Recovery Architecture