BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 16 of 50
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 21, 2024 · Backend Development

Backend Anti‑Patterns and Optimization Strategies for MySQL, Redis, and Thread Pools

This article examines common backend anti‑patterns such as inefficient MySQL for‑loops, heavy multi‑query methods, full‑table scans, improper thread‑pool creation, and long‑running transactions, and provides practical optimization recommendations including query consolidation, caching, indexing, and proper resource management.

Anti-PatternsBackendMySQL
0 likes · 12 min read
Backend Anti‑Patterns and Optimization Strategies for MySQL, Redis, and Thread Pools
DaTaobao Tech
DaTaobao Tech
Sep 20, 2024 · Databases

Database Technology Evolution: From Hierarchical to Vector Databases

The article chronicles the evolution of database technology from early hierarchical and network models through relational, column‑store, document, key‑value, graph, time‑series, HTAP, and finally vector databases, detailing each system’s architecture, strengths, limitations, typical uses, and future trends toward specialization, distributed cloud‑native designs, and AI‑driven applications.

HBaseHTAPInfluxDB
0 likes · 52 min read
Database Technology Evolution: From Hierarchical to Vector Databases
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 20, 2024 · Cloud Computing

Step-by-Step Guide to Setting Up a Cloud Server with JDK, Redis, and MySQL on Alibaba Cloud ECS

This article provides a detailed, beginner‑friendly tutorial on purchasing an Alibaba Cloud ECS instance, configuring the operating system, and installing JDK 8, Redis, and MySQL 8.0—including necessary firewall and security‑group settings—to launch a functional web‑site environment.

Alibaba CloudCloud ComputingJDK
0 likes · 12 min read
Step-by-Step Guide to Setting Up a Cloud Server with JDK, Redis, and MySQL on Alibaba Cloud ECS
dbaplus Community
dbaplus Community
Sep 19, 2024 · Databases

How MySQL Implements SQL Flow Control to Protect CPU Resources

This article explains the design and implementation of MySQL's SQL flow‑control feature, covering its purpose, architecture, external commands, rule management, matching logic, data‑access layer, performance considerations, usage guidelines, and known limitations.

MySQLPerformanceSQL flow control
0 likes · 15 min read
How MySQL Implements SQL Flow Control to Protect CPU Resources
Architect
Architect
Sep 19, 2024 · Databases

Phantom Read Verification and Analysis in InnoDB REPEATABLE‑READ Isolation

This article investigates whether the REPEATABLE‑READ isolation level in InnoDB fully prevents phantom reads by conducting a series of current‑read and snapshot‑read experiments, analyzing transaction behavior, MVCC mechanisms, and offering recommendations to avoid phantom anomalies.

InnoDBMVCCMySQL
0 likes · 19 min read
Phantom Read Verification and Analysis in InnoDB REPEATABLE‑READ Isolation
ITPUB
ITPUB
Sep 15, 2024 · Databases

Does Varchar Length Affect MySQL Storage and Query Performance? A Practical Test

This article investigates whether defining a VARCHAR column with a larger length (e.g., VARCHAR(500) vs VARCHAR(50)) changes storage consumption and query speed in MySQL by creating two identical tables, inserting one million rows, measuring space usage, and benchmarking various SELECT and ORDER BY operations.

MySQLPerformanceSQL
0 likes · 10 min read
Does Varchar Length Affect MySQL Storage and Query Performance? A Practical Test
ITPUB
ITPUB
Sep 14, 2024 · Databases

Should You Choose MariaDB Over MySQL? A Deep Technical Comparison

The article compares MySQL and MariaDB, tracing MySQL’s historic rise, explaining why MariaDB was forked, detailing their governance, enumerating MariaDB’s additional storage engines and performance optimizations, highlighting new features, and analyzing recent adoption trends that suggest MariaDB may eventually overtake MySQL.

MariaDBMySQLRDBMS
0 likes · 6 min read
Should You Choose MariaDB Over MySQL? A Deep Technical Comparison
IT Services Circle
IT Services Circle
Sep 13, 2024 · Backend Development

