BestHub
Sign in
Tagged articles

Database

2745 articles · Page 21 of 28
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 20, 2020 · Databases

MySQL Master‑Slave Replication: Principles, Setup Guide, and Interview Questions

This article explains MySQL master‑slave replication, covering its concepts, asynchronous replication mechanisms, various synchronization strategies, step‑by‑step installation and configuration on CentOS 7, and includes common interview questions with answers; it also provides practical commands, troubleshooting tips, and performance considerations for read‑write separation in production environments.

CentOSDatabaseMaster‑Slave
0 likes · 15 min read
MySQL Master‑Slave Replication: Principles, Setup Guide, and Interview Questions
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 19, 2020 · Databases

Understanding Oracle Character Sets, NLS_LANG Settings, and Import/Export Character Conversion

This article explains the fundamentals of Oracle character sets, how database and national character sets are defined, the role of NLS_LANG, the location and purpose of character set files, and practical guidance for import/export operations and character set conversion across different environments.

DatabaseImport ExportNLS_LANG
0 likes · 22 min read
Understanding Oracle Character Sets, NLS_LANG Settings, and Import/Export Character Conversion
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 17, 2020 · Databases

Comprehensive MySQL Tutorial: Basics, Data Types, Operators, Functions, and Queries

This article provides a thorough, step‑by‑step guide to MySQL, covering how to install and start the server, create databases and tables, use DDL/DML/DQL statements, understand numeric, date/time and string data types, apply arithmetic, comparison, logical and bitwise operators, and leverage common built‑in functions for efficient data manipulation.

Data TypesDatabaseMySQL
0 likes · 38 min read
Comprehensive MySQL Tutorial: Basics, Data Types, Operators, Functions, and Queries
Laravel Tech Community
Laravel Tech Community
Jul 16, 2020 · Databases

Comprehensive Guide to SQL Syntax, Commands, and Operations

This article provides a comprehensive overview of relational database fundamentals and SQL syntax, covering basic concepts, statement categories (DDL, DML, TCL, DCL), CRUD operations, subqueries, joins, unions, functions, ordering, grouping, constraints, transactions, permission management, stored procedures, cursors, and triggers with illustrative code examples.

DDLDMLDatabase
0 likes · 23 min read
Comprehensive Guide to SQL Syntax, Commands, and Operations
JavaEdge
JavaEdge
Jul 15, 2020 · Databases

Understanding MySQL Transaction Isolation Levels and Best Practices

This article explains MySQL transaction isolation concepts, the four standard isolation levels, their effects on dirty, non‑repeatable, and phantom reads, practical configuration steps, when to use repeatable read, how InnoDB implements isolation, and tips for avoiding long transactions and planning backups.

DatabaseInnoDBIsolation Level
0 likes · 8 min read
Understanding MySQL Transaction Isolation Levels and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 14, 2020 · Databases

Key Features of MySQL 8.0.21 Release

MySQL 8.0.21 introduces numerous enhancements such as dynamic redo log control, optional tablespace path validation, refined lock system, JSON_VALUE function, atomic CREATE TABLE…AS SELECT, optimizer improvements, reduced group replication cache, multi‑address X Plugin support, and various security and deprecation updates.

DatabaseGroupReplicationInnoDB
0 likes · 12 min read
Key Features of MySQL 8.0.21 Release
Qunar Tech Salon
Qunar Tech Salon
Jul 14, 2020 · Backend Development

Distributed Lock Mechanisms and Their Redis Implementations

This article explains the concept of distributed locks, compares various implementation approaches such as Memcached, Zookeeper, Chubby, and Redis, and details single‑node and multi‑node Redis lock designs—including SETNX, SET with NX/EX options, Redisson, and the Redlock algorithm—while highlighting their advantages, pitfalls, and best‑practice recommendations.

DatabaseRedisRedlock
0 likes · 14 min read
Distributed Lock Mechanisms and Their Redis Implementations
dbaplus Community
dbaplus Community
Jul 12, 2020 · Databases

Automating Oracle SQL Review with SOAR: A Step‑by‑Step Guide

To streamline Oracle SQL script reviews, this guide shows how to adapt the open‑source SOAR tool—originally built for MySQL—by defining custom rules, installing Go and Git, compiling the source, and integrating a web UI, enabling automated, 90% coverage of Oracle SQL checks.

