BestHub
Sign in
Tagged articles
2670 articles
Page 26 of 27
dbaplus Community
dbaplus Community
Dec 22, 2016 · Databases

MariaDB Columnstore Deep Dive: Architecture, Performance, and Deployment

MariaDB Columnstore, the newly integrated InfiniDB storage engine, brings column‑store analytics to MySQL, offering P‑scale data handling, distributed deployment, and impressive performance gains over InnoDB, with detailed installation steps, kernel tuning, command‑line administration, and optimization tips for production environments.

AnalyticsColumnstoreInfiniDB
0 likes · 11 min read
MariaDB Columnstore Deep Dive: Architecture, Performance, and Deployment
dbaplus Community
dbaplus Community
Dec 16, 2016 · Databases

Why MariaDB Beats MySQL: Features, Compatibility, and Performance Insights

This article explains how MariaDB, a community‑driven fork of MySQL, maintains full compatibility while adding new storage engines, advanced replication, performance‑boosting features like XtraDB and thread pools, and why many organizations consider it a superior replacement for Oracle‑owned MySQL.

MariaDBReplicationStorage Engine
0 likes · 9 min read
Why MariaDB Beats MySQL: Features, Compatibility, and Performance Insights
High Availability Architecture
High Availability Architecture
Dec 9, 2016 · Backend Development

Serverless Backend Generation: Using a Generic CRUD Layer to Eliminate Traditional Backend Development

The article presents a serverless‑style solution that replaces a heavy backend with a lightweight, automatically generated CRUD layer, detailing RESTful API conventions, extensions for batch operations, query parameters, foreign‑key handling, and a Rails‑based code‑generation pipeline to streamline development of a high‑availability supply‑chain system.

APIBackend DevelopmentCRUD
0 likes · 18 min read
Serverless Backend Generation: Using a Generic CRUD Layer to Eliminate Traditional Backend Development
Meituan Technology Team
Meituan Technology Team
Dec 2, 2016 · Backend Development

Comprehensive Performance Optimization Strategies and Real-World Cases

The article presents a comprehensive set of performance‑optimization strategies—from code‑level refactoring, SQL tuning, and caching patterns to asynchronous processing, NoSQL selection, JVM and multithreading tuning—alongside real‑world cases that cut job runtimes from over 50 minutes to under 15 minutes and dramatically reduce database load.

AsynchronousBackendJVM
0 likes · 23 min read
Comprehensive Performance Optimization Strategies and Real-World Cases
Architecture Digest
Architecture Digest
Nov 26, 2016 · Databases

Redis Cache Update Strategies and Best Practices

This article summarizes common Redis cache update problems, compares four update approaches—including proactive, passive, and pre‑loading methods—and recommends a pre‑load strategy with key versioning to avoid data loss, improve performance, and reduce memory waste.

CacheUpdate Strategydatabase
0 likes · 8 min read
Redis Cache Update Strategies and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Nov 26, 2016 · Databases

Master MongoDB Sharding: Step-by-Step Setup and Verification

This guide walks through the reasons for sharding in MongoDB, explains the sharding architecture, and provides detailed commands to configure config servers, shard servers, and mongos, add shards, enable sharding on databases and collections, insert test data, and verify successful data distribution across shards.

ClusterMongoDBReplication
0 likes · 8 min read
Master MongoDB Sharding: Step-by-Step Setup and Verification
Architects' Tech Alliance
Architects' Tech Alliance
Nov 25, 2016 · Databases

Why NoSQL Matters: From ACID to CAP and Beyond

An in‑depth overview of NoSQL databases explains the limitations of traditional relational systems, details ACID properties, introduces the CAP theorem and BASE model, compares RDBMS with NoSQL, outlines advantages, disadvantages, history, classifications, and real‑world usage examples.

ACIDBASECAP theorem
0 likes · 12 min read
Why NoSQL Matters: From ACID to CAP and Beyond
MaGe Linux Operations
MaGe Linux Operations
Nov 25, 2016 · Databases

How to Set Up a MongoDB Replica Set on CentOS – Step‑by‑Step Guide

This article explains MongoDB’s key features, compares its advantages and disadvantages, and provides a detailed, step‑by‑step guide to installing, configuring, and verifying a replica set on CentOS 6.6, including commands for package installation, configuration file editing, service startup, node addition, and data synchronization verification.

