BestHub
Sign in
Tagged articles
5000 articles
Page 50 of 50
iQIYI Technical Product Team
iQIYI Technical Product Team
Nov 15, 2019 · Databases

Database Selection Strategies and iQIYI's Implementation of MySQL, Redis, Couchbase, and HiKV

The article outlines practical database selection criteria—cost, stability, performance, scalability, security—and details iQIYI’s concrete implementations of MySQL, Redis, Couchbase, and the custom HiKV store, describing their architectures, backup and scaling mechanisms, operational tooling evolution, and a decision‑tree guide for matching workloads to the appropriate database technology.

CouchbaseDatabase operationsHiKV
0 likes · 18 min read
Database Selection Strategies and iQIYI's Implementation of MySQL, Redis, Couchbase, and HiKV
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 14, 2019 · Databases

Understanding InnoDB Tablespace Space Management

This article explains how InnoDB stores user tables and indexes in .ibd files, describes the structure of tablespaces, pages, extents, header pages, XDES entries, INODE pages, and file segments, and shows how indexes allocate and free these internal structures as they grow and shrink.

Database InternalsInnoDBPages
0 likes · 10 min read
Understanding InnoDB Tablespace Space Management
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 13, 2019 · Databases

Resolving High SQL‑Kill Rate Caused by Buffer‑Pool Dirty‑Page Saturation in MySQL

The article analyzes a recurring MySQL alarm where over 200 SQL statements are killed per minute due to buffer‑pool latch contention and a near‑90% dirty‑page ratio, then demonstrates how adjusting InnoDB parameters and doubling the buffer‑pool size eliminated the kills and restored performance.

Database operationsDirty PagesSQL Kill
0 likes · 7 min read
Resolving High SQL‑Kill Rate Caused by Buffer‑Pool Dirty‑Page Saturation in MySQL
Efficient Ops
Efficient Ops
Nov 11, 2019 · Operations

Top 10 Linux Ops Troubleshooting Tips Every Sysadmin Should Know

This article compiles ten common Linux operational problems—from shell script failures and cron output issues to disk space exhaustion and MySQL errors—detailing their causes and step‑by‑step solutions to help sysadmins quickly diagnose and resolve system faults.

LinuxShellcron
0 likes · 11 min read
Top 10 Linux Ops Troubleshooting Tips Every Sysadmin Should Know
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 11, 2019 · Databases

Will MySQL Be Subject to “Bottleneck” Restrictions? An Analysis of US and Chinese Export Controls and Technical Viability

The article examines whether MySQL, especially the Community Edition, faces commercial or regulatory “bottleneck” risks by reviewing US export control rules, Chinese policy guidance, and the technical feasibility of MySQL’s high‑availability architectures, concluding that current policies pose no significant threat.

Database ArchitectureExport controlsOpen Source
0 likes · 8 min read
Will MySQL Be Subject to “Bottleneck” Restrictions? An Analysis of US and Chinese Export Controls and Technical Viability
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 8, 2019 · Databases

Using MySQL auth_socket Plugin for Password‑less Authentication

This article explains how the auth_socket (MySQL) and unix_socket (MariaDB) plugins enable password‑less login by mapping operating‑system users to MySQL accounts, walks through installing and enabling the plugins on Debian, Ubuntu, MariaDB, and Percona Server, and demonstrates creating and using socket‑authenticated users.

PasswordlessPerconaUnix socket authentication
0 likes · 8 min read
Using MySQL auth_socket Plugin for Password‑less Authentication
21CTO
21CTO
Nov 7, 2019 · Databases

How to Automate MySQL & MariaDB Backups on Jelastic PaaS

This guide explains how to create automated backup plans for MySQL and MariaDB databases on Jelastic PaaS, covering script configuration, cron scheduling, remote storage options, and restoring backups through phpMyAdmin, ensuring data safety and easy recovery.

DatabaseJelasticMariaDB
0 likes · 7 min read
How to Automate MySQL & MariaDB Backups on Jelastic PaaS
Java Backend Technology
Java Backend Technology
Nov 2, 2019 · Databases