DatabaseDevOpsOracle
0 likes · 8 min read
Automating Oracle SQL Review with SOAR: A Step‑by‑Step Guide
Tencent Cloud Developer
Tencent Cloud Developer
Jul 10, 2020 · Industry Insights

What Experts Really Think About Tencent Cloud’s Database Suite?

The article reports on Tencent Cloud’s TVP “complaint conference,” summarizing industry experts’ praise and criticism of its cloud database products, market trend data from Gartner, and the company’s roadmap for open‑source, security, and SaaS enhancements.

Cloud ComputingDatabaseTencent Cloud
0 likes · 12 min read
What Experts Really Think About Tencent Cloud’s Database Suite?
Programmer DD
Programmer DD
Jul 10, 2020 · Backend Development

Mastering Spring Boot Transactions: From Basics to Advanced Settings

This article explains what database transactions are, demonstrates how to use Spring Boot’s @Transactional annotation with unit tests, and dives into transaction isolation levels and propagation behaviors, providing code examples and guidance for effective transaction management in Java backend applications.

DatabaseIsolation LevelJava
0 likes · 13 min read
Mastering Spring Boot Transactions: From Basics to Advanced Settings
Selected Java Interview Questions
Selected Java Interview Questions
Jul 9, 2020 · Databases

Implementing MySQL Read/Write Splitting with Spring Boot, MyBatis, and MyCat Middleware

This tutorial explains two approaches to achieve MySQL read/write splitting—first by manually implementing routing logic in Spring Boot with MyBatis interceptors and dynamic data sources, and second by configuring the MyCat middleware for automatic load balancing, fault‑tolerance, and multi‑node support, complete with code samples and configuration files.

DatabaseMyBatisMySQL
0 likes · 26 min read
Implementing MySQL Read/Write Splitting with Spring Boot, MyBatis, and MyCat Middleware
dbaplus Community
dbaplus Community
Jul 8, 2020 · Databases

Why MySQL Uses B+ Trees: A Step‑by‑Step Dive into Index Data Structures

This article walks through the evolution of MySQL index implementations—from hash tables and binary search trees to AVL, red‑black, B‑trees and finally B+ trees—explaining their performance trade‑offs, disk‑I/O considerations, and how InnoDB and MyISAM store data and indexes differently.

B+ treeDataStructureDatabase
0 likes · 21 min read
Why MySQL Uses B+ Trees: A Step‑by‑Step Dive into Index Data Structures
Youzan Coder
Youzan Coder
Jul 8, 2020 · Backend Development

Druid Connection Pool Performance Optimization: Fair Lock vs Unfair Lock

The article explains how a Druid 1.1.20 connection pool was throttled to ~10k RPS by fair‑locking in recycle(), and how enabling the unfair lock (setUseUnfairLock(true)) doubled single‑machine TPS, raised CPU usage to near 100 % and boosted cluster throughput by about 70 %.

ArthasDatabaseDruid
0 likes · 7 min read
Druid Connection Pool Performance Optimization: Fair Lock vs Unfair Lock
Java Backend Technology
Java Backend Technology
Jul 7, 2020 · Databases

Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them

This article analyzes the various system‑level and database‑level reasons why SELECT, UPDATE, INSERT, or DELETE statements become slow, covering network issues, OS and hardware constraints, MySQL configuration, indexing, execution plans, and query design, and offers practical mitigation strategies.

DatabaseMySQLSQL
0 likes · 18 min read
Why Your SQL Queries Are Slow: 10 Hidden Factors and How to Fix Them
dbaplus Community
dbaplus Community
Jul 6, 2020 · Databases

How to Enable IPv6 on Oracle 19c: A Step‑by‑Step Guide

This tutorial walks through verifying IPv6 support on Red Hat 7.6, configuring a static IPv6 address, updating the Oracle 19c listener for IPv6, restarting services, and confirming connectivity, providing concrete commands, configuration snippets, and screenshots for a RAC environment.

DatabaseIPv6Linux
0 likes · 5 min read
How to Enable IPv6 on Oracle 19c: A Step‑by‑Step Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 3, 2020 · Databases

PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices

This article compiles a series of questions and answers from a recent PostgreSQL live session, covering recommended scenarios, differences with Oracle, backup and recovery, clustering, PostGIS, stored procedures, migration tips, version recommendations, performance tuning, high‑availability, and real‑world adoption across industries.

DatabaseHigh AvailabilityOracle migration
0 likes · 10 min read
PostgreSQL Q&A: Use Cases, Oracle Comparison, Features, Migration and Best Practices
Meituan Technology Team
Meituan Technology Team
Jul 2, 2020 · Databases

Meituan's Million‑Level KV Storage Architecture and Practices: Squirrel (In‑Memory) and Cellar (Persistent)

Meituan’s KV platform evolved from Memcached and Redis to its own high‑throughput in‑memory Squirrel and durable Cellar systems, each partitioning keys into 16 384 slots, using ZooKeeper routing, Kubernetes scaling, intelligent migration, cross‑region Raft replication, multi‑queue latency isolation, and hotspot management, while planning further optimizations such as Redis‑Gossip tuning, kernel‑bypass I/O, and FPGA acceleration.

CellarDatabaseHigh Availability
0 likes · 26 min read
Meituan's Million‑Level KV Storage Architecture and Practices: Squirrel (In‑Memory) and Cellar (Persistent)
MaGe Linux Operations
MaGe Linux Operations
Jul 2, 2020 · Databases

Mastering MySQL Benchmarking with Sysbench: A Complete Guide

This article explains MySQL benchmark testing, the role and metrics of benchmarking, introduces sysbench, provides step‑by‑step installation and usage instructions, and offers practical tips for interpreting results and optimizing database performance in production environments.

DatabaseMySQLSysbench
0 likes · 11 min read
Mastering MySQL Benchmarking with Sysbench: A Complete Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 26, 2020 · Databases

Understanding MySQL Query Execution Process and Optimization

This article explains how MySQL processes a SELECT statement—from client request, cache check, parsing, optimization, and execution—to return results, using a sample User table, a detailed query example, and a step‑by‑step walkthrough of the parser, optimizer, and executor components.

DatabaseMySQLQuery Optimization
0 likes · 9 min read
Understanding MySQL Query Execution Process and Optimization
Programmer DD
Programmer DD
Jun 23, 2020 · Databases

Master MySQL Basics: Schemas, Data Types, and Full CRUD Guide

This article provides a comprehensive MySQL tutorial covering schema concepts, data types, service control, database creation, table manipulation, and complete CRUD operations with practical command‑line examples and code snippets for beginners and intermediate users.

CRUDData TypesDatabase
0 likes · 15 min read
Master MySQL Basics: Schemas, Data Types, and Full CRUD Guide
Java Backend Technology
Java Backend Technology
Jun 20, 2020 · Databases

What’s the Real Execution Order of SQL Queries? A Visual Guide

Although most SQL statements begin with SELECT, the actual execution follows a specific order—WHERE, GROUP BY, HAVING, then SELECT—illustrated by a diagram that also clarifies common misconceptions about filtering window functions, column aliases, and how databases may reorder operations for optimization.

DatabaseLINQOptimization
0 likes · 6 min read
What’s the Real Execution Order of SQL Queries? A Visual Guide
Beike Product & Technology
Beike Product & Technology
Jun 18, 2020 · Databases

Resolving Duplicate Income Splitting in a Financial System: Transaction Isolation, Spring Propagation, and Redis Lock

This article analyzes a financial system's duplicate income‑splitting bug caused by concurrent transactions, explains how MySQL isolation levels and Spring transaction propagation contributed to dirty reads, and presents two corrective approaches—adjusting transaction propagation and repositioning Redis locks—to ensure reliable data consistency.

DatabaseMySQLRedis
0 likes · 10 min read
Resolving Duplicate Income Splitting in a Financial System: Transaction Isolation, Spring Propagation, and Redis Lock
Tencent Cloud Developer
Tencent Cloud Developer
Jun 17, 2020 · Databases

Understanding Cache Challenges and Solutions with Tencent Cloud Redis Hybrid Storage

The article outlines common cache challenges—consistency, breakdown, and avalanche—explains traditional three‑tier architectures, then details Tencent Cloud Redis Hybrid Storage’s unified interface, automatic hot‑data caching, dynamic TTL, atomic updates, and cost‑effective persistence, offering a scalable, reliable cache‑plus‑storage solution.