Comprehensive Java Backend Interview Guide: Collections, JVM, OS, Networking, MySQL, Redis, and Algorithms

This article provides a thorough Java backend interview preparation guide covering collection frameworks, JVM architecture and garbage‑collection, operating‑system thread vs process concepts, TCP handshake and termination, MySQL transaction ACID properties and concurrency anomalies, Redis cache consistency strategies, and a sample algorithm problem.

JVMJavaMySQL
0 likes · 18 min read
Comprehensive Java Backend Interview Guide: Collections, JVM, OS, Networking, MySQL, Redis, and Algorithms
Efficient Ops
Efficient Ops
Sep 11, 2024 · Backend Development

Why Do MySQL and Java Processes Hit 900% CPU? Proven Diagnosis & Fixes

Learn how to identify and resolve extreme CPU usage spikes—up to 900%—in MySQL and Java applications by using top, show processlist, indexing, caching, thread analysis, and code adjustments, with real‑world examples and step‑by‑step command guides.

CPU OptimizationDatabase IndexingJava
0 likes · 11 min read
Why Do MySQL and Java Processes Hit 900% CPU? Proven Diagnosis & Fixes
MaGe Linux Operations
MaGe Linux Operations
Sep 11, 2024 · Databases

Master MySQL Upgrade: Key Tips, Commands, and Common Pitfalls

This guide details essential MySQL upgrade considerations, backup warnings, version‑specific changes, and step‑by‑step procedures for both in‑place and logical migrations, helping administrators safely move from MySQL 5.6 to 5.7 while avoiding common pitfalls.

LogicalMySQLSQL
0 likes · 7 min read
Master MySQL Upgrade: Key Tips, Commands, and Common Pitfalls
Java Backend Technology
Java Backend Technology
Sep 11, 2024 · Databases

When to Use DISTINCT vs GROUP BY in MySQL: Performance Insights

This article compares MySQL's DISTINCT and GROUP BY clauses, detailing when they deliver identical performance with indexed columns, why DISTINCT can be faster without indexes, how each handles NULLs and multi‑column deduplication, and provides practical syntax examples and optimization guidance.

DISTINCTGROUP BYIndex Optimization
0 likes · 10 min read
When to Use DISTINCT vs GROUP BY in MySQL: Performance Insights
dbaplus Community
dbaplus Community
Sep 10, 2024 · Databases

Boost MySQL Performance: Essential Tools, Installation & Report Analysis

This guide introduces four popular MySQL performance‑tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—provides download commands, usage examples, and detailed tips for interpreting their diagnostic reports to improve database configuration and query efficiency.

Database ToolsMySQLQuery Optimization
0 likes · 8 min read
Boost MySQL Performance: Essential Tools, Installation & Report Analysis
IT Services Circle
IT Services Circle
Sep 10, 2024 · Databases

Understanding MySQL Indexes: Types, Structures, and Optimization Techniques

This article provides a comprehensive overview of MySQL indexing, covering index classifications, B+Tree and Hash structures, primary and secondary (clustered and non‑clustered) indexes, covering index push‑down, index merge, covering indexes, cost‑based index selection, and common pitfalls that cause index inefficiency.

MySQLPerformanceSQL
0 likes · 27 min read
Understanding MySQL Indexes: Types, Structures, and Optimization Techniques
Sanyou's Java Diary
Sanyou's Java Diary
Sep 9, 2024 · Databases

Master MySQL Indexes: B+Tree, Hash, Clustering & Optimization

This article provides a comprehensive guide to MySQL indexing, covering index types, data structures, clustering and non‑clustering indexes, hash indexes, B+Tree mechanics, index lookup, covering indexes, index push‑down, index merge, cost‑based index selection, common pitfalls, and best practices for designing effective indexes.

MySQLOptimizationPerformance
0 likes · 34 min read
Master MySQL Indexes: B+Tree, Hash, Clustering & Optimization
Selected Java Interview Questions
Selected Java Interview Questions
Sep 8, 2024 · Backend Development

Two Backend Approaches for Drag‑and‑Drop Sorting: Array vs. Doubly Linked List

