BestHub
Sign in
Tagged articles

database

2754 articles · Page 26 of 28
Ctrip Technology
Ctrip Technology
Sep 4, 2017 · Databases

Investigation of Performance Degradation and Locking Issues in MySQL 5.7.18 Partition Tables

This article investigates the performance degradation and lock timeout issues observed in MySQL 5.7.18 partition tables, reproduces the problem with test cases, analyzes InnoDB lock behavior through source code debugging, validates the root cause related to partition scan locking, and confirms it as a regression bug in MySQL 5.7.

InnoDBMySQLPartition Tables
0 likes · 8 min read
Investigation of Performance Degradation and Locking Issues in MySQL 5.7.18 Partition Tables
MaGe Linux Operations
MaGe Linux Operations
Sep 3, 2017 · Databases

Top MySQL Interview Q&A: Replication, InnoDB, Optimization & Backup

This article compiles a comprehensive set of MySQL interview questions covering replication mechanisms, differences between MyISAM and InnoDB, character type nuances, transaction logging, binlog formats, performance tuning, backup strategies, monitoring, consistency checks, and handling large datasets, providing concise answers for each topic.

InnoDBMySQLReplication
0 likes · 18 min read
Top MySQL Interview Q&A: Replication, InnoDB, Optimization & Backup
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 30, 2017 · Databases

Choosing Between Memcached and Redis: Architecture, Performance, and Real-World Use Cases

This article examines the client‑server architecture of Memcached, the slab‑based memory management of both Memcached and Redis, compares their performance, memory efficiency, persistence, data structures and networking models, and presents practical Redis use cases such as caching, ranking, pub/sub, queues, and real‑time analytics.

PerformanceRediscaching
0 likes · 25 min read
Choosing Between Memcached and Redis: Architecture, Performance, and Real-World Use Cases
MaGe Linux Operations
MaGe Linux Operations
Aug 25, 2017 · Backend Development

Master Django: A Complete Beginner-to-Advanced Tutorial

This guide introduces Django’s fundamentals, explains its MTV architecture, walks through project and app setup, URL routing, views, models, admin customization, database configuration, and essential commands, providing a practical roadmap for quickly building web applications.

BackendDjangoMVC
0 likes · 13 min read
Master Django: A Complete Beginner-to-Advanced Tutorial
ITPUB
ITPUB
Aug 25, 2017 · Operations

Automate MySQL Database Backups with Bash and Cron

This guide explains how to create a reliable MySQL backup solution by checking disk space, setting up a backup directory, writing a shell script for mysqldump (with optional compression), granting execution rights, scheduling the script with crontab, and verifying the job, while also covering crontab syntax and examples.

CronMySQLbackup
0 likes · 8 min read
Automate MySQL Database Backups with Bash and Cron
Java High-Performance Architecture
Java High-Performance Architecture
Aug 18, 2017 · Databases

How Couchbase Powers Personalization, Real‑Time Big Data, and Content Management

This article explains how Couchbase, a distributed NoSQL database, enables personalization, real‑time big‑data processing, and flexible content management for large enterprises, highlighting key requirements, solutions, and real‑world case studies from AOL, PayPal, and a Fortune‑500 media company.

CouchbaseNoSQLcontent management
0 likes · 11 min read
How Couchbase Powers Personalization, Real‑Time Big Data, and Content Management
ITPUB
ITPUB
Aug 15, 2017 · Operations

Automate MySQL Database Backups on Linux with Bash and Cron

This guide explains why database backups are essential, walks through checking disk space, creating a backup directory, writing a Bash script to dump and compress MySQL data, granting execution rights, and scheduling the script with crontab to ensure reliable, automated backups.

CronMySQLbackup
0 likes · 8 min read
Automate MySQL Database Backups on Linux with Bash and Cron
21CTO
21CTO
Aug 10, 2017 · Backend Development

How to Build a High‑Concurrency Flash‑Sale (SecKill) System in Java

This article explains how to design and implement a Java‑based flash‑sale (seckill) system that can handle tens of thousands of concurrent requests, covering entity modeling, DAO methods, service logic, controller handling, a concurrency simulation test, and an improved locking strategy to prevent overselling.

JPAJavaSpring
0 likes · 9 min read
How to Build a High‑Concurrency Flash‑Sale (SecKill) System in Java
ITPUB
ITPUB
Aug 3, 2017 · Databases