CacheDatabaseHybrid storage
0 likes · 27 min read
Understanding Cache Challenges and Solutions with Tencent Cloud Redis Hybrid Storage
MaGe Linux Operations
MaGe Linux Operations
Jun 14, 2020 · Databases

Mastering Redis Monitoring: Key Metrics, Commands, and Performance Tips

This guide details Redis monitoring metrics across performance, memory, activity, persistence, and error categories, explains how to retrieve them with the INFO command, outlines useful monitoring tools, provides slowlog configuration examples, and includes command‑line snippets for performance testing and metric inspection.

DatabaseMemoryPerformance
0 likes · 6 min read
Mastering Redis Monitoring: Key Metrics, Commands, and Performance Tips
Laravel Tech Community
Laravel Tech Community
Jun 13, 2020 · Backend Development

Inserting and Updating Related Models with Laravel Eloquent

This article explains how to add, update, and manage related Eloquent models in Laravel—including saving single or multiple related records, using associate/dissociate for belongsTo relations, and handling many‑to‑many pivots with attach, detach, sync, toggle, and timestamp propagation.

DatabaseEloquentORM
0 likes · 7 min read
Inserting and Updating Related Models with Laravel Eloquent
Laravel Tech Community
Laravel Tech Community
Jun 13, 2020 · Backend Development

Understanding Laravel Eloquent Relationships: HasManyThrough, Polymorphic, and Advanced Query Techniques

This article explains how to define and use Laravel Eloquent relationships—including remote one‑to‑many (hasManyThrough), polymorphic, many‑to‑many polymorphic, and various query constraints—by showing required database schemas, model methods, and example code for retrieving and counting related records.

DatabaseEloquentORM
0 likes · 11 min read
Understanding Laravel Eloquent Relationships: HasManyThrough, Polymorphic, and Advanced Query Techniques
360 Quality & Efficiency
360 Quality & Efficiency
Jun 12, 2020 · Databases

MongoDB Pagination, Query Optimization, and Index Design Guide

This article explains various MongoDB pagination strategies—including skip/limit, range queries, and sorting—covers performance monitoring with profiling, details index creation and design principles, and describes how to interpret explain plans for efficient query optimization.

DatabaseMongoDBPagination
0 likes · 13 min read
MongoDB Pagination, Query Optimization, and Index Design Guide
macrozheng
macrozheng
Jun 12, 2020 · Databases

Why Does MySQL Show Negative Balances? Unraveling MVCC and Isolation Levels

This article analyzes a production incident where concurrent MySQL transactions caused an over‑deduction of account balance, explains the underlying MVCC mechanism, consistency view rules, and how different isolation levels (RR vs RC) affect data visibility and lead to negative balances.

DatabaseInnoDBMVCC
0 likes · 12 min read
Why Does MySQL Show Negative Balances? Unraveling MVCC and Isolation Levels
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 10, 2020 · Databases

Understanding HBase Compaction: Types, Triggers, Algorithms, and Impact on Read/Write Performance

This article explains HBase compaction—a key operation in the Log‑Structured Merge‑Tree model—covering minor and major compaction differences, trigger conditions, configuration parameters, selection algorithms, thread‑pool handling, and the effects on read and write performance in a big‑data database environment.

DatabaseHBaseLSM
0 likes · 10 min read
Understanding HBase Compaction: Types, Triggers, Algorithms, and Impact on Read/Write Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 9, 2020 · Databases

Implementing a Raw TCP MySQL Connection in Python

This article explains the MySQL client‑server handshake, details the sequence of packets exchanged during a TCP connection, and provides a complete Python implementation that builds a raw TCP socket to connect, authenticate, and communicate with a MySQL server without using a high‑level driver.

DatabaseMySQLProtocol
0 likes · 12 min read
Implementing a Raw TCP MySQL Connection in Python
Selected Java Interview Questions
Selected Java Interview Questions
Jun 8, 2020 · Databases

Comprehensive MySQL Interview Guide: Concepts, Indexes, Transactions, Storage Engines, and Optimization