CentOSMongoDBNoSQL
0 likes · 9 min read
How to Set Up a MongoDB Replica Set on CentOS – Step‑by‑Step Guide
dbaplus Community
dbaplus Community
Nov 22, 2016 · Databases

How to Add a ‘STOP ALL SLAVES’ Command to MySQL 5.6 Source Code

This guide walks through extending MySQL 5.6.32 by adding a new SQLCOM_STOP_SLAVES command that stops all replication slaves, detailing modifications to lex.h, sql_cmd.h, sql_yacc.yy, sql_parse.cc, and mysqld.cc, along with compilation tips and troubleshooting steps.

CReplicationSQL Command
0 likes · 7 min read
How to Add a ‘STOP ALL SLAVES’ Command to MySQL 5.6 Source Code
Practical DevOps Architecture
Practical DevOps Architecture
Nov 22, 2016 · Databases

Common MySQL SQL Statements and Table Alteration Cheat Sheet

This article compiles frequently used MySQL SQL commands—including data migration, multi‑table updates, conditional updates, aggregation inserts, and various ALTER TABLE operations such as adding indexes, dropping and adding columns—to serve as a practical reference for database developers.

DDLDMLData Migration
0 likes · 6 min read
Common MySQL SQL Statements and Table Alteration Cheat Sheet
dbaplus Community
dbaplus Community
Nov 20, 2016 · Databases

How to Slash HBase Read Latency: Proven Client, Server, and HDFS Tweaks

This article examines the common causes of high read latency in HBase—such as full GC, region‑server imbalance, low write throughput, and inefficient client settings—and provides concrete optimization steps for the client, server, column‑family design, and HDFS layers to dramatically improve performance.

Client TuningHBaseHDFS
0 likes · 16 min read
How to Slash HBase Read Latency: Proven Client, Server, and HDFS Tweaks
dbaplus Community
dbaplus Community
Nov 20, 2016 · Operations

Top Insights from the 2016 Global Agile Operations Summit

The 2016 Global Agile Operations Summit in Shanghai concluded with a series of expert sessions covering agile DevOps trends, cloud‑native automation platforms, database performance tuning, container orchestration, and real‑world case studies from leading companies, followed by the award ceremony honoring ten MVPs who drove innovation across operations and infrastructure.

AutomationContainerDevOps
0 likes · 15 min read
Top Insights from the 2016 Global Agile Operations Summit
Architects' Tech Alliance
Architects' Tech Alliance
Nov 19, 2016 · Databases

An Overview of Greenplum Database Architecture and Core Components

Greenplum is an open‑source, massively parallel processing (MPP) database built on PostgreSQL, offering ANSI‑SQL compliance, distributed ACID transactions, linear scalability, polymorphic storage, advanced optimizers, and extensive ecosystem integrations, making it suitable for large‑scale data warehousing, analytics, and big‑data workloads.

Data WarehousingGreenplumMPP
0 likes · 15 min read
An Overview of Greenplum Database Architecture and Core Components
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Nov 15, 2016 · Databases

How to Set Up Redis Master‑Slave Replication in Minutes

This guide walks you through configuring a simple Redis master‑slave setup, covering the benefits, step‑by‑step file modifications, essential replication directives, testing procedures, and common pitfalls to ensure high availability and read/write separation.

Configurationdatabasehigh availability
0 likes · 5 min read
How to Set Up Redis Master‑Slave Replication in Minutes
ITPUB
ITPUB
Nov 13, 2016 · Databases

Why Oracle DBMS_JOB Shows Next Date 4000‑01‑01 and How to Fix It

When an Oracle DBMS_JOB’s NEXT_DATE jumps to the far‑future date 4000‑01‑01, it indicates the job has failed repeatedly and been marked broken; this article explains the underlying reasons, examines error logs, and provides step‑by‑step commands to diagnose and restart the job.

DBMS_JOBJob SchedulingOracle
0 likes · 5 min read
Why Oracle DBMS_JOB Shows Next Date 4000‑01‑01 and How to Fix It
ITPUB
ITPUB
Nov 11, 2016 · Databases

Essential Oracle SQL Queries for Performance Monitoring and Troubleshooting

