How to Implement Automatic MySQL Master‑Slave Switching in SpringBoot with AOP

This article explains how to use SpringBoot, AOP, and a custom annotation to dynamically switch between MySQL master and slave databases, automatically falling back to the master when a slave fails, and covers configuration, code implementation, and multi‑source extensions.

DynamicDataSourceJavaMasterSlave

0 likes · 15 min read

How to Implement Automatic MySQL Master‑Slave Switching in SpringBoot with AOP

Code Ape Tech Column

May 25, 2022 · Databases

Implementing MySQL Read/Write Splitting with Sharding-JDBC Using Docker

This tutorial explains why read/write splitting is useful, shows step‑by‑step how to build a MySQL master‑slave cluster with Docker, configure the master and slave instances, and then use Sharding‑JDBC to transparently route writes to the master and reads to the slave.

DockerMasterSlaveReadWriteSplitting

0 likes · 10 min read

Implementing MySQL Read/Write Splitting with Sharding-JDBC Using Docker