This article provides an extensive overview of MySQL fundamentals for interview preparation, covering primary key concepts, index types and usage, transaction properties and isolation levels, storage engine differences, query execution order, performance tuning with EXPLAIN, lock mechanisms, replication strategies, and high‑concurrency solutions.

DatabaseMySQLOptimization
0 likes · 49 min read
Comprehensive MySQL Interview Guide: Concepts, Indexes, Transactions, Storage Engines, and Optimization
Top Architect
Top Architect
Jun 8, 2020 · Backend Development

Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Distributed ID Generation

The article explains why idempotency is essential for reliable services, describes how unique identifiers such as UUIDs, Snowflake IDs, and database‑generated keys can be used to achieve it, and offers practical guidance on shared storage, avoiding unnecessary queries, and handling duplicate requests in distributed systems.

DatabaseUnique IDdistributed-systems
0 likes · 8 min read
Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Distributed ID Generation
Selected Java Interview Questions
Selected Java Interview Questions
Jun 5, 2020 · Databases

MySQL Query Optimization Techniques and Common Pitfalls

This article explains MySQL execution order, highlights performance problems with large OFFSET LIMIT queries, demonstrates how implicit type conversion, sub‑query rewriting, EXISTS removal, condition push‑down, and intermediate result push‑down can dramatically improve query speed, and provides practical SQL rewrite examples.

DatabaseJOINLIMIT
0 likes · 13 min read
MySQL Query Optimization Techniques and Common Pitfalls
macrozheng
macrozheng
Jun 2, 2020 · Databases

Master MySQL Architecture: Storage Engines, Indexes, Transactions & Optimization

This comprehensive guide explains MySQL's layered architecture, storage engine plugins, index structures, transaction isolation levels, locking mechanisms, performance tuning techniques, partitioning, sharding, and replication, providing practical insights for developers and DBAs to optimize and scale MySQL deployments.

DatabaseMySQLindexing
0 likes · 77 min read
Master MySQL Architecture: Storage Engines, Indexes, Transactions & Optimization
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 1, 2020 · Databases

Guide to Upgrading MySQL from 5.7 to 8.0

This article provides a comprehensive step‑by‑step guide for DBAs to safely upgrade MySQL from version 5.7 to 8.0, covering motivations, compatibility checks, new features, preparation tasks, upgrade commands, post‑upgrade verification, and rollback considerations.

DatabaseMySQLPerformance
0 likes · 7 min read
Guide to Upgrading MySQL from 5.7 to 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
May 28, 2020 · Databases

Creating Custom Extensions in MySQL Shell with JavaScript and Python

The article explains how MySQL Shell 8.0.17+ can be extended using JavaScript or Python to build reusable reports and plugins, describes the directory layout, provides a complete example of registering a report and a plugin that list tables without primary keys, and shows how to invoke them via \show, \watch or direct function calls.

DatabaseExtensionJavaScript
0 likes · 8 min read
Creating Custom Extensions in MySQL Shell with JavaScript and Python
ITPUB
ITPUB
May 26, 2020 · Databases

40 Proven Oracle SQL Optimization Tips to Supercharge Query Performance

This guide walks through Oracle SQL execution steps, optimizer selection, table access methods, shared SQL caching, join order, index usage, query rewriting techniques, hint usage, and dozens of practical tips that together dramatically improve database performance while avoiding common pitfalls.

DatabaseOptimizationOracle
0 likes · 25 min read
40 Proven Oracle SQL Optimization Tips to Supercharge Query Performance
Java Backend Technology
Java Backend Technology
May 26, 2020 · Backend Development

How to Build Scalable Operation Logs: AOP vs Binlog Implementation

This article examines common operation‑log types and compares two implementation approaches—traditional AOP with annotations and a database binlog‑based solution—detailing their advantages, drawbacks, code examples, database design, future enhancements, and practical deployment considerations.

AOPDatabaseLogging
0 likes · 10 min read
How to Build Scalable Operation Logs: AOP vs Binlog Implementation
Laravel Tech Community
Laravel Tech Community
May 25, 2020 · Databases

What’s New in SQLite 3.32.0? Key Features and Enhancements Explained

SQLite 3.32.0, the latest release of the world’s most widely used database engine, introduces approximate ANALYZE support, a bytecode virtual table, new SQL functions, expanded parameter limits, numerous CLI enhancements, and behavior changes that align the LIKE operator with PostgreSQL, offering developers richer functionality and improved compatibility.