This guide compiles a comprehensive set of Oracle SQL statements and explanations for detecting fragmented tables, index fragmentation, high clustering factor tables, session and process mapping, DML lock analysis, DDL lock inspection, active SQL tracking, resource usage statistics, and various performance‑related metrics, helping DBAs diagnose and tune database behavior efficiently.

AdministrationOracleQueries
0 likes · 26 min read
Essential Oracle SQL Queries for Performance Monitoring and Troubleshooting
dbaplus Community
dbaplus Community
Nov 10, 2016 · Databases

Doubling SQL Speed: From Execution Plans to Business Logic Overhaul

A real‑world case study shows how a seemingly simple intersect query that took 20 seconds was optimized to 10 seconds by analyzing execution plans, rewriting the SQL, exploring parallel execution, and ultimately redesigning the business logic with a new timestamp column to enable incremental checks.

Performance OptimizationSQLbusiness logic
0 likes · 10 min read
Doubling SQL Speed: From Execution Plans to Business Logic Overhaul
ITPUB
ITPUB
Nov 9, 2016 · Databases

Step‑by‑Step Guide to Downgrade Oracle Database 12c to Earlier Releases

This guide provides a comprehensive checklist and scripted procedure for safely downgrading Oracle Database 12c (Standard or Enterprise Edition) to prior releases such as 11.2.0.3, 11.2.0.2, or 11.1.0.7, covering prerequisites, command‑line steps, post‑downgrade validation, and common pitfalls.

12cOracleSQL
0 likes · 13 min read
Step‑by‑Step Guide to Downgrade Oracle Database 12c to Earlier Releases
ITPUB
ITPUB
Nov 8, 2016 · Databases

40+ Essential Oracle SQL Queries Every DBA Should Know

This article compiles over forty practical Oracle SQL queries covering date manipulation, server information, data dictionary lookups, database administration, performance monitoring, and utility functions, providing developers with ready-to-use commands to streamline everyday database tasks.

AdministrationOracleQueries
0 likes · 16 min read
40+ Essential Oracle SQL Queries Every DBA Should Know
ITPUB
ITPUB
Nov 3, 2016 · Databases

Why Nested Subqueries Slow Down Your SQL Queries and How to Diagnose Them

The article recounts a real‑world incident where a complex SQL query took over 20 seconds, explains how to pinpoint whether the slowdown originates from joins or nested subqueries, and shares practical steps and insights for diagnosing and fixing such performance issues.

SQLSubquerydatabase
0 likes · 6 min read
Why Nested Subqueries Slow Down Your SQL Queries and How to Diagnose Them
dbaplus Community
dbaplus Community
Nov 3, 2016 · Databases

Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization

A detailed case study describes how a rapidly growing edit‑log feature caused query times to soar to 30 seconds, and walks through the step‑by‑step investigation, identification of a custom function bottleneck, data‑volume analysis, and the eventual implementation of partitioning, mandatory time filters, and composite indexing to restore acceptable performance.

PL/SQLPartitioningSQL
0 likes · 12 min read
Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization
ITPUB
ITPUB
Oct 28, 2016 · Databases

Step‑by‑Step Oracle Data Guard Switchover and Failover Guide

This article provides a detailed, hands‑on walkthrough of Oracle Data Guard switchover in normal operation and the subsequent steps to convert the original primary to a standby, including all necessary SQL commands, instance restarts, and verification queries.

Data GuardOracleSQL
0 likes · 6 min read
Step‑by‑Step Oracle Data Guard Switchover and Failover Guide
ITPUB
ITPUB
Oct 27, 2016 · Databases

Mastering Oracle Permission Views: Query Roles, Privileges, and Sessions

This guide explains the most commonly used Oracle permission‑view tables, shows how to list role assignments, object privileges, system privileges, session privileges, and role memberships, and demonstrates the impact of the WITH ADMIN OPTION through practical SQL examples.

DBAOracleSQL
0 likes · 7 min read
Mastering Oracle Permission Views: Query Roles, Privileges, and Sessions
dbaplus Community
dbaplus Community
Oct 25, 2016 · Databases

Master MySQL: Essential Database Operations, Table Management, and Index Optimization

This guide walks through MySQL fundamentals—including viewing, creating, and using databases, managing users and privileges, creating and altering tables, inserting, updating, deleting, and querying data, as well as index types, best‑practice tips, and execution‑plan analysis—providing concrete commands and examples for each step.

