BestHub
Sign in
Tagged articles
722 articles
Page 8 of 8
21CTO
21CTO
Nov 28, 2015 · Databases

Why MySQL Key Partition Queries Fail After Upgrade and How to Fix Them

This article examines several MySQL issues—including key partition hash algorithm changes causing data loss after upgrades, a client crash triggered by misdirected dump output, GTID_PURGED interactions that break AUTO_POSITION replication, and replicate‑do‑db filtering effects on GTID continuity—and provides concrete compatibility fixes and troubleshooting steps.

Database UpgradeGTIDReplication
0 likes · 18 min read
Why MySQL Key Partition Queries Fail After Upgrade and How to Fix Them
Architect
Architect
Oct 31, 2015 · Databases

MySQL High‑Performance Architecture and Optimization Techniques

This article provides a comprehensive guide to MySQL performance optimization, covering isolation levels, MVCC, schema design, index strategies, query execution, partitioning, replication, scaling, hardware considerations, and backup/recovery techniques for building high‑performance, reliable database systems.

BackupIsolation LevelsReplication
0 likes · 22 min read
MySQL High‑Performance Architecture and Optimization Techniques
21CTO
21CTO
Oct 20, 2015 · Databases

Deep Dive into MySQL Partitioning, GTID Bugs, and TokuDB Optimize Table Anomalies

This article examines why MySQL 5.5/5.6 fails to retrieve non‑null partitioned rows after a physical upgrade, how the ALTER TABLE … PARTITION BY KEY ALGORITHM=1 fix works, the cause of MySQL client crashes when dump output mixes warnings, GTID_PURGED replication bugs, replicate‑filter side effects, and the behavior of TokuDB’s OPTIMIZE TABLE.

GTIDPartitioningReplication
0 likes · 19 min read
Deep Dive into MySQL Partitioning, GTID Bugs, and TokuDB Optimize Table Anomalies
21CTO
21CTO
Oct 13, 2015 · Databases

How Group Commit, DDL Fast Fail, and GTID Optimizations Boost MySQL Performance

This article explains MySQL's evolution from serialized binlog writes to group commit, introduces DDL fast‑fail and GTID allocation improvements, analyzes InnoDB auto‑increment duplication after restart, and details replication performance gains from multi‑threaded and seqno‑based parallel execution, providing code examples and benchmark results.

DDL Fast FailGTIDGroup Commit
0 likes · 22 min read
How Group Commit, DDL Fast Fail, and GTID Optimizations Boost MySQL Performance
21CTO
21CTO
Oct 12, 2015 · Databases

How NoSQL Databases Achieve Scalability: Distributed Strategies Explained

This article systematically explores the distributed characteristics of NoSQL databases, covering data consistency, placement, peer systems, anti‑entropy protocols, eventual consistency data types, sharding, fault detection, and coordinator election, illustrating how these strategies balance scalability, availability, latency, and fault tolerance.

NoSQLReplicationfault tolerance
0 likes · 33 min read
How NoSQL Databases Achieve Scalability: Distributed Strategies Explained
21CTO
21CTO
Oct 9, 2015 · Databases

Mastering MySQL Migration: Practical Scenarios and Step-by-Step Guides

This article explains why MySQL migrations are essential, outlines backup and restore strategies, and provides detailed, step‑by‑step procedures for multiple real‑world scenarios—including single‑master/slave moves, cross‑datacenter transfers, and multi‑instance setups—while highlighting key precautions and practical tips for successful execution.

Backup and RestoreReplicationdatabase migration
0 likes · 25 min read
Mastering MySQL Migration: Practical Scenarios and Step-by-Step Guides
21CTO
21CTO
Oct 4, 2015 · Databases

Mastering MySQL Migration: Practical Scenarios and Step‑by‑Step Guide

This article explains why MySQL migration is essential, outlines various migration strategies—including full, partial, and cross‑datacenter moves—and provides detailed, step‑by‑step procedures, best‑practice tips, and precautionary measures to ensure a smooth, reliable transition.

BackupCross-DataCenterReplication
0 likes · 21 min read
Mastering MySQL Migration: Practical Scenarios and Step‑by‑Step Guide
Architect
Architect
Sep 14, 2015 · Databases

MySQL High Availability Solutions: Selection Guide

This article reviews various MySQL high‑availability architectures—including master‑slave replication with keepalived or MHA, Galera‑based clusters, and other approaches—detailing their deployment methods, advantages, limitations, and practical considerations for selecting an appropriate HA solution.

GaleraMHAReplication
0 likes · 9 min read
MySQL High Availability Solutions: Selection Guide
Architects' Tech Alliance
Architects' Tech Alliance
Sep 7, 2015 · Operations

Managed Data Remote Replication with DD Boost and NetWorker

DD Boost allows backup applications to manage and simplify file replication between multiple Data Domain systems, and using NetWorker as an example, the article details the step‑by‑step replication workflow, optional low‑bandwidth and encryption features, and how remote restores are performed.

DDBoostDataDomainLowBandwidth
0 likes · 4 min read
Managed Data Remote Replication with DD Boost and NetWorker
Architect
Architect
Aug 31, 2015 · Databases

MySQL High Availability: Replication, Monitoring, and Failover Strategies

This article discusses MySQL high‑availability solutions, covering asynchronous and semi‑synchronous replication, monitoring with keepalived, Zookeeper, and custom agents, failover procedures using binlog positions, GTID and pseudo‑GTID techniques, and the author's practical experiences and future plans.