CLI EnhancementsDatabaseSQL
0 likes · 3 min read
What’s New in SQLite 3.32.0? Key Features and Enhancements Explained
Selected Java Interview Questions
Selected Java Interview Questions
May 23, 2020 · Databases

Root Causes and Troubleshooting of Redis Timeout Exceptions

This article analyzes why Redis service nodes may experience massive TimeoutException errors, covering external influences such as CPU and memory contention, network resource exhaustion, and internal Redis usage issues like slow queries, persistence overhead, and configuration pitfalls, and provides concrete diagnostic commands and mitigation steps.

DatabasePerformanceRedis
0 likes · 9 min read
Root Causes and Troubleshooting of Redis Timeout Exceptions
iQIYI Technical Product Team
iQIYI Technical Product Team
May 22, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Two‑Phase Commit for Event‑Driven Order Processing

The article explains how iQIYI’s order system leverages MySQL binlog and redo log with a two‑phase commit to drive event‑driven processing, reveals hidden consistency gaps where binlog events can precede database state, and proposes retry or direct binlog consumption strategies to ensure reliable order fulfillment.

DatabaseEventDrivenMySQL
0 likes · 15 min read
Understanding MySQL Binlog, Redo Log, and Two‑Phase Commit for Event‑Driven Order Processing
Big Data Technology Architecture
Big Data Technology Architecture
May 21, 2020 · Databases

Quick Start Guide: Running HBase with Docker

This tutorial demonstrates how to rapidly set up and use HBase inside a Docker container, covering Docker installation, image pulling, container execution, host configuration, accessing the HBase Web UI and shell, Zookeeper interaction, and a Java API example for beginners.

DatabaseDockerHBase
0 likes · 5 min read
Quick Start Guide: Running HBase with Docker
Programmer DD
Programmer DD
May 20, 2020 · Backend Development

Why Does Druid Throw “Connection Holder Is Null” and How to Fix It?

This article examines recurring “connection holder is null” errors in Druid’s connection pool, explains how the holder is assigned and cleared, analyzes two real‑world cases—long‑running transactions and killed connections—and offers practical configuration recommendations to prevent the issue.

DatabaseDruidJava
0 likes · 7 min read
Why Does Druid Throw “Connection Holder Is Null” and How to Fix It?
Aikesheng Open Source Community
Aikesheng Open Source Community
May 18, 2020 · Databases

Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)

This article explains the MySQL group_replication_consistency parameter, describes its five possible values, demonstrates the three most common consistency modes (EVENTUAL, BEFORE, AFTER) with practical multi‑node examples, and discusses their advantages, drawbacks, and impact on query latency and data integrity.

DatabaseGroup ReplicationMySQL
0 likes · 13 min read
Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)
Laravel Tech Community
Laravel Tech Community
May 18, 2020 · Databases

How to Diagnose and Eliminate MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can suffer from latency, examines the root causes on both master and slave sides, and provides practical architectural, hardware, and configuration solutions—including semi‑sync and parallel replication—to improve data consistency and performance.

DatabaseMaster‑SlaveMySQL
0 likes · 11 min read
How to Diagnose and Eliminate MySQL Master‑Slave Replication Lag
Xiao Lou's Tech Notes
Xiao Lou's Tech Notes
May 17, 2020 · Databases

How to Build a High‑Availability, High‑Performance Distributed ID Generator

Distributed systems need globally unique, often monotonic IDs, and this article examines common ID generation strategies—Snowflake, database auto‑increment, segment allocation, multi‑master databases, and Raft‑based consensus—evaluating each for high availability and high performance, and highlighting trade‑offs and implementation details.

DatabaseRaftdistributed ID
0 likes · 8 min read
How to Build a High‑Availability, High‑Performance Distributed ID Generator
JavaEdge
JavaEdge
May 17, 2020 · Databases

Mastering MySQL High Availability: Backup, Binlog, and Replication Strategies

This guide explains how to achieve MySQL high availability and scalability through full and incremental backups, binlog-based point‑in‑time recovery, and both asynchronous and synchronous replication, while highlighting trade‑offs, best practices, and practical command examples.