The article compares two backend implementations for drag‑and‑drop ordering—using a simple position column (array model) and a doubly linked list with prev_id and sibling_id—detailing their MySQL schemas, update logic, performance trade‑offs, and practical considerations such as pagination and locking.

Drag-and-DropMySQLarray
0 likes · 9 min read
Two Backend Approaches for Drag‑and‑Drop Sorting: Array vs. Doubly Linked List
ITPUB
ITPUB
Sep 8, 2024 · Databases

What’s New in MySQL 8.4? Key Changes, Compatibility, and Upgrade Guide

MySQL 8.4 becomes the new LTS release, offering detailed upgrade‑downgrade compatibility tables, dozens of InnoDB and temporary‑table parameter defaults, MGR and replication enhancements, new commands, and a list of deprecated features to help DBAs plan migrations efficiently.

8.4InnoDBMGR
0 likes · 11 min read
What’s New in MySQL 8.4? Key Changes, Compatibility, and Upgrade Guide
dbaplus Community
dbaplus Community
Sep 8, 2024 · Operations

10 Essential Ops Practices to Prevent System Failures

This article compiles ten practical operations‑engineer guidelines—ranging from change rollbacks and safe command aliases to backup verification, monitoring, and cautious automated failover—to help maintain high availability and avoid costly production incidents.

LinuxMySQLautomation
0 likes · 18 min read
10 Essential Ops Practices to Prevent System Failures
php Courses
php Courses
Sep 6, 2024 · Backend Development

How to Use mysqli_fetch_assoc in PHP to Retrieve Query Results

This tutorial explains how to connect to a MySQL database using PHP's mysqli extension, execute queries, and retrieve results with mysqli_fetch_assoc, providing step-by-step code examples for connection, querying, and a complete script.

MySQLMySQLiSQL
0 likes · 4 min read
How to Use mysqli_fetch_assoc in PHP to Retrieve Query Results
Test Development Learning Exchange
Test Development Learning Exchange
Sep 5, 2024 · Backend Development

Build a Clean, Efficient MySQL Utility Class in Python

This article walks you through designing a lightweight, high‑performance MySQL helper class in Python, covering singleton connection management, robust exception handling, logging, context‑managed connections, and practical query/execute methods with example code and usage scenarios.

MySQLPythonUtility Class
0 likes · 7 min read
Build a Clean, Efficient MySQL Utility Class in Python
JD Tech Talk
JD Tech Talk
Sep 5, 2024 · Databases

Why MySQL Auto‑Increment Primary Keys Can Become Non‑Continuous

This article explains the mechanisms behind MySQL auto‑increment primary keys, why gaps appear after failed inserts, unique‑index violations, transaction rollbacks, and batch operations, and how storage engines and innodb_autoinc_lock_mode settings influence the continuity of generated IDs.

InnoDBMySQLUnique Index
0 likes · 11 min read
Why MySQL Auto‑Increment Primary Keys Can Become Non‑Continuous
Architect's Guide
Architect's Guide
Sep 5, 2024 · Databases

Strategies for Fast Import of 1 Billion Records into MySQL

To import one billion 1 KB log records stored in HDFS or S3 into MySQL efficiently, the article examines data partitioning, B‑tree index limits, batch insertion, storage engine choices, concurrency control, file‑reading methods, task scheduling with Redis, Redisson, and Zookeeper for reliable, ordered, high‑throughput loading.

Batch InsertData PartitioningMySQL
0 likes · 18 min read
Strategies for Fast Import of 1 Billion Records into MySQL
Open Source Tech Hub
Open Source Tech Hub
Sep 4, 2024 · Backend Development

Boost PHP Performance with AMPHP’s Asynchronous MySQL Client

This guide introduces AMPHP’s event‑driven async MySQL library for PHP, explains its non‑blocking API, connection‑pool architecture, supported features, and provides step‑by‑step installation and code examples for basic queries, iterators, and transactional operations.

AmpHPBackendMySQL
0 likes · 6 min read
Boost PHP Performance with AMPHP’s Asynchronous MySQL Client
Top Architect
Top Architect
Sep 2, 2024 · Backend Development