How Indexes Can Slash MySQL Query Time from Hours to Milliseconds

This article walks through a MySQL 5.6 scenario where a nested subquery to find students scoring 100 in Chinese runs for over 30,000 seconds, then demonstrates how adding single‑column and multi‑column indexes, analyzing execution plans, and applying join optimizations can reduce the runtime to milliseconds, while also covering best practices for index design and query tuning.

Query PlanSQL performancedatabase indexing
0 likes · 9 min read
How Indexes Can Slash MySQL Query Time from Hours to Milliseconds
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 1, 2019 · Databases

Understanding MySQL join_buffer_size and Join Algorithms (Nested Loop, Block Nested Loop, Hash Join)

This article explains the purpose and configuration of MySQL's join_buffer_size for INNER JOIN operations without indexed join keys, compares Nested Loop, Block Nested Loop, and the newly introduced Hash Join algorithms, and shows how each affects execution plans and query performance.

Nested Loopblock nested loopjoin_buffer_size
0 likes · 8 min read
Understanding MySQL join_buffer_size and Join Algorithms (Nested Loop, Block Nested Loop, Hash Join)
Tech Musings
Tech Musings
Oct 31, 2019 · Databases

Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More

This guide explores advanced MySQL techniques—including ON DUPLICATE KEY UPDATE for upserts, INSERT IGNORE to bypass errors, replacing subqueries with JOINs, handling LEFT JOIN pitfalls, efficient pagination strategies, multi‑table UPDATE/DELETE via JOIN, and the nuances of COUNT(*) versus COUNT(1).

COUNTDatabase OptimizationJoin
0 likes · 12 min read
Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 30, 2019 · Databases

Monitoring MySQL Response Time (RT) with tcprstat and Query Response Time Plugin

This article explains the concept of response time (RT) for MySQL queries, illustrates how network delays and server load affect RT, and provides two practical monitoring methods—using Percona's tcprstat tool and the MySQL Query Response Time plugin—along with installation commands, sample outputs, and visualization tips.

Query Response Time PluginResponse Timemysql
0 likes · 8 min read
Monitoring MySQL Response Time (RT) with tcprstat and Query Response Time Plugin
dbaplus Community
dbaplus Community
Oct 27, 2019 · Databases

How to Build a Real‑Time MySQL Data Sync Platform with Alibaba Otter

This guide explains how to create a production‑grade, near‑real‑time MySQL data‑synchronisation and query platform using Alibaba's open‑source Otter middleware, covering architecture, key features, installation steps, configuration of manager and node components, and best practices for safe query operations.

Database AdministrationLinuxOtter
0 likes · 13 min read
How to Build a Real‑Time MySQL Data Sync Platform with Alibaba Otter
Architect's Tech Stack
Architect's Tech Stack
Oct 27, 2019 · Databases

Optimizing MySQL Inserts with Multithreading, Prepared Statements, Batch and Transaction Techniques

This article explains how multithreaded inserts, prepared statements, multi‑value SQL, and batch transaction commits can dramatically improve MySQL insert performance by reducing connection overhead, parsing time, and network I/O, achieving insertion of 100 000 rows in roughly ten seconds.

Batch InsertPerformance OptimizationPreparedStatement
0 likes · 5 min read
Optimizing MySQL Inserts with Multithreading, Prepared Statements, Batch and Transaction Techniques
21CTO
21CTO
Oct 26, 2019 · Databases

How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB

This article details the challenges and solutions encountered when migrating Fengchao's high‑throughput payment platform—handling over a hundred‑billion rows and millions of QPS—from a sharded MySQL architecture to TiDB, covering performance bottlenecks, TiDB advantages, migration steps, tooling, pitfalls, and optimization recommendations.

TiDBdatabase migrationdistributed database
0 likes · 20 min read
How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 26, 2019 · Databases

Weekly Community Update: DBLE Distributed Middleware, MySQL Performance Insights, and Upcoming Events