SQLTableUser Management
0 likes · 14 min read
Master MySQL: Essential Database Operations, Table Management, and Index Optimization
ITPUB
ITPUB
Oct 23, 2016 · Databases

Essential MongoDB Interview Questions & Answers You Need to Master

This comprehensive guide presents the most common MongoDB interview questions, covering NoSQL fundamentals, replication, sharding, transactions, profiling, storage nuances, and operational details, providing concise yet thorough answers to help candidates confidently tackle technical interviews.

MongoDBNoSQLReplication
0 likes · 11 min read
Essential MongoDB Interview Questions & Answers You Need to Master
ITPUB
ITPUB
Oct 19, 2016 · Databases

Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes

This article demonstrates how InnoDB returns rows in primary‑key order during full‑table scans, while queries that use a secondary index follow the leaf‑node order of that index, and it compares performance implications of index‑only scans versus clustered‑index scans.

InnoDBdatabaseindex
0 likes · 12 min read
Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes
ITPUB
ITPUB
Oct 15, 2016 · Databases

Mastering Redis: Data Types, Memory Tweaks, and Persistence Strategies

This article explains Redis's five core data types, their internal representations and typical commands, details memory‑saving parameters for each type, compares the four persistence methods with their trade‑offs, and offers practical recommendations for optimal performance and stability.

Data TypesMemory Optimizationdatabase
0 likes · 16 min read
Mastering Redis: Data Types, Memory Tweaks, and Persistence Strategies
ITPUB
ITPUB
Oct 12, 2016 · Databases

34 Proven Oracle SQL Tricks to Boost Query Performance

This guide compiles 34 practical Oracle SQL optimization techniques—from selecting the optimal table order and rewriting WHERE clauses to leveraging indexes, avoiding costly operators, and fine‑tuning execution plans—helping developers dramatically reduce query execution time and resource consumption.

OracleSQLdatabase
0 likes · 19 min read
34 Proven Oracle SQL Tricks to Boost Query Performance
ITPUB
ITPUB
Oct 11, 2016 · Databases

How to Secure Oracle RMAN Backups with Password, Wallet, and Hybrid Encryption

This guide explains why backup security is critical for enterprise databases, introduces Oracle RMAN's three encryption strategies, and provides step‑by‑step commands to configure password‑based encryption, perform backups, handle decryption errors, and finally disable encryption safely.

BackupOracleRMAN
0 likes · 9 min read
How to Secure Oracle RMAN Backups with Password, Wallet, and Hybrid Encryption
ITPUB
ITPUB
Oct 11, 2016 · Databases

How a Simple MySQL UPDATE Solved a Multi‑Threaded Counting Problem

A developer recounts how a seemingly trivial MySQL UPDATE statement—‘UPDATE table_name SET sum = sum + 5 WHERE id = 1’—proved thread‑safe for aggregating file counts across a multi‑threaded module, highlighting the importance of knowledge reserves and cautious evaluation before implementing complex synchronization solutions.

SQLconcurrencydatabase
0 likes · 5 min read
How a Simple MySQL UPDATE Solved a Multi‑Threaded Counting Problem
ITPUB
ITPUB
Oct 8, 2016 · Databases

Mastering Database Sharding, Replication, and High‑Availability Strategies

This article explains core database concepts such as sharding, replication, routing strategies, and high‑availability designs, detailing how to achieve read/write separation, cache integration, and consistency handling in a master‑slave architecture for large‑scale systems.

Read-Write SeparationReplicationdatabase
0 likes · 8 min read
Mastering Database Sharding, Replication, and High‑Availability Strategies
ITPUB
ITPUB
Oct 5, 2016 · Databases

How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools

This guide walks through exporting Oracle PL/SQL user objects and table data with PL/SQL Developer, then restoring them by dropping the existing user, recreating it with necessary privileges, executing the exported SQL script, and importing table data while handling constraints and triggers.

BackupExportImport
0 likes · 5 min read
How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools
ITPUB
ITPUB
Sep 28, 2016 · Databases

How to Diagnose and Repair Bad Blocks in Oracle Databases

This guide explains what Oracle bad blocks are, how they affect the database, common causes, methods to detect them, and step‑by‑step recovery techniques—including full datafile restore, RMAN block recovery, ROWID range scans, EVENT 10231, and DBMS_REPAIR—plus pre‑emptive detection tools.

