Discover | BestHub

Quick starts observability platform engineering golang distributed systems kubernetes raft

Results

Matches for “mysql”

1000 results

Databases Mar 24, 2025 Top Architect

Data Synchronization Strategies Between MySQL and Elasticsearch

This article explains why MySQL alone struggles with large‑scale queries, introduces Elasticsearch for read‑write separation, and compares several synchronization methods—including synchronous and asynchronous dual‑write, Logstash, binlog, Canal, and Alibaba DTS—detailing their advantages, drawbacks, and typical use cases, followed by promotional offers.

ElasticsearchMySQLCanalData SynchronizationDTSLogstash

Databases Mar 24, 2025 Cognitive Technology Team

Understanding MySQL Replication: Architecture, Binlog Formats, Use Cases, and Best Practices

This article explains MySQL's replication mechanism, detailing master‑slave architecture, key threads, binlog formats (statement, row, mixed), common application scenarios such as backup, read/write splitting, and data migration, and highlights important considerations like network latency, consistency, delay, and security.

ScalabilitydatabaseHigh AvailabilityMySQLReplication

Databases Mar 24, 2025 IT Xianyu

Comparison of Oracle, PostgreSQL, and MySQL: Features, Installation, and Basic Operations

This article compares Oracle, PostgreSQL, and MySQL across core features, typical use cases, transaction support, storage engines, licensing, provides simplified installation steps, demonstrates basic SQL operations such as creating tables, inserting and querying data, and highlights key differences like auto‑increment handling and string‑matching functions.

SQLMySQLPostgreSQLInstallationOracleDatabase Comparison

Databases Mar 24, 2025 Java Architect Essentials

Why MySQL Discourages UUID as Primary Key: Performance Comparison with Auto‑Increment and Random Keys

This article investigates MySQL's recommendation against using UUIDs or non‑sequential keys as primary keys by creating three tables, benchmarking insert and query speeds with Spring Boot/JdbcTemplate, analyzing index structures, and discussing the trade‑offs of auto‑increment, UUID, and random long keys.

performanceindexingMySQLdatabase designauto_incrementUUID

Databases Mar 23, 2025 Java Tech Enthusiast

MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Joins and More

The article shows how common MySQL performance pitfalls—such as large LIMIT offsets, implicit type conversions, sub‑query‑based updates or deletes, mixed ORDER BY, EXISTS clauses, and misplaced predicates—can be rewritten into index‑friendly forms using filters, joins, early limits, UNION ALL, and CTEs to achieve execution times that drop from seconds to milliseconds.

MySQLIndexesJOINLIMITQuery PerformanceSQL Optimization

Backend Development Mar 23, 2025 Architecture Digest

Implementing Dynamic MySQL Master‑Slave Switching in SpringBoot Using AOP and Custom Annotations

This article explains how to use SpringBoot, AOP, and a custom @DataSource annotation to dynamically switch between MySQL master and slave databases, automatically falling back to the master when a slave fails, thereby achieving high availability for backend services.

JavaAOPMySQLSpringBootDynamic DataSource

Databases Mar 22, 2025 Java Captain

Performance Comparison of UUID, Auto‑Increment, and Random Keys in MySQL

This article investigates MySQL's recommendation against using UUID or random Snowflake IDs as primary keys by creating three tables with different key strategies, running Spring Boot/JDBC performance tests, analyzing index structures, and concluding that auto‑increment keys offer superior insertion efficiency and fewer drawbacks.

PerformanceSpring BootMySQLJDBCAuto IncrementUUIDDatabase Index

Databases Mar 20, 2025 Aikesheng Open Source Community

How to Interpret the rows Value in MySQL EXPLAIN Output

This article explains what the rows column in MySQL EXPLAIN means, demonstrates three situations—when a small rows value indicates good performance, when it does not, and when rows is misleading—using concrete SQL examples, force‑index tricks, and multi‑table join analyses to show why rows alone cannot reliably judge query efficiency.

query optimizationMySQLindexesEXPLAINSQL performancerows

Databases Mar 19, 2025 Aikesheng Open Source Community

Why MySQL 5.7 Seconds_Behind_Master Is Unreliable and How pt‑heartbeat Provides Accurate Replication Lag Measurement

The article explains why the built‑in MySQL 5.7 Seconds_Behind_Master metric often misrepresents replication delay, analyzes its design flaws, and demonstrates how the Percona Toolkit's pt‑heartbeat tool can reliably measure master‑slave lag with real‑time precision.

PerformanceMySQLReplicationDatabase MonitoringSeconds_Behind_Masterpt-heartbeat

Databases Mar 18, 2025 Top Architect

Data Synchronization Strategies Between MySQL and Elasticsearch

The article outlines multiple approaches for synchronizing MySQL data to Elasticsearch—including synchronous and asynchronous dual‑write, Logstash pipelines, binlog real‑time sync, Canal, and Alibaba Cloud DTS—while also promoting related AI products and community services.

ElasticsearchMySQLCanalData SynchronizationAlibaba CloudLogstash

Previous Page 16 Next