This weekly community newsletter highlights the open‑source launch of the TXLE distributed transaction framework, DBLE user meetups, deep dives into MySQL slow‑query analysis and EXPLAIN ANALYZE, recent DBLE feature developments, bug fixes, community Q&A, and a preview of next week's technical plans.

CommunityDBLEPerformance
0 likes · 3 min read
Weekly Community Update: DBLE Distributed Middleware, MySQL Performance Insights, and Upcoming Events
ITPUB
ITPUB
Oct 23, 2019 · Databases

Master MySQL Locks and Transactions: A Deep Dive into Concurrency Control

This article systematically explains MySQL's logical server architecture, the various lock types (shared, exclusive, intention, record, gap, next‑key, insert‑intention, AUTO‑INC), transaction fundamentals, isolation levels, MVCC mechanics, and practical deadlock detection and avoidance techniques, complete with real‑world SQL examples.

Isolation LevelsLocksMVCC
0 likes · 23 min read
Master MySQL Locks and Transactions: A Deep Dive into Concurrency Control
FunTester
FunTester
Oct 22, 2019 · Backend Development

How to Scrape 7.2 Million Historical Weather Records with Groovy

This article explains how to use a Groovy script to crawl over 7 million historical weather entries for 3,200 cities spanning 2011‑2019, process the JSON responses, and store the cleaned data into a MySQL table, while sharing practical tips and code snippets.

GroovyJavaWeather Data
0 likes · 7 min read
How to Scrape 7.2 Million Historical Weather Records with Groovy
Ziru Technology
Ziru Technology
Oct 21, 2019 · Databases

Why MySQL Indexes Aren’t Always Faster: Models, Types, and Common Pitfalls

Understanding MySQL indexes—from hash tables, ordered arrays, and B+ trees—to their practical use cases, including clustered and secondary indexes, reveals why they boost query speed, when they may hinder performance, and how factors like selectivity, dirty page flushing, type mismatches, and function usage affect query efficiency.

B+TreeSQL optimizationindexing
0 likes · 10 min read
Why MySQL Indexes Aren’t Always Faster: Models, Types, and Common Pitfalls
dbaplus Community
dbaplus Community
Oct 20, 2019 · Databases

How to Migrate Legacy Systems to a Distributed MySQL Architecture: 8 Practical Strategies

This article walks through the complete evolution of a legacy monolithic database system to a distributed MySQL architecture, covering background analysis, four migration phases, eight concrete strategies—including functional transfer, system splitting, horizontal scaling, read/write separation, and performance tuning—while providing code examples, benchmark results, and deployment considerations.

Schema Refactoringdistributed architecturehigh availability
0 likes · 18 min read
How to Migrate Legacy Systems to a Distributed MySQL Architecture: 8 Practical Strategies
FunTester
FunTester
Oct 19, 2019 · Backend Development

Building a Fast Historical‑Today Crawler with Java and MySQL

An open‑source Java crawler that fetches historical‑today events from a public API is presented, detailing three practical challenges—GET request length limits, ambiguous JSON value types, and month string construction—along with a full code example and a GitHub repository link for reference.

Data ExtractionGitHubHTTP
0 likes · 5 min read
Building a Fast Historical‑Today Crawler with Java and MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 18, 2019 · Databases

Enabling Privilege Checks for MySQL Replication Threads

This article explains how MySQL 8.0.18 introduced privilege checking for replication applier threads, outlines the three-step process to create a restricted‑privilege user, assign necessary permissions or roles, associate the user with the CHANGE MASTER TO statement, and discusses observability and important considerations.

Database AdministrationPrivilege Checksmysql
0 likes · 11 min read
Enabling Privilege Checks for MySQL Replication Threads
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 17, 2019 · Databases

Understanding MySQL Slave Net Timeout, Master Heartbeat Period, and Their Impact on Relay Log Accumulation

The article analyzes a MySQL replication issue where a low slave_net_timeout combined with a larger MASTER_HEARTBEAT_PERIOD causes frequent zombie dump threads, leading to massive small relay‑log files, and provides detailed explanations, code references, and step‑by‑step remediation procedures.