DatabaseHigh AvailabilityMySQL
0 likes · 11 min read
Mastering MySQL High Availability: Backup, Binlog, and Replication Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
May 14, 2020 · Databases

MySQL 5.7 Upgrade Failure Caused by Default SSL Enablement and JDBC useSSL Parameter Misconfiguration

The article analyzes a MySQL 5.7 upgrade that broke an application due to SSL being enabled by default in version 5.7.28, explains how the JDBC useSSL=true setting triggered handshake errors, and provides several practical solutions such as disabling SSL, adjusting auto‑generation settings, and updating the connection string.

ConfigurationDatabaseJDBC
0 likes · 12 min read
MySQL 5.7 Upgrade Failure Caused by Default SSL Enablement and JDBC useSSL Parameter Misconfiguration
DataFunTalk
DataFunTalk
May 12, 2020 · Artificial Intelligence

Semantic Parsing for Text-to-SQL: Datasets, Models, Evaluation, and Applications

This article reviews the Text-to-SQL semantic parsing task, covering its motivation, dataset landscape, major model architectures such as pointer networks, sequence‑to‑set, and grammar‑based approaches, evaluation metrics, the newly built DuSQL dataset and DuParser system, real‑world deployments, and remaining research challenges.

AIDatabaseText-to-SQL
0 likes · 20 min read
Semantic Parsing for Text-to-SQL: Datasets, Models, Evaluation, and Applications
dbaplus Community
dbaplus Community
May 11, 2020 · Databases

How to Prevent Data Deletion Disasters: DBA Best Practices for Backup, Optimization, and High Availability

This article examines recent database deletion incidents and offers DBA‑level guidance on strengthening processes, technical safeguards, and security policies, covering backup‑restore design, performance optimization, high‑availability strategies, and self‑service automation to avoid future data loss.

DBADatabaseHigh Availability
0 likes · 24 min read
How to Prevent Data Deletion Disasters: DBA Best Practices for Backup, Optimization, and High Availability
Programmer DD
Programmer DD
May 9, 2020 · Databases

How to Identify and Reduce CPU Bottlenecks in MySQL

This article explains which components consume CPU on a MySQL server, analyzes the impact of user‑space processing and IO wait, and provides practical strategies—such as optimizing indexes, reducing unnecessary calculations, and improving IO handling—to lower CPU usage and improve overall database performance.

CPU OptimizationDatabaseIO Wait
0 likes · 6 min read
How to Identify and Reduce CPU Bottlenecks in MySQL
Programmer DD
Programmer DD
May 3, 2020 · Databases

What’s New in Redis 6.0? Key Features and Improvements Explained

Redis 6.0.0 stable release brings major updates such as redesigned client‑side caching, immediate RDB deletion for replication, enhanced ACL logging, faster PSYNC2 partial resynchronization, decimal timeout support, up to 30% faster RDB loading, and a new STRALGO command for string algorithms.

ACLDatabaseRDB
0 likes · 3 min read
What’s New in Redis 6.0? Key Features and Improvements Explained
Laravel Tech Community
Laravel Tech Community
May 2, 2020 · Operations

Comprehensive MySQL and Linux Operations Interview Guide

This guide compiles essential MySQL security steps, master‑slave replication principles, backup scripts, Linux boot overview, common port services, virus mitigation, monitoring tools, nginx optimization, InnoDB lock troubleshooting, replication lag reduction, high‑availability components, data migration utilities, and automation configuration management techniques for operations engineers.

DatabaseLinuxMySQL
0 likes · 13 min read
Comprehensive MySQL and Linux Operations Interview Guide
Laravel Tech Community
Laravel Tech Community
Apr 30, 2020 · Databases

Essential MySQL FAQ: Core Concepts, Features, and Best Practices

This comprehensive MySQL FAQ covers its definition, implementation language, key features, differences from SQL, storage engines, data types, triggers, security tips, performance considerations, and practical queries such as retrieving the N‑th highest salary, providing a solid reference for developers and DBAs.

DatabaseMySQLPerformance
0 likes · 14 min read
Essential MySQL FAQ: Core Concepts, Features, and Best Practices
Top Architect
Top Architect
Apr 28, 2020 · Operations

Evolution of System Architecture: From Single‑Machine to Distributed Designs

