DatabaseReplication

Aikesheng Open Source Community

Mar 2, 2020 · Databases

Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router

This tutorial explains how to create and operate a MySQL InnoDB ReplicaSet—deploying sandbox instances, configuring a replica set with primary and secondary roles, adding nodes, performing manual primary switches and failure recovery, and using MySQL Router to provide an automatic read/write endpoint, while highlighting current limitations.

DatabaseReplicationGTIDInnoDB

0 likes · 8 min read

Guide to Deploying and Managing MySQL InnoDB ReplicaSet with MySQL Shell and Router

Full-Stack Internet Architecture

Jun 28, 2019 · Databases

Implementing Read/Write Splitting with ShardingSphere in a Spring Boot Application

This article explains how to implement database read‑write splitting in a Spring Boot application using ShardingSphere, covering the creation of master‑slave MySQL databases, Maven dependency setup, multi‑data‑source configuration, load‑balance algorithms, and handling replication lag with HintManager.

DatabaseReplicationJdbcTemplateMySQL

0 likes · 8 min read

Implementing Read/Write Splitting with ShardingSphere in a Spring Boot Application