HeartbeatTroubleshootingdatabases
0 likes · 14 min read
Understanding MySQL Slave Net Timeout, Master Heartbeat Period, and Their Impact on Relay Log Accumulation
ITPUB
ITPUB
Oct 15, 2019 · Databases

Understanding B‑Tree Indexes Across Major Relational Databases

This article explains why database indexes are crucial for performance, describes the fundamental principles of B‑Tree indexes, and compares how Oracle, MySQL, SQL Server, and PostgreSQL implement and use these indexes, helping developers master SQL optimization across platforms.

B-TreeDatabase IndexesOracle
0 likes · 16 min read
Understanding B‑Tree Indexes Across Major Relational Databases
dbaplus Community
dbaplus Community
Oct 14, 2019 · Databases

Mastering Percona XtraDB Cluster: High Availability, Monitoring, and Backup Strategies

This comprehensive guide explains Galera‑based Percona XtraDB Cluster architecture, high‑availability mechanisms, state‑transfer methods, flow‑control, deployment patterns, routine inspection, monitoring variables, backup management, common failure scenarios, and real‑world case studies for MySQL clusters.

GaleraPercona XtraDB ClusterTroubleshooting
0 likes · 36 min read
Mastering Percona XtraDB Cluster: High Availability, Monitoring, and Backup Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 14, 2019 · Databases

Analyzing MySQL InnoDB Thread Concurrency Issues and Their Resolution

This article examines a MySQL performance problem where frequent requests become unresponsive, analyzes processlist, system I/O/CPU metrics, and pstack traces to identify InnoDB thread concurrency and concurrency tickets as the root cause, then explains the relevant parameters, configuration guidelines, and a simulated test to demonstrate the solution.

DebuggingInnoDBSQL
0 likes · 25 min read
Analyzing MySQL InnoDB Thread Concurrency Issues and Their Resolution
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 12, 2019 · Databases

Weekly Community Summary: DB‑Engines Ranking, Archery v1.7.0 Release, DBLE Weekly Report and DTLE Updates

This weekly community digest presents the latest DB‑Engines October ranking with MSSQL’s rebound, the Archery v1.7.0 release enhancing MySQL account management, DBLE’s new features, bug fixes and community Q&A, plus DTLE’s performance improvements and upcoming roadmap, all accompanied by relevant links and images.

DBLEDTLEdatabases
0 likes · 5 min read
Weekly Community Summary: DB‑Engines Ranking, Archery v1.7.0 Release, DBLE Weekly Report and DTLE Updates
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 12, 2019 · Databases

How to Locate and Analyze Slow SQL Queries in MySQL

This article explains how to identify slow MySQL queries using the slow‑query log and SHOW PROCESSLIST, then demonstrates how to analyze their execution plans with EXPLAIN, covering key fields, common values, and practical examples for effective performance optimization.

DatabasePerformance Optimizationmysql
0 likes · 13 min read
How to Locate and Analyze Slow SQL Queries in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 11, 2019 · Databases

Persisting MySQL 8.0 Configuration with SET PERSIST and SET PERSIST_ONLY

This article explains how MySQL 8.0 introduces the SET PERSIST and SET PERSIST_ONLY statements to modify configuration variables dynamically and persist them across restarts, demonstrates usage with both dynamic and static parameters, shows the generated mysqld-auto.cnf file, discusses required privileges, and illustrates how to query persisted settings via performance_schema tables.

SET PERSISTmysqlperformance_schema
0 likes · 10 min read
Persisting MySQL 8.0 Configuration with SET PERSIST and SET PERSIST_ONLY
Java Captain
Java Captain
Oct 11, 2019 · Databases

MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning

This article introduces MySQL fundamentals, covering logical architecture, locking, transactions, storage engines, schema and data type design, as well as index types and their constraints, plus practical creation‑time and query‑time optimization techniques with code examples and best‑practice recommendations.

