The Dominant Programmer

Feb 20, 2024 · Backend Development

How to Manually Switch Multiple Data Sources (MySQL, SQL Server) in Spring Boot with Dynamic‑Datasource

This guide shows how to configure Spring Boot, MyBatis‑Plus and the dynamic‑datasource starter to connect to MySQL, SQL Server and PostgreSQL, add and remove data sources at runtime, verify their availability, and perform manual switching using a utility class and functional interfaces.