Bad BlocksDBMS_REPAIROracle
0 likes · 10 min read
How to Diagnose and Repair Bad Blocks in Oracle Databases
ITPUB
ITPUB
Sep 24, 2016 · Databases

Recover a Dropped MySQL Database Using Full Backup and Binlog Incrementals

This guide shows how to restore a MySQL database that was accidentally dropped by combining a nightly full mysqldump backup (with master‑log info) and the subsequent binlog files, extracting only the needed statements and replaying them in order.

BackupBinlogData Recovery
0 likes · 8 min read
Recover a Dropped MySQL Database Using Full Backup and Binlog Incrementals
MaGe Linux Operations
MaGe Linux Operations
Sep 19, 2016 · Databases

Master Redis Cluster Setup: From Basics to Scaling Nodes

Learn how to build and manage a Redis cluster on Linux, covering the rationale for clustering, hash slot mechanics, node configuration, adding/removing nodes, resharding, and integrating master‑slave replicas, with step‑by‑step commands and practical examples.

ClusterDevOpsLinux
0 likes · 11 min read
Master Redis Cluster Setup: From Basics to Scaling Nodes
dbaplus Community
dbaplus Community
Sep 18, 2016 · Databases

Master Oracle Hierarchical Queries: From Basics to Advanced Techniques

This article provides a comprehensive guide to Oracle hierarchical queries, covering fundamental concepts, key clauses and operators, practical examples with the s_emp table, advanced features like SYS_CONNECT_BY_PATH, CONNECT_BY_ISLEAF, NOCYCLE, and real‑world use cases such as reporting, pruning branches, and calculating aggregates in tree structures.

CONNECT BYHierarchical QueryOracle
0 likes · 25 min read
Master Oracle Hierarchical Queries: From Basics to Advanced Techniques
Efficient Ops
Efficient Ops
Sep 17, 2016 · Databases

How LeTV Built a Scalable Docker‑Powered RDS Platform

This article examines the limitations of traditional database provisioning, explains why a platform‑based RDS solution is needed, and details LeTV's evolution of its cloud‑native RDS service—including Docker containerization, architecture upgrades, elastic scaling, monitoring, and lessons learned—providing a comprehensive guide for building efficient, automated database platforms.

DockerRDSdatabase
0 likes · 25 min read
How LeTV Built a Scalable Docker‑Powered RDS Platform
Node Underground
Node Underground
Sep 12, 2016 · Databases

How to Keep Your Database Clean During Integration Tests?

When writing integration tests that involve database operations, developers must ensure that test execution does not pollute the original data, and the article explores strategies such as using transaction rollbacks, recreating databases, and mocking database interfaces to maintain data integrity.

Backend DevelopmentMockingdatabase
0 likes · 2 min read
How to Keep Your Database Clean During Integration Tests?
dbaplus Community
dbaplus Community
Sep 1, 2016 · Databases

Master MySQL Optimization: Essential Commands, Logs, and Tools

This guide walks through practical MySQL optimization steps, including status checks, variable inspection, slow‑query and general‑log configuration, essential management commands, detailed mysqldump usage, mysqldumpslow analysis, and the mysqlsla utility for performance diagnostics.

SQLdatabasemysql
0 likes · 8 min read
Master MySQL Optimization: Essential Commands, Logs, and Tools
ITPUB
ITPUB
Aug 31, 2016 · Databases

Lock‑Free Transactions and Cache Switching: MVCC Techniques for Key‑Value Stores

This article explains how traditional ACID transactions fall short for modern large‑scale systems and presents lock‑free transaction methods, atomic and partial cache‑switch techniques, and a PostgreSQL‑style MVCC model for key‑value databases, including practical rules and trade‑offs.

CacheKey-ValueMVCC
0 likes · 10 min read
Lock‑Free Transactions and Cache Switching: MVCC Techniques for Key‑Value Stores
dbaplus Community
dbaplus Community
Aug 3, 2016 · Databases

How to Build a Minimal Relational Database from Scratch

This article explains the theoretical foundations of relational databases, outlines the essential storage, engine, and UI layers, and walks through a concrete minimal implementation using fixed‑length tables, B+‑tree indexes, simple SQL parsing with regular expressions, and a TCP‑based client interface.