Database OptimizationQuery TuningTransactions
0 likes · 11 min read
MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning
Programmer DD
Programmer DD
Oct 11, 2019 · Databases

Understanding MySQL Transaction Isolation Levels: ACID, Tests, and Practical Guide

This article explains the concept of database transactions, the ACID properties, details MySQL’s four isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—and provides step‑by‑step command‑line experiments demonstrating phenomena such as dirty reads, non‑repeatable reads, phantom reads, and serialization effects.

ACIDIsolation LevelSQL
0 likes · 9 min read
Understanding MySQL Transaction Isolation Levels: ACID, Tests, and Practical Guide
ITPUB
ITPUB
Oct 10, 2019 · Databases

Why MySQL’s “utf8” Isn’t Real UTF‑8 and How to Switch to utf8mb4

The article explains that MySQL’s legacy “utf8” charset only supports three‑byte characters, causing errors when storing true four‑byte UTF‑8 symbols like emojis, and shows why switching to the proper “utf8mb4” charset is essential for correct Unicode handling.

Character SetEncodingMariaDB
0 likes · 8 min read
Why MySQL’s “utf8” Isn’t Real UTF‑8 and How to Switch to utf8mb4
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 9, 2019 · Databases

Guide to MySQL InnoDB Tablespace Encryption: Overview, Configuration, Key Management, Import/Export, Backup and Restore

This article provides a comprehensive guide to MySQL InnoDB tablespace encryption, covering its architecture, supported plugins, configuration steps, key rotation, limitations, encrypted table operations, import/export procedures, and backup/restore methods using mysqlbackup and innobackupex.

InnoDBRestoreSQL
0 likes · 17 min read
Guide to MySQL InnoDB Tablespace Encryption: Overview, Configuration, Key Management, Import/Export, Backup and Restore
FunTester
FunTester
Oct 9, 2019 · Backend Development

How to Build a Java/Groovy Web Crawler with Regex and MySQL Storage

This article demonstrates a Java‑based web crawler written in Groovy that uses regular‑expression parsing to retrieve paginated company data from a government portal, constructs SQL insert statements, and stores the results in MySQL, with full source code and structural screenshots.

Data ExtractionGroovyJava
0 likes · 6 min read
How to Build a Java/Groovy Web Crawler with Regex and MySQL Storage
FunTester
FunTester
Sep 28, 2019 · Backend Development

When VIP Expiration Hits 2038: Uncovering MySQL INT Overflow

A bug was discovered where a user's VIP expiration date could not extend beyond a specific day in 2038 because the timestamp was stored in a signed INT column, whose maximum value (2147483647) corresponds to 2038‑01‑19 11:14:07, causing the system to fail to save later dates.

DatabaseINT overflowVIP expiration
0 likes · 3 min read
When VIP Expiration Hits 2038: Uncovering MySQL INT Overflow
NetEase Game Operations Platform
NetEase Game Operations Platform
Sep 28, 2019 · Databases

Introducing mycli: A Feature‑Rich MySQL Command‑Line Client

This article introduces mycli, a Python‑based MySQL command‑line client that offers easy installation via pip, advanced auto‑completion, high‑risk operation confirmations, customizable syntax highlighting, output paging, command bookmarking, logging, multiline editing, flexible credential handling, and additional features such as SSL support and query looping.

Command LineDatabase ToolsMyCLI
0 likes · 9 min read
Introducing mycli: A Feature‑Rich MySQL Command‑Line Client
Programmer DD
Programmer DD
Sep 27, 2019 · Databases

How to Use MySQL User Variables for Cumulative Daily User Counts

This article explains how to calculate cumulative daily user totals in MySQL using user-defined variables, demonstrates the necessary SQL queries, compares them with a Java‑style algorithm, and highlights important considerations such as variable initialization and practical pitfalls.

DatabaseSQLcumulative sum
0 likes · 6 min read
How to Use MySQL User Variables for Cumulative Daily User Counts
dbaplus Community
dbaplus Community
Sep 25, 2019 · Databases