Inventory Deduction Strategies: Database vs. Redis with Lua Script Implementation

This article compares three inventory deduction approaches—single‑field MySQL updates, sharded MySQL records, and Redis INCRBY with Lua scripting—analyzes their concurrency drawbacks, and provides a complete Java implementation using Redis Lua scripts, distributed locks, and callback‑based stock initialization.

BackendInventoryLua
0 likes · 13 min read
Inventory Deduction Strategies: Database vs. Redis with Lua Script Implementation
Selected Java Interview Questions
Selected Java Interview Questions
Sep 2, 2024 · Databases

Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices

This article explains the challenges of executing full‑table UPDATE statements on large MySQL tables using row‑based binlog replication, analyzes deep pagination issues, and presents a batch‑processing strategy with FORCE INDEX, SQL_NO_CACHE and controlled rate limiting to safely migrate data at scale.

BinlogFull Table UpdateMySQL
0 likes · 8 min read
Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 2, 2024 · Databases

MySQL 8.0 Achievements and Community Highlights

The article reviews MySQL's 29‑year evolution, detailing the 8.0 release’s extensive contributions, new features, bug‑fix statistics, and the vital role of the global community and Oracle’s ongoing investment in both the open‑source edition and the HeatWave cloud service.

MySQLOpenSourcecommunity
0 likes · 11 min read
MySQL 8.0 Achievements and Community Highlights
ITPUB
ITPUB
Sep 1, 2024 · Databases

Why MySQL’s != on Nullable Indexed Columns Returns Unexpected Results

This article demonstrates how a non‑unique indexed column that allows NULL values behaves with the != operator in MySQL, showing why null rows are omitted from result sets, how index usage changes, and how to rewrite queries with OR or UNION to obtain correct results while preserving performance.

EXPLAINMySQLNULL
0 likes · 6 min read
Why MySQL’s != on Nullable Indexed Columns Returns Unexpected Results
Java Tech Enthusiast
Java Tech Enthusiast
Aug 29, 2024 · Backend Development

Comprehensive Backend Interview Guide: Network, Security, JVM, Spring, Redis, MySQL and More

The guide equips candidates for backend interviews by covering essential networking (HTTP/HTTPS, TLS handshake, status codes, headers, OCSP, session resumption, CSRF), RPC frameworks, Java class-loading and JVM memory/GC, OS process/thread scheduling, Spring bean lifecycle, Redis caching pitfalls, and MySQL indexing and query optimization.

BackendJVMMySQL
0 likes · 44 min read
Comprehensive Backend Interview Guide: Network, Security, JVM, Spring, Redis, MySQL and More
Sohu Tech Products
Sohu Tech Products
Aug 28, 2024 · Databases

MySQL Data Migration with Double‑Write Using MyBatis Plugin

The article details how the vivo Game Center’s appointment service migrated billions of rows to a dedicated MySQL database with zero‑downtime by implementing a double‑write strategy via a custom MyBatis interceptor that mirrors updates and queries to the new database, handling full and incremental sync, primary‑key consistency, transaction limits, and final cut‑over steps.

MySQLdata migrationdatabase
0 likes · 19 min read
MySQL Data Migration with Double‑Write Using MyBatis Plugin
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 28, 2024 · Databases

Understanding Implicit Locks in MySQL InnoDB

This article explains what implicit locks are in MySQL InnoDB, how to identify their presence on primary and secondary index records, the conditions under which they appear, and the process by which they are converted into explicit locks that can be inspected via performance_schema.

DatabaseLocksImplicitLockInnoDB
0 likes · 9 min read
Understanding Implicit Locks in MySQL InnoDB
Zhuanzhuan Tech
Zhuanzhuan Tech
Aug 27, 2024 · Databases

MySQL InnoDB Deadlock Analysis and Resolution Guide

This article presents a detailed walkthrough of a MySQL InnoDB deadlock case, covering background, log inspection, data preparation, reproduction steps, lock analysis, root‑cause explanation, and practical solutions to prevent and resolve similar deadlock issues.

