BestHub
Sign in
Tagged articles

Database

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

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

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

DatabaseFailoverHigh Availability
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.

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

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

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

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

Redis 5.0 New Features and Migration Considerations

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

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

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

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

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

How to Monitor SQL Server Backup and Restore Progress Effectively

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

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

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

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

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

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

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

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

Why Do Database Failures Happen and How to Prevent Them?

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

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

MySQL Index Optimization and Performance Analysis

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

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

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

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

How to Set Up MySQL Master‑Slave Replication with Docker

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

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

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

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

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

Understanding Consistent Reads and MVCC in MySQL InnoDB

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

Consistent ReadDatabaseInnoDB
0 likes · 14 min read
Understanding Consistent Reads and MVCC in MySQL InnoDB
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 5, 2018 · Databases

How to Build a MySQL Master‑Slave Cluster: Step‑by‑Step Guide

This article walks readers through setting up MySQL replication, from the basic master‑slave model to a one‑master‑multiple‑slave cluster, covering configuration files, essential parameters, verification commands, performance tips, and common pitfalls for production deployments.

ClusterDatabaseHigh Availability
0 likes · 15 min read
How to Build a MySQL Master‑Slave Cluster: Step‑by‑Step Guide
Architecture Digest
Architecture Digest
Apr 28, 2018 · Databases

HBase Architecture Components and Operational Overview

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

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

How Stack Overflow Achieves Lightning‑Fast Pagination

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

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

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

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

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

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

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

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

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

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

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

DatabaseFPGAHardware Acceleration
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.

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

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

Ultimate Java Interview Guide: 100+ Essential Questions & Answers

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

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

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

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

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

How to Set Up a Redis Cluster on macOS

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

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

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

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

DatabaseHAHigh Availability
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.

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

Designing Robust Oracle Backup and Recovery Strategies for Large Databases

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

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

Why NewSQL Matters: From Relational Roots to Modern HTAP

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

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

Integrating Spring Security with MyBatis for Database‑Based Login

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

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

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

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

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

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

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

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

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

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

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

CMDBDatabaseOperations
0 likes · 34 min read
Designing Scalable System Architecture: From Access Chains to Cloud‑Native Infrastructure
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.

DatabaseInnoDBMySQL
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 ComputingDatabase
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.

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

Data TypesDatabaseKey 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.

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

DatabasePlanner HookPostgreSQL
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.

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

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

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

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

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

DatabaseDockerMaster‑Slave
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.

DatabaseJavaconcurrency
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 IndexDatabaseMySQL
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+ treeDatabaseIndex
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.

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

Data RecoveryDatabaseFlashback
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.

DatabaseMySQLbackup
0 likes · 8 min read
Qunar Database High Availability and Backup Recovery Architecture
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.

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

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

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

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

CronDatabaseMySQL
0 likes · 8 min read
Automate MySQL Database Backups with Bash and Cron
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.

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

DatabaseJPAJava
0 likes · 9 min read
How to Build a High‑Concurrency Flash‑Sale (SecKill) System in Java