Discover | BestHub

Quick starts observability golang platform engineering distributed systems raft kubernetes

Results

Matches for “mysql”

1000 results

Databases Apr 11, 2025 Cognitive Technology Team

Understanding MySQL Concurrency: Read/Write Conflicts, MVCC, and Locking Strategies

This article explains MySQL's three concurrency types—read‑read, read‑write, and write‑write—describes how InnoDB uses MVCC, shared and exclusive locks, and provides practical examples and code for handling update‑loss and write‑write conflicts with optimistic and pessimistic locking.

DatabaseConcurrencyMySQLLockingOptimistic LockTransaction IsolationPessimistic LockMVCC

Information Security Apr 10, 2025 Aikesheng Open Source Community

Securing MySQL Connections: SSL/TLS, Password Plugins, and Authentication

This article explains how to protect MySQL connections by using SSL/TLS, various password authentication plugins, digital signatures, and client/server certificate verification to prevent impersonation, password leakage, and data tampering.

MySQLSecurityAuthenticationTLSSSLPassword Plugin

Databases Apr 10, 2025 IT Services Circle

Choosing the Right Date/Time Storage Type in MySQL: DATETIME vs TIMESTAMP vs Unix Timestamp

This article explains why storing dates as strings is problematic, compares MySQL's DATETIME and TIMESTAMP types—including their storage size, range, and timezone behavior—provides practical SQL examples, discusses numeric Unix timestamps, and offers guidance on selecting the most suitable type for different scenarios.

performancedatabaseMySQLdatetimetimestamptimezoneUnix timestamp

Databases Apr 10, 2025 Lobster Programming

Why Does MySQL Use Two-Phase Commit? Understanding Redo Log and Binlog Coordination

MySQL employs a two‑phase commit to synchronize InnoDB’s redo log with the server’s binlog, ensuring atomicity during transaction commits and preventing data inconsistencies during crash recovery or replication, while also introducing lock contention, extra I/O, and potential blocking.

TransactionMySQLBinlogTwo-Phase CommitRedo LogDatabase Consistency

Databases Apr 9, 2025 Raymond Ops

Step-by-Step Guide to Installing MySQL 5.7 on ARM (Aarch64) Linux

This tutorial walks you through checking the OS architecture, preparing the environment, downloading and extracting the MySQL 5.7 ARM package, configuring my.cnf, setting up auto‑start and environment variables, initializing the server, securing the root account, and configuring master‑slave replication on Linux.

DatabaseLinuxMySQLReplicationInstallationARMAarch64

Databases Apr 9, 2025 Aikesheng Open Source Community

Understanding MySQL EXPLAIN Output Formats and Using JSON for Detailed Query Cost Analysis

This article explains the three MySQL EXPLAIN output formats—TRADITIONAL, JSON, and TREE—demonstrates how the JSON format provides richer cost and data‑read information, compares query costs of sample SQL statements, and offers practical optimization suggestions for poorly performing joins.

Query OptimizationJSONMySQLEXPLAINDatabase Performance

Databases Apr 9, 2025 Java Tech Enthusiast

MySQL vs PostgreSQL Performance Benchmark: Latency, Throughput, and Saturation

The benchmark comparing MySQL 9.0 and PostgreSQL 17.0 shows PostgreSQL consistently achieving lower insertion latency, roughly double the throughput (≈19 k QPS vs 10 k QPS), using less CPU, memory and disk I/O, while both hit an 80‑connection pool limit and PostgreSQL maintains stable read latency as MySQL’s performance degrades beyond ~5.5 k QPS.

DatabasePerformance BenchmarkLatencyMySQLPostgreSQLSaturationThroughput

Backend Development Apr 9, 2025 Java Captain

Implementing Dynamic MySQL Master‑Slave Data Source Switching in SpringBoot with AOP and Custom Annotations

This tutorial explains how to use SpringBoot, AOP, and a custom @DataSource annotation to dynamically switch between MySQL master and slave databases—covering configuration, code implementation, multiple slave handling, and an Oracle example—to ensure high availability and flexible data source management.

JavaAOPMySQLMaster‑SlaveSpringBootMulti‑DataSourceDynamic DataSource

Databases Apr 8, 2025 Aikesheng Open Source Community

Using MySQL Flashback Tools to Roll Back DML Mistakes

This article explains how to use MySQL flashback utilities such as binlog2sql, my2sql, and MyFlash to recover from accidental DML operations, covering supported SQL types, required binlog settings, tool features, command‑line usage examples, and best‑practice recommendations for preventing future data loss.

MySQLBinlogData RecoveryFlashbackDMLmy2sqlMyFlash

Databases Apr 8, 2025 Java Tech Enthusiast

Choosing the Right Date/Time Storage Type in MySQL and PostgreSQL

Choosing the proper MySQL or PostgreSQL date/time column—avoiding string types, understanding DATETIME’s literal storage versus TIMESTAMP’s automatic UTC conversion, considering PostgreSQL’s TIMESTAMP WITH/WITHOUT TIME ZONE equivalents, and weighing numeric Unix timestamps for speed—ensures correct time‑zone handling, storage efficiency, and future‑proof range.

DatabaseMySQLDatetimeTimestampPostgreSQLTimezones

Previous Page 12 Next