InnoDBMySQLTroubleshooting
0 likes · 14 min read
MySQL InnoDB Deadlock Analysis and Resolution Guide
Selected Java Interview Questions
Selected Java Interview Questions
Aug 27, 2024 · Databases

MySQL Full‑Text Search: Inverted Index, Query Modes, and Usage

This article explains how MySQL InnoDB implements full‑text search using inverted indexes, shows how to create and drop full‑text indexes, and demonstrates the three query modes—Natural Language, Boolean, and Query Expansion—along with their syntax, operators, relevance calculation, and practical examples.

Boolean ModeMySQLQuery Expansion
0 likes · 11 min read
MySQL Full‑Text Search: Inverted Index, Query Modes, and Usage
High Availability Architecture
High Availability Architecture
Aug 27, 2024 · Backend Development

Design and Implementation of a Double‑Write Migration Strategy for the Appointment Service Using a MyBatis Plugin

This article details the background, requirements, and evaluation of migration options for the appointment service, explains why a double‑write approach with a custom MyBatis plugin was chosen, and walks through the full‑sync, incremental sync, code refactoring, plugin implementation, switch‑over procedures, and post‑migration validation to achieve reliable data isolation and system stability.

JavaMySQLdata synchronization
0 likes · 17 min read
Design and Implementation of a Double‑Write Migration Strategy for the Appointment Service Using a MyBatis Plugin
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 26, 2024 · Databases

Understanding and Managing MySQL Undo Tablespaces

This article explains the purpose, evolution, configuration parameters, and step‑by‑step maintenance procedures for MySQL Undo tablespaces, covering versions from pre‑5.6 to 8.0 and providing practical commands for viewing, creating, truncating, and dropping Undo tablespaces.

InnoDBMySQLUndo Tablespace
0 likes · 11 min read
Understanding and Managing MySQL Undo Tablespaces
dbaplus Community
dbaplus Community
Aug 25, 2024 · Databases

Boost Real‑Time App Performance with ReadySet: A Hands‑On Guide to SQL Caching

This article introduces ReadySet, an open‑source SQL caching layer for MySQL and PostgreSQL, explains its architecture and advantages, and provides step‑by‑step instructions for installing the Docker image, configuring connections, creating caches, and testing query performance to achieve millisecond‑level response times.

DockerMySQLPostgreSQL
0 likes · 7 min read
Boost Real‑Time App Performance with ReadySet: A Hands‑On Guide to SQL Caching
MaGe Linux Operations
MaGe Linux Operations
Aug 25, 2024 · Databases

How to Install and Configure MySQL 5.7 on ARM (Aarch64) with Master‑Slave Replication

This guide walks through checking the OS architecture, preparing the environment, downloading the appropriate MySQL 5.7 packages for ARM, installing and configuring MySQL, setting up automatic startup and environment variables, initializing the server, securing the root account, and finally configuring master‑slave replication between two servers.

ARMLinuxMySQL
0 likes · 15 min read
How to Install and Configure MySQL 5.7 on ARM (Aarch64) with Master‑Slave Replication
Open Source Linux
Open Source Linux
Aug 23, 2024 · Operations

10 Proven Ops Practices to Prevent System Failures

This article shares ten practical operations strategies—including change rollbacks, safe handling of destructive commands, prompt customization, rigorous backup and verification, production environment discipline, careful handovers, robust alerting, cautious automatic failover, meticulous checks, and simplicity—to dramatically improve system reliability and availability.

LinuxMySQLOperations
0 likes · 17 min read
10 Proven Ops Practices to Prevent System Failures
Efficient Ops
Efficient Ops
Aug 21, 2024 · Operations

10 Proven Practices to Prevent System Failures in Operations

This article shares ten practical operations strategies—ranging from change‑rollback procedures and cautious handling of destructive commands to robust backup verification, alerting, and meticulous hand‑over practices—that together help teams dramatically reduce system outages and maintain high availability.

LinuxMySQL
0 likes · 17 min read
10 Proven Practices to Prevent System Failures in Operations
vivo Internet Technology
vivo Internet Technology
Aug 21, 2024 · Databases

MySQL Data Migration with Double‑Write Strategy Using a MyBatis Plugin