B+TreeRelationalSQL parsing
0 likes · 12 min read
How to Build a Minimal Relational Database from Scratch
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2016 · Operations

Mastering MHA Core Parameters: Complete Guide to MySQL HA Configuration

This article provides a detailed walkthrough of MHA's core configuration parameters—including server scopes, connection settings, candidate master rules, failover scripts, and monitoring options—explaining where each setting belongs and how to fine‑tune MySQL high‑availability behavior.

ConfigurationMHAOperations
0 likes · 11 min read
Mastering MHA Core Parameters: Complete Guide to MySQL HA Configuration
Architect
Architect
Jul 25, 2016 · Databases

Analysis of MySQL Network Communication Protocol (MySQL 5.7)

This article examines MySQL's network communication stack—from the high‑level MySQL packet protocol down to the socket layer—detailing session creation, NET/VIO handling, result‑set transmission, metadata overhead, and performance measurements using MySQL 5.7.

MySQL5.7databasemysql
0 likes · 10 min read
Analysis of MySQL Network Communication Protocol (MySQL 5.7)
Efficient Ops
Efficient Ops
Jul 17, 2016 · Operations

Why Oracle RAC Node Reboots Repeatedly? Time Sync, Heartbeats & Hardware Fixes

This article details a step‑by‑step investigation of a two‑node Oracle RAC environment where node 2 repeatedly rebooted, covering time‑synchronization checks, database and network heartbeat analysis, hardware diagnostics, and the final resolution through firmware and memory replacement.

RACdatabasetroubleshooting
0 likes · 7 min read
Why Oracle RAC Node Reboots Repeatedly? Time Sync, Heartbeats & Hardware Fixes
21CTO
21CTO
Jun 16, 2016 · Backend Development

How We Transformed a Legacy System’s Performance: Real‑World Code‑Level Optimizations

This article walks through a real‑world project's performance evolution, detailing server specs, a litany of scalability and reliability problems, and concrete code‑level solutions such as database deadlock mitigation, transaction shortening, thread‑pool redesign, and logging improvements.

BackendJavaPerformance Optimization
0 likes · 11 min read
How We Transformed a Legacy System’s Performance: Real‑World Code‑Level Optimizations
Java High-Performance Architecture
Java High-Performance Architecture
Jun 9, 2016 · Databases

Discover MySQL 5.7: 9 Powerful New Features You Must Know

MySQL 5.7 introduces major enhancements such as native JSON support, an expanded Performance Schema, a new SYS Schema for health monitoring, improved security, advanced GIS capabilities, three‑fold query throughput gains, InnoDB optimizations, multi‑source replication, and a smarter optimizer with dynamic costing.

GISInnoDBJSON
0 likes · 3 min read
Discover MySQL 5.7: 9 Powerful New Features You Must Know
Architecture Digest
Architecture Digest
Jun 7, 2016 · Databases

Curated List of MongoDB Learning Resources

This article provides a curated collection of online MongoDB learning resources, including the official website, Chinese community, issue tracker, blogs, and various tutorial sites such as Shiyanlou, imooc, Yiibai, Runoob, and others for developers seeking comprehensive database education.

Learning ResourcesMongoDBNoSQL
0 likes · 2 min read
Curated List of MongoDB Learning Resources
Tencent Music Tech Team
Tencent Music Tech Team
May 27, 2016 · Databases

Cross‑IDC Disaster Recovery Solution for KV Storage via a Proxy Layer

The article proposes a cross‑IDC disaster‑recovery architecture for key‑value stores that uses a storage proxy layer to record write logs in the primary data center, forward them to a read‑only backup center for replay, and route reads via load‑balancing, while noting current limitations such as complex configuration, low synchronization concurrency, and lack of multi‑write support.

KV storagecross-IDCdatabase
0 likes · 4 min read
Cross‑IDC Disaster Recovery Solution for KV Storage via a Proxy Layer
ITPUB
ITPUB
May 25, 2016 · Databases

Mastering Redis Replication: Features, Mechanics, and Deployment Guide

Redis replication offers high‑availability through master‑slave syncing, supporting multiple slaves, cascading replication, non‑blocking data transfer, read‑write separation, and optional disk‑less sync, with detailed steps for configuration, safety considerations, partial resynchronization, and practical deployment examples.

