Tag

DatabasePerformance

1 views collected around this technical thread.

Architect's Guide
Architect's Guide
Oct 4, 2024 · Databases

Using MySQL Router 8.2 for Read/Write Splitting with InnoDB ReplicaSet

The article demonstrates how MySQL Router 8.2 enables transparent read/write splitting for an InnoDB ReplicaSet, showing the architecture, configuration steps, connection behavior, and the generated routing settings that improve database performance without modifying application code.

DatabasePerformanceInnoDBReadWriteSplitting
0 likes · 4 min read
Using MySQL Router 8.2 for Read/Write Splitting with InnoDB ReplicaSet
Selected Java Interview Questions
Selected Java Interview Questions
Jul 9, 2024 · Databases

MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet

This article explains how MySQL Router 8.2 enables read/write splitting for an InnoDB ReplicaSet, showing configuration steps, routing behavior, sample code, and the resulting performance and management benefits without requiring application changes.

DatabasePerformanceInnoDBReadWriteSplitting
0 likes · 5 min read
MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 30, 2023 · Databases

MySQL 8.2 Transparent Read/Write Splitting with MySQL Router

MySQL 8.2 introduces transparent read/write splitting via MySQL Router, allowing automatic routing of read traffic to replica instances and write traffic to the primary source without any changes to the application, demonstrated with a simple InnoDB ReplicaSet deployment and configuration examples.

DatabasePerformanceInnoDBReplicaSetReadWriteSplitting
0 likes · 6 min read
MySQL 8.2 Transparent Read/Write Splitting with MySQL Router
IT Services Circle
IT Services Circle
Mar 12, 2022 · Databases

Understanding MySQL Master‑Slave Replication and Read/Write Splitting

This article explains the basics of MySQL master‑slave replication, illustrates how read/write splitting works to alleviate performance bottlenecks, and shares practical test results showing reduced latency on the master and improved overall throughput when directing reads to replica servers.

DatabasePerformanceReadWriteSplittingReplication
0 likes · 4 min read
Understanding MySQL Master‑Slave Replication and Read/Write Splitting
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 26, 2020 · Databases

Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication

This article investigates why the Seconds_Behind_Master metric fluctuates in a dual‑master MySQL setup, explains the underlying replication logic, reproduces the issue, and analyses the handling of ROTATE_EVENT and other binlog events in both parallel and non‑parallel replication modes using source code excerpts.

BinaryLogDatabasePerformanceDebugging
0 likes · 27 min read
Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication
Big Data Technology Architecture
Big Data Technology Architecture
Feb 22, 2020 · Databases

Using HBase PerformanceEvaluation (PE) Tool for Read/Write Latency Benchmarking (P99/P999)

This article explains how to use HBase's built‑in PerformanceEvaluation tool to run baseline read/write latency tests (P99 and P999), describes key command‑line parameters, presents benchmark results for random and sequential operations, and discusses the implications for HBase performance tuning.

BenchmarkDatabasePerformanceHBase
0 likes · 11 min read
Using HBase PerformanceEvaluation (PE) Tool for Read/Write Latency Benchmarking (P99/P999)