The article details a zero‑downtime migration of a high‑traffic reservation service from a shared MySQL instance to an isolated database by employing a double‑write strategy implemented through a custom MyBatis plugin, covering full and incremental sync, consistency verification, traffic shifting, and key lessons on primary‑key handling and asynchronous write side‑effects.

MySQLdata migrationdatabase
0 likes · 19 min read
MySQL Data Migration with Double‑Write Strategy Using a MyBatis Plugin
dbaplus Community
dbaplus Community
Aug 18, 2024 · Databases

Master MySQL Performance: Key Query Optimizations, Index Tips & Config Tweaks

This guide covers practical MySQL performance improvements, including choosing proper data types, avoiding SELECT *, optimizing joins and UNION usage, batch inserts, query cache settings, configuration parameters like innodb_buffer_pool_size, and comprehensive index strategies to accelerate queries and reduce resource consumption.

Database ConfigurationMySQLSQL optimization
0 likes · 18 min read
Master MySQL Performance: Key Query Optimizations, Index Tips & Config Tweaks
ITPUB
ITPUB
Aug 16, 2024 · Databases

How Canva Scaled Its Media Service: From MySQL Limits to DynamoDB Migration

Canva’s media service, handling billions of assets, evolved from a MySQL‑based microservice architecture to a DynamoDB‑backed solution by incrementally migrating metadata, sharding tables, employing real‑time dual writes via SQS, and implementing zero‑downtime cut‑over, dramatically improving latency and scalability.

CanvaDynamoDBMedia Service
0 likes · 14 min read
How Canva Scaled Its Media Service: From MySQL Limits to DynamoDB Migration
Architecture & Thinking
Architecture & Thinking
Aug 15, 2024 · Databases

How to Evolve Your Database Architecture for Massive Scale: From Monolith to Sharding

This article outlines the progressive evolution of database architectures—from simple monolithic designs to cold‑hot separation, read‑write splitting, and horizontal sharding—explaining each pattern, its components, and the performance and scalability benefits they bring to large‑scale systems.

Cold Hot SeparationMySQLRead-Write Separation
0 likes · 8 min read
How to Evolve Your Database Architecture for Massive Scale: From Monolith to Sharding
dbaplus Community
dbaplus Community
Aug 14, 2024 · Databases

When to Use DISTINCT vs GROUP BY in MySQL: Performance Insights

Both DISTINCT and GROUP BY can use indexes when available, giving similar performance, but without indexes DISTINCT is usually faster because GROUP BY may invoke implicit sorting; MySQL 8.0 removed this sorting, making their performance nearly equal, and GROUP BY offers clearer semantics and more flexibility for complex queries.

DISTINCTGROUP BYIndex Optimization
0 likes · 9 min read
When to Use DISTINCT vs GROUP BY in MySQL: Performance Insights
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 14, 2024 · Databases

Granting Table Locks and Row Locks in InnoDB

This article explains how InnoDB in MySQL 8.0.32 grants table and row locks, detailing the active versus passive acquisition, the lock‑granting algorithms for tables and rows, and the priority, weight, and FIFO rules that determine lock ordering and deadlock handling.

Database ConcurrencyInnoDBMySQL
0 likes · 11 min read
Granting Table Locks and Row Locks in InnoDB
ITPUB
ITPUB
Aug 13, 2024 · Databases

Who Should Own Database Change Failures? A Deep Dive into Roles, Risks, and Responsibility

An in‑depth analysis of database change workflows reveals three key players—business developers, DBAs, and change tools—outlines the full lifecycle of a change, illustrates a MySQL VARCHAR length mishap, and argues why the business team should bear primary responsibility while DBAs assume secondary accountability.

DBAMySQLdatabase change management
0 likes · 9 min read
Who Should Own Database Change Failures? A Deep Dive into Roles, Risks, and Responsibility
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 13, 2024 · Databases

Understanding MySQL 8.0 Clone Plugin: Architecture, Implementation, and Comparison with Xtrabackup

This article explains the MySQL 8.0 Clone plugin introduced in version 8.0.17, compares it with Xtrabackup, details its five‑step cloning process, describes the code structure across SQL, plugin, and InnoDB layers, and outlines the page‑archiving subsystem used to track dirty pages during cloning.