Master‑SlaveReplicationdatabase
0 likes · 8 min read
Mastering Redis Replication: Features, Mechanics, and Deployment Guide
Big Data and Microservices
Big Data and Microservices
May 11, 2016 · Backend Development

How to Build a Scalable Flash‑Sale System that Handles Massive Traffic

This article analyzes flash‑sale (抢购) business scenarios, outlines a layered architecture separating business and data layers, explains decoupling front‑end pressure, uses Redis‑based queues and caching to manage high‑frequency inventory checks, and describes multi‑party reconciliation mechanisms to ensure reliable stock consistency under extreme load.

Backend ArchitectureSystem Designdatabase
0 likes · 11 min read
How to Build a Scalable Flash‑Sale System that Handles Massive Traffic
MaGe Linux Operations
MaGe Linux Operations
May 10, 2016 · Operations

10 Essential Practices to Prevent Operational Failures in Database Management

This article outlines ten practical guidelines for operations engineers—ranging from mandatory rollback testing and cautious handling of destructive commands to robust backup verification, vigilant monitoring, and disciplined handover procedures—to dramatically reduce system outages and improve overall reliability.

AutomationBackupOperations
0 likes · 18 min read
10 Essential Practices to Prevent Operational Failures in Database Management
Big Data and Microservices
Big Data and Microservices
May 8, 2016 · Backend Development

How to Build a Scalable Flash‑Sale System: Architecture, Challenges & Solutions

This article dissects the technical challenges of high‑traffic flash‑sale (seckill) systems, outlining typical e‑commerce flow, unique seckill characteristics, and detailed solutions for isolation, load handling, bandwidth, request throttling, order processing, database design, caching, concurrency control, and anti‑cheat mechanisms.

BackendSystem Architecturedatabase
0 likes · 37 min read
How to Build a Scalable Flash‑Sale System: Architecture, Challenges & Solutions
Architecture Digest
Architecture Digest
May 8, 2016 · Databases

MySQL High Availability Architectures: Overview of Common Solutions

This article reviews the main MySQL high‑availability architectures—including shared‑storage SAN, DRBD disk replication, keepalived/heartbeat, MHA, ZooKeeper‑based HA, Galera/PXC clustering, and middleware proxy solutions—detailing their principles, advantages, limitations, and suitability for different business scenarios.

ClusterHAReplication
0 likes · 17 min read
MySQL High Availability Architectures: Overview of Common Solutions
ITPUB
ITPUB
May 6, 2016 · Databases

How Oracle Handles Physical & Logical Reads with Latches and Buffer Pins

Oracle’s block access mechanism involves hashing block addresses to locate hash buckets, using CBC latches and buffer pins to coordinate logical and physical reads, and following distinct step‑by‑step procedures for non‑unique index reads, unique index reads, and write operations, ensuring concurrency safety.

Buffer CacheLatchLogical Read
0 likes · 9 min read
How Oracle Handles Physical & Logical Reads with Latches and Buffer Pins
MaGe Linux Operations
MaGe Linux Operations
May 5, 2016 · Databases

Mastering MySQL Backups: Strategies, Types, and Tools for Reliable Data Protection

This guide explains why data backup is essential, outlines backup types (full, incremental, differential), compares MySQL backup methods (hot, warm, cold), evaluates physical vs logical approaches, reviews common tools like mysqldump, cp, tar, LVM snapshots, and xtrabackup, and offers strategies for choosing the right solution.

BackupData Protectiondatabase
0 likes · 8 min read
Mastering MySQL Backups: Strategies, Types, and Tools for Reliable Data Protection
ITPUB
ITPUB
May 5, 2016 · Databases

Top 50 SQL Server Query Optimization Tips to Boost Performance

This comprehensive guide enumerates over forty common causes of slow SQL Server queries and provides detailed optimization techniques—including indexing strategies, hardware upgrades, partitioning, cursor handling, and configuration tweaks—to dramatically improve query performance and reduce resource bottlenecks.

SQL Serverdatabaseindexes
0 likes · 21 min read
Top 50 SQL Server Query Optimization Tips to Boost Performance
ITPUB
ITPUB
May 4, 2016 · Databases

Master Oracle Triggers: Real‑World Examples and Step‑by‑Step Guide