Boost Oracle Query Speed with Parallel Processing: A Practical Guide

This article explains how Oracle's parallel processing feature can accelerate data‑intensive queries by configuring session, table, or hint‑based parallelism, shows the degree‑of‑parallelism formula, and presents experimental results that compare execution times under different settings.

OracleSQLdatabase
0 likes · 8 min read
Boost Oracle Query Speed with Parallel Processing: A Practical Guide
dbaplus Community
dbaplus Community
Aug 1, 2017 · Backend Development

How to Tackle Real‑World Performance Bottlenecks: Tools, Techniques, and Case Studies

During a beta release, a .NET system faced slow page responses, time‑outs, high server load, and database deadlocks, prompting a systematic performance‑tuning process that covers mindset, problem reproduction, classification, tool‑based diagnosis, and concrete code, SQL, and algorithm optimizations with detailed case studies.

Profilingdatabasedotnet
0 likes · 15 min read
How to Tackle Real‑World Performance Bottlenecks: Tools, Techniques, and Case Studies
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jul 13, 2017 · Backend Development

How We Boosted a Payment Service from 40TPS to 60TPS: Real-World Backend Optimizations

An in‑depth case study of a no‑card payment system reveals common backend pitfalls—database deadlocks, long‑running transactions, thread‑pool misuse, excessive logging, and missing monitoring—and demonstrates practical fixes using Redis locks, refined transaction scopes, controlled thread pools, and optimized logging to dramatically improve scalability and reliability.

BackendJavaOptimization
0 likes · 11 min read
How We Boosted a Payment Service from 40TPS to 60TPS: Real-World Backend Optimizations
WeChat Client Technology Team
WeChat Client Technology Team
Jun 27, 2017 · Mobile Development

Unlock WCDB Android: Encryption, Migration, FTS, and Performance Tips

This article explains how WCDB for Android simplifies encryption with SQLiteCipherSpec, enables seamless data migration, provides a custom FTS3/4 tokenizer with dynamic ICU loading, and offers log redirection and performance monitoring tools, plus an optimized cursor implementation for high‑performance mobile apps.

AndroidFTSPerformance
0 likes · 8 min read
Unlock WCDB Android: Encryption, Migration, FTS, and Performance Tips
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jun 26, 2017 · Databases

Building Scalable MySQL HA: From MHA to 7‑Layer Proxy and RDS

After initially focusing on a distributed MySQL system, the author describes why open‑source HA solutions like MHA were unsuitable, then details the design and implementation of a 4‑layer NAT‑based proxy (RDS) and a more advanced 7‑layer application‑level proxy, highlighting features such as authentication, load balancing, read/write splitting, and multi‑datacenter awareness.

MySQLProxyRDS
0 likes · 11 min read
Building Scalable MySQL HA: From MHA to 7‑Layer Proxy and RDS
Java Backend Technology
Java Backend Technology
Jun 19, 2017 · Databases

Design Efficient Redis Keys for Pattern‑Matching Queries

This article explains how to design concise Redis keys that enable multi‑condition and fuzzy queries by using a structured naming convention, demonstrates the implementation within a Java SSM project, and provides code snippets for key assembly, querying, and deletion.

JavaKey DesignRedis
0 likes · 6 min read
Design Efficient Redis Keys for Pattern‑Matching Queries
Qunar Tech Salon
Qunar Tech Salon
Jun 18, 2017 · Databases

Understanding and Applying Common Table Expressions (CTE) in SQL

This article introduces Common Table Expressions (CTE) in SQL, explains how they improve query readability and enable writable temporary tables, demonstrates multi‑table modifications, advanced CRUD scenarios, implements a ring‑buffer using CTE, and discusses performance benefits and potential pitfalls.

CTESQLdata modeling
0 likes · 12 min read
Understanding and Applying Common Table Expressions (CTE) in SQL
21CTO
21CTO
Jun 18, 2017 · Databases

Mastering Redis High Availability: Sentinel, VIP, and Cluster Strategies

This article explains why Redis high‑availability is essential, details the inner workings of Redis Sentinel, compares several HA architectures—including Sentinel with DNS or VIP, client‑side Sentinel, Keepalived/Haproxy, Redis Cluster, Twemproxy, and Codis—lists their pros and cons, and shares practical best‑practice recommendations for building reliable Redis deployments.