Clone PluginDatabase ReplicationInnoDB
0 likes · 18 min read
Understanding MySQL 8.0 Clone Plugin: Architecture, Implementation, and Comparison with Xtrabackup
Java Tech Enthusiast
Java Tech Enthusiast
Aug 12, 2024 · Databases

MySQL InnoDB ReplicaSet and Read/Write Splitting with Router 8.2

The article explains how MySQL Router 8.2 automatically splits read and write traffic in an InnoDB ReplicaSet, routing reads to asynchronous replicas and writes to the primary, providing performance, scalability, and simplified management without any application‑level changes.

DatabaseOptimizationInnoDBMySQL
0 likes · 3 min read
MySQL InnoDB ReplicaSet and Read/Write Splitting with Router 8.2
JD Cloud Developers
JD Cloud Developers
Aug 12, 2024 · Backend Development

Mastering High‑Concurrency: From Thread Pitfalls to Distributed Inventory Architecture

This article explores the three‑high requirements of modern internet systems, compares multithreading with asynchronous methods, and presents a practical, partition‑based inventory‑deduction architecture that leverages Redis caching, MySQL sharding, and asynchronous updates to achieve scalable high‑concurrency performance.

Asynchronous ProgrammingMySQLRedis
0 likes · 19 min read
Mastering High‑Concurrency: From Thread Pitfalls to Distributed Inventory Architecture
php Courses
php Courses
Aug 12, 2024 · Backend Development

How to Generate Dynamic Web Pages with PHP: A Step‑by‑Step Guide

This tutorial walks through setting up a PHP development environment, creating .php files, embedding PHP within HTML, and using PHP to output the current time, handle form submissions, and interact with a MySQL database to build dynamic web pages.

Dynamic PagesForm HandlingMySQL
0 likes · 5 min read
How to Generate Dynamic Web Pages with PHP: A Step‑by‑Step Guide
Java Architect Essentials
Java Architect Essentials
Aug 9, 2024 · Databases

Comprehensive MySQL Query and Configuration Optimization Guide

This article provides a thorough guide to MySQL performance optimization, covering general query improvements, proper data types, index usage, configuration parameter tuning, avoiding common pitfalls, and detailed EXPLAIN analysis, with concrete SQL examples and practical recommendations for developers and DBAs.

Database ConfigurationMySQLQuery Optimization
0 likes · 16 min read
Comprehensive MySQL Query and Configuration Optimization Guide
Programmer XiaoFu
Programmer XiaoFu
Aug 8, 2024 · Databases

Why Is MySQL Slow? Beyond Index Issues and Practical Fixes

The article walks through MySQL’s query execution flow, shows how to profile slow statements, explains index‑related pitfalls, connection‑pool limits, and InnoDB buffer‑pool sizing, and provides concrete commands and examples to diagnose and speed up sluggish queries.

EXPLAINIndex OptimizationInnoDB Buffer Pool
0 likes · 15 min read
Why Is MySQL Slow? Beyond Index Issues and Practical Fixes
vivo Internet Technology
vivo Internet Technology
Aug 7, 2024 · Databases

MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools

While MySQL 5.7 native DDL methods (copy, inplace rebuild, index build, metadata‑only) vary in speed, space use, lock impact, and binlog output, GH‑OST consistently offers the fastest execution, lowest lock blocking, real‑time replication, albeit at roughly double storage cost, making it ideal for risk‑averse online schema changes.

DDLInnoDBMySQL
0 likes · 11 min read
MySQL 5.7 DDL vs GH-OST: A Comprehensive Comparison of Online Schema Change Tools
ITPUB
ITPUB
Aug 7, 2024 · Databases

Ready-to-Use Shell Scripts for Backing Up Oracle, MySQL, PostgreSQL & openGauss

This guide provides a comprehensive collection of ready-to-use shell scripts and step-by-step instructions for backing up and restoring major databases—including Oracle RMAN, logical and physical backups, MySQL full and incremental backups with Xtrabackup, PostgreSQL logical and physical backups, and openGauss dump scripts—plus scheduling and cleanup procedures.