Master MySQL Backup & Disaster Recovery: Strategies, Tools, and Automation

Effective MySQL backup and disaster recovery are essential for protecting critical business data; this guide explains backup types, tools like Percona XtraBackup, scheduling, local and remote strategies, incremental processes, preparation and restoration steps, and introduces a platform for automated backup management.

Database Managementautomationbackup
0 likes · 26 min read
Master MySQL Backup & Disaster Recovery: Strategies, Tools, and Automation
DevOps Cloud Academy
DevOps Cloud Academy
Sep 25, 2019 · Databases

How to Connect MySQL and Oracle Databases with JMeter

This guide walks through configuring JMeter to connect to MySQL and Oracle databases via JDBC, covering driver installation, JMeter component setup, request creation, result verification, and troubleshooting common connection errors for performance testing.

Database ConnectionJDBCJMeter
0 likes · 4 min read
How to Connect MySQL and Oracle Databases with JMeter
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 25, 2019 · Databases

MySQL Replication FAQ: Compatibility, Master‑Slave Behavior, Performance, and High‑Availability

This article provides a comprehensive MySQL replication FAQ covering cross‑OS and hardware compatibility, master‑slave connection behavior, monitoring lag, forcing master pause, bidirectional replication considerations, performance improvements, high‑availability setups, and how to exclude GRANT/REVOKE statements from replication.

DatabaseMaster‑SlavePerformance
0 likes · 10 min read
MySQL Replication FAQ: Compatibility, Master‑Slave Behavior, Performance, and High‑Availability
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2019 · Databases

Using MySQL Shell Util import_table and import_json for Fast Data Import

This article demonstrates how to use MySQL Shell's util.import_table and util.import_json functions to import CSV and JSON data efficiently, compares their performance with the traditional mysqlimport tool, explains required options such as file path, schema, table, dialect, threading, and shows example sessions in both JavaScript and Python modes.

PerformanceShelldata import
0 likes · 11 min read
Using MySQL Shell Util import_table and import_json for Fast Data Import
Programmer DD
Programmer DD
Sep 23, 2019 · Databases

Why Multi‑Threaded Inserts Outperform Single Thread in MySQL

This article explains how multithreaded inserts into a MySQL table can be faster than single‑threaded inserts by reducing connection and parsing overhead, and it details techniques such as prepared statements, multi‑value inserts, and batch transaction commits to boost performance.

Batch InsertPerformancePrepared Statements
0 likes · 5 min read
Why Multi‑Threaded Inserts Outperform Single Thread in MySQL
ITPUB
ITPUB
Sep 19, 2019 · Databases

Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE

MySQL 8.0 introduces Hash Join for dramatically faster large‑dataset queries, supports in‑memory and spill‑to‑disk processing, can replace Block Nested‑Loop joins, and adds EXPLAIN ANALYZE with detailed runtime statistics and tree‑style output, highlighting the platform’s rapid evolution.

Database PerformanceEXPLAIN ANALYZEHash Join
0 likes · 3 min read
Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 19, 2019 · Databases

Debugging MySQL Threads and LWP IDs with GDB: Building a Debug Environment and Analyzing Thread IDs

This article explains MySQL thread fundamentals, distinguishes PID, LWP ID and Thread TID, shows a small C program to observe these IDs, demonstrates how to map MySQL threads to LWP IDs using system tools and SQL, and provides a step‑by‑step guide to set up a GDB‑based debugging environment on Linux.

LWPPerformanceThread Debugging
0 likes · 16 min read
Debugging MySQL Threads and LWP IDs with GDB: Building a Debug Environment and Analyzing Thread IDs
macrozheng
macrozheng
Sep 19, 2019 · Backend Development

Mastering Distributed ID Generation: From MySQL Auto‑Increment to Snowflake

This article reviews various distributed ID generation strategies—including MySQL auto‑increment tables, multi‑master configurations, segment allocation, Snowflake algorithm, and open‑source solutions like Baidu uid‑generator and Meituan Leaf—highlighting their designs, trade‑offs, and implementation details for high‑performance backend systems.