This article explains Oracle trigger fundamentals, syntax, and a series of practical examples—including preventing weekend updates, auto‑incrementing IDs, logging DML actions, aggregating department salaries, capturing deletions, view‑based inserts, salary change alerts, and tracking CREATE/DROP operations—complete with full SQL code snippets.

OraclePL/SQLSQL
0 likes · 12 min read
Master Oracle Triggers: Real‑World Examples and Step‑by‑Step Guide
21CTO
21CTO
Apr 29, 2016 · Backend Development

How LeTV Scaled Its Payment System to 100k Orders per Second with Sharding and HA

This article explains how LeTV's payment platform handled a hundred‑fold surge in traffic by redesigning its architecture with database sharding, a custom order‑ID scheme, asynchronous consistency, high‑availability clustering, data tiering, and a coarse‑fine request pipeline to sustain up to 100,000 orders per second.

databasehigh-availabilityorder ID
0 likes · 15 min read
How LeTV Scaled Its Payment System to 100k Orders per Second with Sharding and HA
Efficient Ops
Efficient Ops
Apr 28, 2016 · Databases

How Oracle DB Embraces DevOps in the Cloud Era

This article summarizes Gai Guoqiang's presentation on Oracle Database DevOps practices, covering Oracle's cloud strategy, the shifting competitive landscape, the impact of cloud on DBA roles, and how DevOps principles are reshaping traditional database operations and performance management.

DBADevOpscloud
0 likes · 13 min read
How Oracle DB Embraces DevOps in the Cloud Era
dbaplus Community
dbaplus Community
Apr 28, 2016 · Databases

Unlock Oracle 12c Optimizer: New Stats, Adaptive Features & Advanced Techniques

This article explores the major enhancements in Oracle 12c's optimizer, including session‑level statistics for global temporary tables, new DBMS_STATS reporting procedures, adaptive features, advanced join elimination methods, incremental and concurrent statistics collection, and automatic column‑group detection, providing practical guidance for DBAs and developers.

12cDBMS_STATSOracle
0 likes · 23 min read
Unlock Oracle 12c Optimizer: New Stats, Adaptive Features & Advanced Techniques
ITPUB
ITPUB
Apr 25, 2016 · Databases

How to Move Oracle Tablespaces and Datafiles to a New Location

This guide explains step‑by‑step how to offline Oracle datafiles or tablespaces, copy them to a new directory, rename them, recover if needed, bring them back online, and safely shut down and restart the database to complete the migration.

DatafileOracleSQL
0 likes · 4 min read
How to Move Oracle Tablespaces and Datafiles to a New Location
ITPUB
ITPUB
Apr 21, 2016 · Databases

Master Oracle Profiles: Limits, Parameters, and Example Creation

Oracle profiles let administrators enforce password policies and resource limits such as CPU time, I/O, session count, and idle periods, with detailed parameters for both kernel resources and password rules, and the article provides a complete example of creating a custom profile using SQL.

OracleProfilesSQL
0 likes · 5 min read
Master Oracle Profiles: Limits, Parameters, and Example Creation
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Apr 13, 2016 · Databases

MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms

This article presents a series of MySQL backend improvements—including Group Commit redesign, DDL fast‑fail handling, GTID allocation refinements, persistent InnoDB auto‑increment values, replication parallelism, and key‑partition hash algorithm changes—detailing motivations, implementation steps, and performance results.

GTIDGroup CommitInnoDB
0 likes · 24 min read
MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms
21CTO
21CTO
Mar 31, 2016 · Databases

Why Does MySQL Produce Garbled Text? Causes, Prevention, and Fixes

This article explains the multiple encoding/decoding steps MySQL performs when storing and retrieving data, identifies why mismatched character sets cause mojibake, and provides practical methods to avoid and repair corrupted text in MySQL tables.

character encodingcharset conversiondata repair
0 likes · 17 min read
Why Does MySQL Produce Garbled Text? Causes, Prevention, and Fixes
ITPUB
ITPUB
Mar 25, 2016 · Databases

How to Perform a Silent Oracle 11g Database Installation and Resolve Common Errors

This guide explains the different Oracle database installation methods, focuses on silent installation using response files, shows the required file templates, demonstrates the runInstaller command, and walks through typical permission and syntax errors with practical troubleshooting steps.

OracleResponse FileSilent Install
0 likes · 5 min read
How to Perform a Silent Oracle 11g Database Installation and Resolve Common Errors