ClusterRedisSentinel
0 likes · 19 min read
Mastering Redis High Availability: Sentinel, VIP, and Cluster Strategies
ITPUB
ITPUB
Jun 18, 2017 · Databases

Master MySQL: From Database Basics to Advanced Character Set & Collation Handling

This comprehensive guide explains what a database is, distinguishes relational and non‑relational types, walks through MySQL client‑server architecture, details SQL syntax for creating, querying, altering, and dropping databases, tables, and data, and resolves common Chinese character‑set and collation issues with practical commands and examples.

CRUDMySQLSQL
0 likes · 20 min read
Master MySQL: From Database Basics to Advanced Character Set & Collation Handling
ITPUB
ITPUB
Jun 16, 2017 · Databases

Mastering Oracle Listener: Functions, Commands, and Registration Explained

This article provides a comprehensive guide to Oracle Listener, covering its core functions, how to operate it via lsnrctl commands on Windows, detailed configuration of listener.ora for static and dynamic registration, and best practices for ensuring high availability and load balancing.

ConfigurationOracleRAC
0 likes · 16 min read
Mastering Oracle Listener: Functions, Commands, and Registration Explained
ITPUB
ITPUB
Jun 10, 2017 · Databases

Understanding Oracle Character Sets and NLS_LANG: A Complete Guide

Oracle character sets define how byte data maps to symbols, with NLS_LANG controlling client language, territory, and charset; this guide explains the components, naming conventions, differences between database and client sets, export/import conversion processes, and methods to view or modify character sets safely.

Export ImportNLS_LANGOracle
0 likes · 17 min read
Understanding Oracle Character Sets and NLS_LANG: A Complete Guide
ITPUB
ITPUB
Jun 9, 2017 · Databases

Master SQLite: From Installation to Advanced Queries in One Guide

This comprehensive SQLite tutorial walks beginners through what SQLite is, how to install it on Windows and Linux, essential syntax, CRUD operations, database objects, functions, and language-specific programming interfaces, providing step‑by‑step instructions and visual aids for practical mastery.

InstallationSQLSQLite
0 likes · 10 min read
Master SQLite: From Installation to Advanced Queries in One Guide
ITPUB
ITPUB
Jun 7, 2017 · Databases

Top 38 Oracle SQL Performance Tips for Faster Queries

This article compiles 38 practical Oracle SQL tuning techniques—from ordering tables and rewriting WHERE clauses to using indexes, avoiding SELECT *, leveraging DECODE, replacing HAVING with WHERE, and preferring TRUNCATE over DELETE—each illustrated with clear examples to help developers write faster, more efficient queries.

OracleQuery WritingSQL optimization
0 likes · 23 min read
Top 38 Oracle SQL Performance Tips for Faster Queries
ITPUB
ITPUB
Jun 4, 2017 · Databases

Why Oracle Performs Crash Recovery Before Rollback: Understanding Instance Recovery

This article explains Oracle instance recovery, detailing when it is needed, how checkpoints and SCNs are recorded during clean and abnormal shutdowns, and the step‑by‑step forward‑roll and rollback process performed by SMON to restore database consistency after a crash.

Crash RecoveryInstance RecoveryOracle
0 likes · 8 min read
Why Oracle Performs Crash Recovery Before Rollback: Understanding Instance Recovery
ITPUB
ITPUB
Jun 1, 2017 · Databases

Understanding MySQL InnoDB Deadlocks: Concepts, Examples, and Log Analysis

This article explains MySQL InnoDB deadlocks, describes how the engine detects and resolves them by rolling back a transaction with error 1213, and walks through real‑world examples and log analyses to illustrate the causes and troubleshooting steps.

Error 1213InnoDBMySQL
0 likes · 5 min read
Understanding MySQL InnoDB Deadlocks: Concepts, Examples, and Log Analysis
ITPUB
ITPUB
May 23, 2017 · Databases

How to Migrate a Windows Oracle RAC to Linux Using DataGuard: Step‑by‑Step Guide

This guide details the step‑by‑step process of moving a Windows‑based Oracle 11g RAC cluster to a Linux environment, focusing on building DataGuard between a single‑instance source and a RAC target, adjusting IPs, updating parameter files, handling tnsnames.ora, password files, RMAN backups, and finalizing the standby configuration.

DataGuardOracleRAC
0 likes · 6 min read
How to Migrate a Windows Oracle RAC to Linux Using DataGuard: Step‑by‑Step Guide
Architecture Digest
Architecture Digest
May 22, 2017 · Databases