distributed-idmysqlsegment allocation
0 likes · 13 min read
Mastering Distributed ID Generation: From MySQL Auto‑Increment to Snowflake
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 17, 2019 · Databases

Using gh-ost for Online Schema Changes in MySQL: Introduction, Usage, Parameters, and Comparison with pt-osc

This article introduces the gh-ost tool for performing online schema changes on large MySQL tables, explains its architecture and operation modes, provides detailed command‑line parameters and practical examples, and compares its features and performance with the traditional pt‑osc solution.

DDLOnline Schema Changegh-ost
0 likes · 18 min read
Using gh-ost for Online Schema Changes in MySQL: Introduction, Usage, Parameters, and Comparison with pt-osc
FunTester
FunTester
Sep 17, 2019 · Backend Development

Visualizing API Response Times with Python Plotly Violin Charts

The author records API request durations in a MySQL table, then uses Python, pandas, and Plotly to fetch the data, filter out outliers, and generate a violin chart that clearly visualizes the distribution of response times for multiple endpoints.

API testingdata-visualizationmysql
0 likes · 4 min read
Visualizing API Response Times with Python Plotly Violin Charts
Programmer DD
Programmer DD
Sep 16, 2019 · Databases

Why MySQL DATETIME Misses Milliseconds: Connector Bugs and Practical Fixes

This article explores common MySQL DATETIME timestamp precision issues caused by mismatched mysql‑connector‑java and server versions, demonstrates three practical solutions, and provides a step‑by‑step case study with code examples to help developers choose the right time field type and avoid timezone pitfalls.

JavaTimezonemysql
0 likes · 7 min read
Why MySQL DATETIME Misses Milliseconds: Connector Bugs and Practical Fixes
FunTester
FunTester
Sep 15, 2019 · Backend Development

How to Build a Java HttpClient Spider for Scraping Movie Details and Download Links

This article explains how to update and use a Java HttpClient‑based spider that removes duplicate links, handles legacy page formats, extracts movie metadata and download URLs (magnet, ed2k, Baidu Pan), and stores the results in a MySQL database, with complete source code examples.

Data ExtractionHttpClientJava
0 likes · 12 min read
How to Build a Java HttpClient Spider for Scraping Movie Details and Download Links
Architect's Tech Stack
Architect's Tech Stack
Sep 13, 2019 · Databases

MySQL Query Optimization: Indexing, Subqueries, and Join Strategies

This article demonstrates how to dramatically improve MySQL query performance by analyzing execution plans, adding appropriate single‑column and composite indexes, converting slow subqueries to efficient joins, and applying covering indexes and ordering optimizations, with detailed examples and timing results.

SQL optimizationindexingmysql
0 likes · 12 min read
MySQL Query Optimization: Indexing, Subqueries, and Join Strategies
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 13, 2019 · Backend Development

Comprehensive Java Interview Topics: Language Basics, Collections, Concurrency, JVM, Design Patterns, MySQL, and Netty

This article compiles essential Java interview questions covering language fundamentals, core APIs, collections, concurrency mechanisms, JVM internals, design patterns, database concepts, and Netty networking, providing a thorough reference for candidates preparing for backend development positions.

Backend DevelopmentDesign PatternsInterview preparation
0 likes · 12 min read
Comprehensive Java Interview Topics: Language Basics, Collections, Concurrency, JVM, Design Patterns, MySQL, and Netty
21CTO
21CTO
Sep 8, 2019 · Databases

Master MySQL Optimization: Proven Strategies for High Performance and Stability

This comprehensive guide walks you through MySQL optimization philosophy, risk management, stakeholder involvement, practical tools, hardware and system tuning, kernel parameter adjustments, and detailed MySQL configuration tweaks to achieve both performance gains and reliable stability in production environments.

Database OptimizationLinuxPerformance tuning
0 likes · 18 min read
Master MySQL Optimization: Proven Strategies for High Performance and Stability
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 7, 2019 · Databases