The article outlines the historical evolution of IT architecture—from early single‑machine deployments through hot‑standby and multi‑node active clusters to modern distributed systems—explaining the motivations, trade‑offs, and key technologies that drive each generation and offering guidance on selecting the right architecture for business needs.

DatabaseDistributed Systemssystem design
0 likes · 8 min read
Evolution of System Architecture: From Single‑Machine to Distributed Designs
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 28, 2020 · Databases

New Features in MySQL 8.0.20 Release

MySQL 8.0.20 introduces a range of enhancements including new SHOW_ROUTINE privilege, hash join improvements, index‑level optimizer hints, performance schema refinements, SQL syntax changes, InnoDB doublewrite buffer relocation, binary log transaction compression, X Plugin and protocol upgrades, and additional replication options.

BinaryLogDatabaseInnoDB
0 likes · 5 min read
New Features in MySQL 8.0.20 Release
Java Backend Technology
Java Backend Technology
Apr 26, 2020 · Databases

When to Shard Your Database? A Practical Guide to Partitioning Strategies

This article explains database bottlenecks caused by IO and CPU limits, introduces horizontal and vertical sharding for databases and tables, compares popular sharding tools, discusses challenges such as distributed transactions, cross‑node joins, pagination and global ID generation, and offers guidance on when and how to apply sharding in real‑world systems.

DatabaseDistributed SystemsSharding
0 likes · 14 min read
When to Shard Your Database? A Practical Guide to Partitioning Strategies
ITPUB
ITPUB
Apr 25, 2020 · Databases

Master Oracle Database: Startup, Shutdown, Users, Tablespaces, Indexes, Views, and Partitions

This comprehensive guide walks you through essential Oracle database administration tasks—including starting and stopping the database, managing listeners, creating and altering tablespaces, handling users and privileges, controlling transactions, building indexes, defining views and materialized views, working with sequences, synonyms, and partitioned tables—complete with commands, examples, and best‑practice tips.

AdministrationDatabaseOracle
0 likes · 21 min read
Master Oracle Database: Startup, Shutdown, Users, Tablespaces, Indexes, Views, and Partitions
Laravel Tech Community
Laravel Tech Community
Apr 23, 2020 · Backend Development

Understanding ORM vs DB Query Builder in Laravel

This article explains the differences between Laravel's ORM and DB query builder, outlines their advantages and appropriate use cases, and provides step‑by‑step code examples for defining models, retrieving, creating, and deleting records, as well as handling transactions.

DatabaseORMPHP
0 likes · 5 min read
Understanding ORM vs DB Query Builder in Laravel
macrozheng
macrozheng
Apr 22, 2020 · Databases

13 Proven Techniques to Supercharge Redis Performance

Learn how to dramatically boost Redis speed by shortening key/value sizes, enabling lazy free, setting expirations, disabling costly commands, using slowlog, pipelines, avoiding mass expirations, optimizing clients, limiting memory, running on physical servers, tweaking persistence, disabling THP, and adopting distributed architectures.

DatabaseLazy FreePerformance Optimization
0 likes · 19 min read
13 Proven Techniques to Supercharge Redis Performance
Laravel Tech Community
Laravel Tech Community
Apr 21, 2020 · Backend Development

Master Laravel Eloquent: Essential Model Cheat Sheet & Usage Guide

This cheat sheet provides a concise yet comprehensive guide to Laravel's Eloquent Model, covering definition, artisan commands, common CRUD methods, soft‑deletes, relationship types, model events, and configuration tips, all illustrated with ready‑to‑copy code examples.

DatabaseEloquentModel
0 likes · 9 min read
Master Laravel Eloquent: Essential Model Cheat Sheet & Usage Guide
Code Ape Tech Column
Code Ape Tech Column
Apr 20, 2020 · Databases

Understanding Redis Persistence: RDB vs AOF and Performance Tips

This article explains how Redis implements two persistence mechanisms—RDB snapshots and AOF logs—covering their triggers, execution flows, advantages, drawbacks, differences, restart recovery procedures, and practical ways to mitigate performance overhead caused by fork operations.

AOFDatabasePerformance
0 likes · 14 min read
Understanding Redis Persistence: RDB vs AOF and Performance Tips