Building a High‑Availability Redis System with Sentinel and VIP

This guide demonstrates how to configure a highly available Redis deployment using master‑slave replication, Redis Sentinel for automatic failover, and virtual IP (VIP) migration, covering environment setup, configuration files, firewall adjustments, testing procedures, and client connection strategies.

RedisSentineldatabase
0 likes · 11 min read
Building a High‑Availability Redis System with Sentinel and VIP
ITPUB
ITPUB
May 19, 2017 · Databases

Optimizing Redis Master‑Slave Performance in Cloud Environments

This article examines common performance and reliability problems encountered in Redis master‑slave deployments—such as AOF and SAVE settings, key count mismatches, client output buffer limits, replication backlog size, and node liveness checks—and provides concrete configuration commands and tuning strategies to improve stability, especially in cloud environments.

ConfigurationMaster‑SlaveRedis
0 likes · 7 min read
Optimizing Redis Master‑Slave Performance in Cloud Environments
Qunar Tech Salon
Qunar Tech Salon
May 18, 2017 · Databases

Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans

This article explains how Oracle's bind variable peeking influences execution plan selection, demonstrates the performance differences between full table scans and index scans with skewed data distributions, and provides practical methods—including 10046 events, v$sql_bind_capture, and AWR views—to capture and analyze bind variable values for better SQL tuning.

AWRBind VariablesOracle
0 likes · 14 min read
Understanding Bind Variable Peeking and Its Impact on Oracle Execution Plans
ITPUB
ITPUB
May 17, 2017 · Databases

Build a Simple NoSQL Key‑Value Database in Python from Scratch

This article explains what NoSQL means, compares it with traditional SQL databases, and walks through creating a lightweight Python key‑value store with TCP/IP commands, illustrating schema design, indexing, query examples, and the full source code for a toy NoSQL system.

NoSQLSQLTutorial
0 likes · 18 min read
Build a Simple NoSQL Key‑Value Database in Python from Scratch
Alibaba Cloud Developer
Alibaba Cloud Developer
May 17, 2017 · Databases

How Alibaba Tackles the Massive Challenges of Time‑Series Data Storage

This article details Alibaba's middleware team's exploration of time‑series data characteristics, real‑world monitoring scenarios, the limitations of traditional databases, and the evolution of their custom HiTSDB solution that combines inverted indexing, high‑compression algorithms, and distributed aggregation to meet massive write and query demands.

AlibabaHiTSDBStorage
0 likes · 25 min read
How Alibaba Tackles the Massive Challenges of Time‑Series Data Storage
Qunar Tech Salon
Qunar Tech Salon
May 12, 2017 · Databases

High Availability Solutions for MySQL and UDB: Techniques and Case Study

The article explains high‑availability concepts, compares typical MySQL HA architectures—including replication, clustering, and Paxos‑based solutions—and presents UDB’s dual‑master semi‑synchronous design with a Proxy layer that ensures automatic failover, data consistency, and operational resilience.

MySQLProxyReplication
0 likes · 12 min read
High Availability Solutions for MySQL and UDB: Techniques and Case Study
Efficient Ops
Efficient Ops
May 4, 2017 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article examines common MySQL performance pitfalls such as inefficient LIMIT usage, implicit type conversion, subquery‑driven updates, mixed ordering, EXISTS clauses, condition push‑down, early result narrowing, and intermediate result push‑down, and provides rewritten SQL examples that dramatically reduce execution time from seconds to milliseconds.

MySQLSQL optimizationdatabase
0 likes · 12 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
ITPUB
ITPUB
May 2, 2017 · Databases

Understanding Oracle Lock Mechanisms: DML, DDL, and Row‑Level Locks Explained

This article explains how Oracle uses various lock types—including DML, DDL, and internal locks—to protect shared resources, details the lock manager workflow, describes the three lock components and lock modes, and shows practical SQL examples of transaction handling and blocking detection.

LocksOracleSQL
0 likes · 13 min read
Understanding Oracle Lock Mechanisms: DML, DDL, and Row‑Level Locks Explained
Meituan Technology Team
Meituan Technology Team
Apr 21, 2017 · Operations

Meituan-Dianping DevOps Automation Practices and Philosophy

