Tag

DatabaseOptimization

0 views collected around this technical thread.

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

Top Architect

Apr 7, 2023 · Databases

MySQL Performance Optimization Guidelines from a Senior Architect

This article presents a senior architect’s comprehensive MySQL optimization guide, covering execution process, naming conventions, storage engine choices, indexing strategies, query writing best practices, transaction handling, partitioning, and other performance‑tuning techniques to improve database efficiency and reliability.

DatabaseOptimizationIndexingMySQL

0 likes · 24 min read

MySQL Performance Optimization Guidelines from a Senior Architect