Weekly MySQL Community Digest: Industry Trends, Free Mycat Diagnosis, DBLE & DTLE Updates, and Original Technical Articles

This weekly MySQL community newsletter highlights September 2019 DB‑Engines rankings, offers free Mycat diagnosis, summarizes DBLE and DTLE development updates, and showcases original technical articles on WRITESET parallel replication, InnoDB primary‑key optimization, MySQL 8.0 error‑log enhancements, and query optimization, inviting community feedback.

CommunityDBLEDTLE
0 likes · 5 min read
Weekly MySQL Community Digest: Industry Trends, Free Mycat Diagnosis, DBLE & DTLE Updates, and Original Technical Articles
Ziru Technology
Ziru Technology
Sep 6, 2019 · Backend Development

How Alibaba Canal Enables Real-Time MySQL Binlog Replication and Incremental Data Sync

Canal, an open‑source Alibaba project, mimics MySQL slave behavior to subscribe to binlog events, parses them, and supports both standalone and ZooKeeper‑coordinated cluster deployments, offering flexible state storage, message processing pipelines, and integration options such as TCP, Kafka, and RocketMQ for real‑time data synchronization.

CanalJavabinlog
0 likes · 11 min read
How Alibaba Canal Enables Real-Time MySQL Binlog Replication and Incremental Data Sync
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 6, 2019 · Databases

Setting Up MySQL 8.0 to MySQL 5.7 Replication

This guide explains how to configure replication from a MySQL 8.0 master to a MySQL 5.7 slave, covering supported version combinations, character‑set adjustments, authentication plugin changes, user creation, CHANGE MASTER commands, status verification, quick testing, and common pitfalls when using newer MySQL features.

DatabaseMySQL5.7MySQL8
0 likes · 7 min read
Setting Up MySQL 8.0 to MySQL 5.7 Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 5, 2019 · Databases

Using MySQL 8.0 JSON Error Log Output and Filtering

MySQL 8.0 adds JSON‑formatted error logs and flexible filtering components, allowing administrators to install JSON sink and filter modules, extract specific fields with tools like jq, and apply rules that drop or throttle messages to improve log readability and automation.

Database AdministrationJSONLog Filtering
0 likes · 9 min read
Using MySQL 8.0 JSON Error Log Output and Filtering
Java Captain
Java Captain
Sep 5, 2019 · Databases

MySQL Optimization and Best Practices: Indexing, Partitioning, Replication, and Performance Tuning

This article provides a comprehensive guide to MySQL performance optimization, covering database design principles, field type selection, indexing strategies, storage engine choices, query caching, partitioning methods, master‑slave replication setup, read/write splitting, load balancing, and profiling tools for diagnosing slow queries.

OptimizationPartitioningindexing
0 likes · 43 min read
MySQL Optimization and Best Practices: Indexing, Partitioning, Replication, and Performance Tuning
JD Tech Talk
JD Tech Talk
Sep 5, 2019 · Information Security

Comprehensive Solution for Data Masking with Apache ShardingSphere (Part 2)

This article explains how to use Apache ShardingSphere's data‑masking (encryption) features to protect both new and existing MySQL/Oracle/PostgreSQL/SQLServer workloads, providing detailed YAML configurations, migration steps, advantages, applicable scenarios, and limitations for secure database operations.

Encrypt-JDBCShardingSphereYAML
0 likes · 12 min read
Comprehensive Solution for Data Masking with Apache ShardingSphere (Part 2)
dbaplus Community
dbaplus Community
Sep 3, 2019 · Backend Development

How We Built Real-Time MySQL-to-Elasticsearch Sync with Binlog and Kafka

To meet growing e‑commerce search demands, the team replaced a MySQL‑based intermediate table with a real‑time binlog‑driven pipeline that streams changes through Kafka into Elasticsearch, detailing design choices, ordering and completeness guarantees, custom modules, and monitoring for sub‑second sync latency.

ElasticsearchKafkabinlog
0 likes · 13 min read
How We Built Real-Time MySQL-to-Elasticsearch Sync with Binlog and Kafka