The Meituan‑Dianping technical salon showcases its DevOps automation philosophy by presenting three core tools—DB automation platform, service tree, and Puppet web management—while also featuring Shanghai Zhaogang Network’s CMDB experience, illustrating how rapid O2O growth drives the need for fast, reliable, and scalable operational automation.

CMDBDevOpsMeituan-Dianping
0 likes · 5 min read
Meituan-Dianping DevOps Automation Practices and Philosophy
Baidu Waimai Technology Team
Baidu Waimai Technology Team
Apr 20, 2017 · Databases

Greenplum (GPDB) Architecture, Features, and Operational Tools Overview

This article explains Greenplum's MPP architecture, master‑segment design, high‑availability, interconnect network, rich management tools, parallel query planning, data loading techniques, and additional capabilities such as LDAP authentication and resource queues, demonstrating why it is a strong next‑generation big‑data query engine.

GreenplumMPPOperations
0 likes · 15 min read
Greenplum (GPDB) Architecture, Features, and Operational Tools Overview
ITPUB
ITPUB
Apr 17, 2017 · Databases

How to Build a Multi‑Master to Single‑Slave MySQL 5.7 Replication Setup

This guide walks through preparing three CentOS 6.7 machines, installing MySQL 5.7.17, configuring my.cnf, disabling firewalls and SELinux, creating replication users, exporting databases, setting up multi‑source replication with GTID, and verifying data consistency across two masters and one slave.

CentOSGTIDMySQL
0 likes · 10 min read
How to Build a Multi‑Master to Single‑Slave MySQL 5.7 Replication Setup
MaGe Linux Operations
MaGe Linux Operations
Apr 17, 2017 · Operations

Essential Linux & Server Commands: From Log Cleanup to RAID and Monitoring

This guide presents practical Linux and server administration commands, covering log cleanup, nginx IP analysis, tcpdump capture, Python date formatting and string reversal, subprocess execution, multiprocessing, iptables port forwarding, cron scheduling, file relocation, RAID concepts, Oracle backup strategies, port checking, Apache MPM modes, and monitoring tool comparisons.

LinuxNetworkingRAID
0 likes · 10 min read
Essential Linux & Server Commands: From Log Cleanup to RAID and Monitoring
dbaplus Community
dbaplus Community
Apr 13, 2017 · Backend Development

Scalable Small .NET E‑Commerce Architecture: Monitoring, DB Master‑Slave & Capacity Planning

This guide walks through the evolution of a small .NET‑based e‑commerce system, covering its initial LAMP‑style setup, detailed backend architecture, logging and monitoring solutions, master‑slave database design, shared‑storage image server, mobile M‑site construction, capacity estimation methods, and caching strategies.

.NETArchitecturecapacity planning
0 likes · 22 min read
Scalable Small .NET E‑Commerce Architecture: Monitoring, DB Master‑Slave & Capacity Planning
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Apr 7, 2017 · Backend Development

Ensuring Idempotency in High‑Concurrency Systems: Strategies and Best Practices

To prevent duplicate operations such as repeated inserts, updates, or message sends in high‑traffic applications, this article explains the concept of idempotency and outlines practical techniques—including read‑only APIs, MVCC with optimistic locking, deduplication tables, distributed locks, safe deletes, unique indexes, UUID‑based request tracking, and state‑machine safeguards.

Backenddatabasedistributed lock
0 likes · 5 min read
Ensuring Idempotency in High‑Concurrency Systems: Strategies and Best Practices
Qunar Tech Salon
Qunar Tech Salon
Apr 6, 2017 · Databases

Understanding Timestamp and exec_time in MySQL Binlog Events

This article explains how MySQL binlog timestamps are derived from the THD start_time, why all events in a transaction share the same timestamp, how exec_time is calculated, and demonstrates the effect of autocommit and manual commit on binlog timing through concrete examples and source code analysis.

BinlogGTIDMySQL
0 likes · 10 min read
Understanding Timestamp and exec_time in MySQL Binlog Events
High Availability Architecture
High Availability Architecture
Mar 22, 2017 · Databases

RocksDB Basics: Architecture, Features, and Performance

This article provides a comprehensive overview of RocksDB, covering its origin, design goals, core architecture components, key features such as APIs, compression strategies, durability mechanisms, backup and replication support, as well as tooling, testing, and performance characteristics.

CompressionRocksDBdatabase
0 likes · 17 min read
RocksDB Basics: Architecture, Features, and Performance
Hujiang Technology
Hujiang Technology
Mar 20, 2017 · Databases