MySQLOraclePostgreSQL
0 likes · 19 min read
Ready-to-Use Shell Scripts for Backing Up Oracle, MySQL, PostgreSQL & openGauss
Java Tech Enthusiast
Java Tech Enthusiast
Aug 6, 2024 · Databases

MySQL Storage Engines: Overview, Differences, and Interview Guidance

MySQL’s pluggable storage‑engine architecture lets each table use a specific engine, with InnoDB (the default in MySQL 8.x) offering row‑level locking, ACID transactions, foreign‑key support, crash recovery, MVCC and a buffer pool, while MyISAM provides only table‑level locking, no transactions, and is suited mainly for read‑intensive workloads lacking recovery requirements.

InnoDBMyISAMMySQL
0 likes · 9 min read
MySQL Storage Engines: Overview, Differences, and Interview Guidance
Code Ape Tech Column
Code Ape Tech Column
Aug 5, 2024 · Backend Development

Design and Implementation of a Generic Asynchronous Processing SDK for Java Backend

This article describes a Java‑based asynchronous processing SDK that leverages Spring AOP, transactional event listeners, Kafka, XXL‑Job, and MySQL to provide non‑intrusive, reliable, and eventually consistent background execution of business methods while preserving transaction integrity and offering configurable retry and compensation strategies.

AOPAsyncJava
0 likes · 8 min read
Design and Implementation of a Generic Asynchronous Processing SDK for Java Backend
Open Source Tech Hub
Open Source Tech Hub
Aug 4, 2024 · Databases

Sync RDS MySQL Data to Alibaba Cloud Elasticsearch with DTS

This guide walks you through using Alibaba Cloud Data Transmission Service (DTS) to continuously synchronize production data from an RDS MySQL instance to an Elasticsearch cluster, covering prerequisites, task creation, verification, Kibana queries, and incremental sync testing.

Alibaba CloudDTSElasticsearch
0 likes · 7 min read
Sync RDS MySQL Data to Alibaba Cloud Elasticsearch with DTS
Java Architect Essentials
Java Architect Essentials
Aug 2, 2024 · Databases

Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts

This article details the step‑by‑step process of switching a SpringBoot‑MyBatisPlus application from MySQL to PostgreSQL, covering driver integration, JDBC configuration changes, numerous SQL and type‑conversion pitfalls, and provides ready‑to‑run PostgreSQL scripts for bulk column adjustments and default values.

JavaMySQLPostgreSQL
0 likes · 11 min read
Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts
php Courses
php Courses
Aug 2, 2024 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article introduces the PHP mysqli_query function, demonstrates how to connect to a MySQL database, execute SELECT, INSERT, UPDATE, and DELETE statements, and explains result handling with example code, providing a concise guide for backend developers working with relational databases.

MySQLSQLmysqli_query
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
Architecture & Thinking
Architecture & Thinking
Aug 1, 2024 · Databases

Choosing the Right Sharding Middleware: ShardingSphere vs MyCAT vs Vitess

This article explains why sharding is needed for high‑traffic databases, outlines vertical and horizontal partitioning, and compares three popular sharding middleware—ShardingSphere, MyCAT, and Vitess—detailing their architectures, advantages, and ideal use cases to help engineers select the right solution.

Database MiddlewareDistributed ArchitectureMySQL
0 likes · 9 min read
Choosing the Right Sharding Middleware: ShardingSphere vs MyCAT vs Vitess
Open Source Tech Hub
Open Source Tech Hub
Aug 1, 2024 · Databases

How to Sync MySQL Data to Elasticsearch: Strategies, Pros, and Pitfalls

This article explains why MySQL‑Elasticsearch synchronization is needed, compares six practical approaches—including sync write, async write, Logstash, binlog, Canal, and Alibaba Cloud DTS—detailing their implementation methods, advantages, disadvantages, and suitable use cases for large‑scale data environments.

BinlogCanalDTS
0 likes · 13 min read
How to Sync MySQL Data to Elasticsearch: Strategies, Pros, and Pitfalls