GTIDReplicationdatabase
0 likes · 17 min read
MySQL High Availability: Replication, Monitoring, and Failover Strategies
21CTO
21CTO
Aug 24, 2015 · Databases

Mastering Distributed Consistency: Strategies Behind NoSQL Replication

This article systematically explores the distributed characteristics of NoSQL databases, covering consistency trade‑offs, replication techniques, anti‑entropy protocols, data placement strategies, failure detection, and coordinator election, while illustrating each concept with diagrams and practical examples.

Anti-entropyConsistencyDistributed Systems
0 likes · 32 min read
Mastering Distributed Consistency: Strategies Behind NoSQL Replication
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Aug 5, 2015 · Databases

Challenges and Strategies for Metadata Protection in Cloud Object Storage

This article examines the problems and trade‑offs of metadata protection in cloud object storage, highlighting the importance of reliability, availability, and consistency, and comparing primary‑secondary and multi‑replica models, including the WRN algorithm and practical operational considerations.

ConsistencyDistributed SystemsOperations
0 likes · 28 min read
Challenges and Strategies for Metadata Protection in Cloud Object Storage
Efficient Ops
Efficient Ops
Jul 24, 2015 · Databases

What MySQL 5.7 InnoDB Experts Reveal: Key Q&A on New Features

An expert panel from the High‑Efficiency Operations community answers eleven pressing MySQL 5.7 questions, covering test hardware, GA timeline, GIS speed, virtual column indexing, materialized view plans, 2‑D geo support, performance monitoring, Oracle’s market strategy, geojson handling, multi‑source replication, buffer‑pool locking, and InnoDB Memcached consistency.

Database PerformanceGISInnoDB
0 likes · 7 min read
What MySQL 5.7 InnoDB Experts Reveal: Key Q&A on New Features
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Jul 5, 2015 · Databases

Design and Implementation of TDSQL: A Distributed High‑Consistency MySQL‑Based Storage System

The article describes the evolution, architecture, automatic scaling, sharding, disaster‑recovery mechanisms, and strong synchronous replication strategy of TDSQL, a MySQL‑engine based distributed database built to meet the high‑availability and high‑consistency requirements of Tencent's billing platform.

ReplicationTDSQLdistributed database
0 likes · 18 min read
Design and Implementation of TDSQL: A Distributed High‑Consistency MySQL‑Based Storage System
Qunar Tech Salon
Qunar Tech Salon
Apr 20, 2015 · Databases

Practical MySQL Scaling and Sharding Strategies at 58.com under Big Data Loads

This article presents 58.com’s experience with MySQL under massive data volumes, covering core concepts such as single‑instance, sharding, replication and grouping, common availability and read‑write challenges, detailed sharding implementations for user, post, friend and order tables, and post‑sharding business practices including IN queries, non‑partition key queries, and cross‑database pagination.

Cross‑Shard QueriesPartitioningReplication
0 likes · 10 min read
Practical MySQL Scaling and Sharding Strategies at 58.com under Big Data Loads
MaGe Linux Operations
MaGe Linux Operations
Apr 17, 2015 · Databases

Why MySQL Slaves Lag Behind Masters and How to Speed Up Replication

This article explains the fundamental reasons why MySQL slave servers experience higher latency than masters and provides practical optimization techniques—including parallel replication, proper indexing, I/O improvements, and hardware choices—to reduce replication lag.

Database OptimizationReplicationSlave Lag
0 likes · 6 min read
Why MySQL Slaves Lag Behind Masters and How to Speed Up Replication
MaGe Linux Operations
MaGe Linux Operations
Mar 31, 2015 · Databases

Why MySQL Replication Shows Zero Lag Yet Fails to Sync Changes

This article explains a rare MySQL replication scenario where Seconds_Behind_Master stays at zero while the slave cannot receive updates, analyzes the underlying push‑based replication mechanism, and offers practical steps and configuration tweaks to detect and prevent the issue.

Master‑SlaveReplicationSeconds_Behind_Master
0 likes · 8 min read
Why MySQL Replication Shows Zero Lag Yet Fails to Sync Changes
Qunar Tech Salon
Qunar Tech Salon
Jan 18, 2015 · Databases

MySQL Performance Optimizations and Feature Improvements: Group Commit, DDL Fast Fail, GTID, Auto‑Increment Persistence, Replication, and Key Partitioning

This article presents a comprehensive technical overview of MySQL performance tuning and feature enhancements—including group‑commit redesign, DDL fast‑fail, GTID handling, persistent auto‑increment, replication parallelism, and key‑partition hash changes—backed by real‑world test data from Taobao's large‑scale deployment.

DDLGroup CommitInnoDB
0 likes · 27 min read
MySQL Performance Optimizations and Feature Improvements: Group Commit, DDL Fast Fail, GTID, Auto‑Increment Persistence, Replication, and Key Partitioning
MaGe Linux Operations
MaGe Linux Operations
Aug 2, 2014 · Databases

Are You Ready for MongoDB’s Hidden Limits?

This article highlights several often‑overlooked MongoDB limitations—including excessive disk‑space preallocation, a 12‑node replica‑set cap, lack of high‑availability in master‑slave mode, 32‑bit version constraints, high consulting fees, and weak management tools—helping developers avoid costly surprises.

Consulting CostsDatabase LimitsMongoDB
0 likes · 5 min read
Are You Ready for MongoDB’s Hidden Limits?