Cross‑Platform SQLite Development with Free Pascal and CodeTyphon

This tutorial demonstrates how to build a single, reusable SQLite library in Free Pascal using CodeTyphon, covering platform‑specific APIs, export conventions for Android, iOS, PC, and detailed compilation and usage examples across Android, iOS, macOS, Linux, and Windows.

AndroidCodeTyphonFree Pascal
0 likes · 9 min read
Cross‑Platform SQLite Development with Free Pascal and CodeTyphon
ITPUB
ITPUB
Mar 17, 2017 · Databases

Master SQL Query Execution Order and Performance Optimization Tips

This article explains the logical and physical execution order of SQL statements, offers practical tips for returning only needed data, reducing redundant work, using temporary tables wisely, optimizing subqueries and indexes, and provides concrete code examples to improve query performance.

PerformanceQuery OptimizationSQL
0 likes · 15 min read
Master SQL Query Execution Order and Performance Optimization Tips
ITPUB
ITPUB
Mar 17, 2017 · Databases

Why Oracle 12c TNS Listener Returns ORA-12514 and How to Fix It

The article recounts a troubleshooting session where a 12c Oracle standby database failed to connect via TNS, presenting the ORA-12514 error, analyzing listener and tnsnames configurations, uncovering an outdated 11g ORACLE_HOME, and detailing the steps to switch homes and restart the listener to resolve the issue.

12cORA-12514Oracle
0 likes · 5 min read
Why Oracle 12c TNS Listener Returns ORA-12514 and How to Fix It
Java Backend Technology
Java Backend Technology
Mar 13, 2017 · Databases

Mastering Redis Persistence: RDB Snapshots and AOF Explained

This article explains why Redis data must be persisted, compares the two built‑in methods—RDB snapshotting and Append‑Only File (AOF)—and provides practical configuration tips, command usage, performance considerations, and verification tools for reliable backup and recovery.

AOFPersistenceRDB
0 likes · 11 min read
Mastering Redis Persistence: RDB Snapshots and AOF Explained
Tencent Cloud Developer
Tencent Cloud Developer
Mar 9, 2017 · Databases

Benchmarking TokuDB vs InnoDB: Insertion Throughput and Compression Ratio

The benchmark shows that while InnoDB delivers roughly 30 % higher insert throughput than TokuDB, the TokuDB engine achieves 10‑16× storage compression with comparable import times, minimal impact from log‑sync settings, and zlib emerging as the preferred compression algorithm for balanced performance and CPU usage.

CompressionInnoDBMySQL
0 likes · 18 min read
Benchmarking TokuDB vs InnoDB: Insertion Throughput and Compression Ratio
ITPUB
ITPUB
Mar 5, 2017 · Databases

Database Transactions Demystified: ACID, Isolation Levels & Spring Propagation

This article explains the fundamental ACID properties of database transactions, details the four isolation levels—READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLE—illustrates common concurrency issues like dirty, non‑repeatable, and phantom reads with examples, and shows how Spring’s transaction propagation and additional features can be leveraged to manage them effectively.

ACIDIsolation LevelSpring
0 likes · 12 min read
Database Transactions Demystified: ACID, Isolation Levels & Spring Propagation
21CTO
21CTO
Feb 26, 2017 · Operations

How YouTube Handles 500M Daily Video Plays: Inside Its Scalable Architecture

This article dissects YouTube's massive infrastructure, detailing the basic platform, web and video services, thumbnail handling, database evolution, CDN usage, and data‑center strategies that enable over half a billion daily video clicks with a surprisingly small engineering team.

CDNYouTubedatabase
0 likes · 12 min read
How YouTube Handles 500M Daily Video Plays: Inside Its Scalable Architecture
ITPUB
ITPUB
Feb 24, 2017 · Databases

Why Adding NOT NULL Columns Can Still Store NULLs in Oracle?

This article examines the surprising behavior of Oracle when adding NOT NULL columns with default NULL values, explains how different Oracle versions handle the constraint, demonstrates test cases, and clarifies the underlying data‑dictionary mechanism that leads to unexpected query results.

ALTER TABLENOT NULLOracle
0 likes · 7 min read
Why Adding NOT NULL Columns Can Still Store NULLs in Oracle?
ITPUB
ITPUB
Feb 23, 2017 · Databases

Mastering SQL Joins: From CROSS to LATERAL and Beyond

This comprehensive guide explains every major SQL join type—including CROSS, INNER, OUTER, FULL, SEMI, ANTI, LATERAL, and MULTISET—detailing their logical behavior, practical use‑cases, alternative syntaxes, performance implications, and visual examples across PostgreSQL, Oracle, and SQL Server.

JOINOraclePerformance
0 likes · 22 min read
Mastering SQL Joins: From CROSS to LATERAL and Beyond
ITPUB
ITPUB
Feb 22, 2017 · Databases

Unraveling a Mysterious MySQL Deadlock: Step‑by‑Step Log Analysis

This article walks through a puzzling MySQL InnoDB deadlock case, showing the table schema, the conflicting transactions, how to read the SHOW ENGINE INNODB STATUS output, and the reasoning that reveals why the deadlock occurs and how to diagnose similar issues.

InnoDBMySQLSQL
0 likes · 12 min read
Unraveling a Mysterious MySQL Deadlock: Step‑by‑Step Log Analysis
Tencent Cloud Developer
Tencent Cloud Developer
Feb 22, 2017 · Databases

Building a SQL Server Failover Cluster on QCloud – Final Guide

This guide walks through building a SQL Server Failover Cluster on QCloud, covering architecture choices, network layout, required roles like DTC, step‑by‑step installation on two nodes, configuration of virtual IPs, and recommendations to prefer AlwaysOn or PaaS solutions for production reliability.

AlwaysOnFailover ClusterQCloud
0 likes · 9 min read
Building a SQL Server Failover Cluster on QCloud – Final Guide
ITPUB
ITPUB
Feb 21, 2017 · Databases

How to Quickly Detect and Fix Common SQL Errors in PHP

This guide explains why production SQL errors appear despite successful local tests, shows how to proactively log and monitor PHP‑MySQL errors, and provides concrete solutions for frequent MySQL error codes with example code and step‑by‑step troubleshooting tips.

Error LoggingMySQLPHP
0 likes · 10 min read
How to Quickly Detect and Fix Common SQL Errors in PHP
MaGe Linux Operations
MaGe Linux Operations
Feb 17, 2017 · Backend Development

Mastering ORM with SQLAlchemy: A Hands‑On Python Database Guide

Learn the fundamentals of Object‑Relational Mapping (ORM) and how to use Python’s SQLAlchemy library to define models, initialize sessions, create tables, and perform CRUD operations, with clear examples and code snippets that illustrate switching databases and advanced query techniques.

Backend DevelopmentORMPython
0 likes · 5 min read
Mastering ORM with SQLAlchemy: A Hands‑On Python Database Guide
Tencent Cloud Developer
Tencent Cloud Developer
Feb 16, 2017 · Databases

Building a SQL Cluster on Tencent Cloud (QCloud) – Step‑by‑Step Guide

In this step‑by‑step guide, Microsoft MVP Li Sida shows how to build a two‑node SQL Server cluster on Tencent Cloud by creating a private VPC, setting up an Active Directory domain controller, configuring shared storage, joining the SQL nodes, and addressing common Chinese‑cloud quirks such as sysprep and SID duplication.

Active DirectoryCloud InfrastructureSQL Cluster
0 likes · 7 min read
Building a SQL Cluster on Tencent Cloud (QCloud) – Step‑by‑Step Guide
dbaplus Community
dbaplus Community
Feb 12, 2017 · Databases

Can Open‑Source Databases Handle Millions of Queries per Second? PostgreSQL vs MySQL Benchmarks

This article presents a detailed benchmark comparing PostgreSQL 9.6 and MySQL 5.7 on identical high‑end hardware using pgbench and SysBench, describing the test methodology, configuration tweaks, performance results for point selects and OLTP workloads, and concluding that both systems scale to modern demanding workloads.

MySQLPostgreSQLbenchmark
0 likes · 11 min read
Can Open‑Source Databases Handle Millions of Queries per Second? PostgreSQL vs MySQL Benchmarks
Java High-Performance Architecture
Java High-Performance Architecture
Feb 7, 2017 · Databases

New MySQL Features: Data Dictionary, InnoDB, JSON, and Optimizer Boosts

The latest MySQL release introduces a transactional data dictionary, role‑based account permission management, multiple InnoDB enhancements—including stable auto‑increment counters, memcached multi‑key support, dynamic deadlock detection, shared temporary tables, and NOWAIT/SKIP LOCKED options—plus advanced JSON operators, aggregation functions, pretty‑print utility, and optimizer features such as hidden and descending indexes.

InnoDBJSONMySQL
0 likes · 4 min read
New MySQL Features: Data Dictionary, InnoDB, JSON, and Optimizer Boosts
Architects' Tech Alliance
Architects' Tech Alliance
Feb 7, 2017 · Backend Development

Technical Overview of WeChat Red Packet Distribution System

The article analyzes the massive scale of Chinese New Year red‑packet activity on WeChat, presents usage statistics, and explains the backend architecture—including distributed KV storage, cache‑layer atomic operations, and database transaction handling—that enables high‑throughput red‑packet distribution.

WeChatbackend architecturecache
0 likes · 5 min read
Technical Overview of WeChat Red Packet Distribution System
Alibaba Cloud Developer
Alibaba Cloud Developer
Jan 22, 2017 · Backend Development

How Alibaba Scaled Double 11: Backend Strategies for Billions of Transactions

Alibaba's Double 11 festival broke sales records with 120.7 billion RMB, and the article details the backend engineering challenges and solutions—such as database sharding, SQL optimization, multi‑level caching, and modular architecture—that enabled the platform to handle millions of orders per second while preserving data consistency and performance.

Backendcachingdatabase
0 likes · 20 min read
How Alibaba Scaled Double 11: Backend Strategies for Billions of Transactions
MaGe Linux Operations
MaGe Linux Operations
Jan 18, 2017 · Databases

What Does China’s 2016 Oracle Database Landscape Reveal?

The 2016 China Oracle Database Usage Report, based on health‑check data from 1,841 instances across 18 industries, provides a multi‑dimensional analysis of version distribution, operating system choices, host and storage configurations, data scale, high‑availability setups, and top failure types, offering a comprehensive view of Oracle adoption and challenges in the Chinese market.

ChinaOraclePerformance
0 likes · 10 min read
What Does China’s 2016 Oracle Database Landscape Reveal?
dbaplus Community
dbaplus Community
Jan 12, 2017 · Databases

Mastering MySQL Group Replication: Full‑Sync Architecture, Benefits, and Step‑by‑Step Setup

This article explains MySQL's asynchronous, semi‑synchronous, and Group Replication mechanisms, compares their trade‑offs, details Group Replication’s certification‑based full‑sync workflow, lists its features and limitations, and provides a complete configuration and maintenance guide for a three‑node cluster.

ClusterConfigurationGroup Replication
0 likes · 13 min read
Mastering MySQL Group Replication: Full‑Sync Architecture, Benefits, and Step‑by‑Step Setup
ITPUB
ITPUB
Jan 10, 2017 · Databases

5 Practical SQL Query Tricks to Boost Database Readability and Performance

This article presents five useful Oracle SQL techniques—including string concatenation, DISTINCT, WHERE clauses, flexible COUNT usage, and selecting only necessary columns—to improve query readability, eliminate duplicate rows, and enhance overall database performance.

OracleQuery OptimizationSQL
0 likes · 9 min read
5 Practical SQL Query Tricks to Boost Database Readability and Performance
dbaplus Community
dbaplus Community
Jan 4, 2017 · Databases

Unveiling InnoDB’s Transaction Struct: 63 Variables Explained

This article dissects the InnoDB transaction structure defined in storage/innobase/include/trx0trx.h, detailing each of the 63 variables—including their types, purpose, and interaction with MySQL’s transaction coordinator—so readers can grasp how InnoDB ensures data consistency and manages transaction state.

InnoDBMySQLdatabase
0 likes · 21 min read
Unveiling InnoDB’s Transaction Struct: 63 Variables Explained
Tencent Cloud Developer
Tencent Cloud Developer
Dec 26, 2016 · Databases

Analysis of Redis Design: Network Model, Data Structures, Memory Management, Persistence, and Clustering

The article dissects Redis’s architecture by examining its single‑threaded reactor network model, core data structures and memory‑management tactics, AOF/RDB persistence mechanisms, and master‑slave, Sentinel, and Cluster multi‑node strategies, highlighting how each design choice balances speed, memory usage, and system complexity.

ClusteringPersistenceRedis
0 likes · 16 min read
Analysis of Redis Design: Network Model, Data Structures, Memory Management, Persistence, and Clustering
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.

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

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

RedisUpdate Strategycache
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 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