2019獨角獸企業重金招聘Python工程師標準>>>

Netkiller Spring Cloud 手札

Spring Cloud Cookbook

Mr.?Neo?Chan,?陳景峯(BG7NYT)

中國廣東省深圳市望海路半島城邦三期
518067
+86?13113668890

<netkiller@msn.com>

MMDVM Hotspot:?

YSF80337 - CN China 1 - W24166/TG46001
BM_China_46001 - DMR Radio ID 4600441

$Id: book.xml 606 2013-05-29 09:52:58Z netkiller $

版權 ? 2015-2019 Neo Chan

?

版權聲明

轉載請與作者聯系，轉載時請務必標明文章原始出處和作者信息及本聲明。

http://www.netkiller.cn http://netkiller.github.io http://netkiller.sourceforge.net

微信訂閱號 netkiller-ebook (微信掃描二維碼） QQ：13721218 請注明“讀者” QQ群：128659835 請注明“讀者”

5.19.1.?Master / Slave 主從數據庫數據源配置

5.19.1.1.?application.properties

spring.datasource.master.driverClassName = com.mysql.cj.jdbc.Driver spring.datasource.master.url=jdbc:mysql://192.168.1.240:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false spring.datasource.master.username = root spring.datasource.master.password = passwordspring.datasource.slave.driverClassName = com.mysql.cj.jdbc.Driver spring.datasource.slave.url=jdbc:mysql://192.168.1.250:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false spring.datasource.slave.username = root spring.datasource.slave.password = passwordspring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect

5.19.1.2.?配置主從數據源

package cn.netkiller.config;import javax.sql.DataSource;import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Primary; import org.springframework.jdbc.core.JdbcTemplate;@Configuration public class MultiDataSourceConfig {@Bean@Primary@ConfigurationProperties("spring.datasource.master")public DataSourceProperties firstDataSourceProperties() {return new DataSourceProperties();}@Bean("Master")@Primary@ConfigurationProperties("spring.datasource.master")public DataSource firstDataSource() {return firstDataSourceProperties().initializeDataSourceBuilder().build();}@Bean@ConfigurationProperties("spring.datasource.slave")public DataSourceProperties secondDataSourceProperties() {return new DataSourceProperties();}@Bean(name = "Slave")@ConfigurationProperties("spring.datasource.slave")public DataSource secondDataSource() {return secondDataSourceProperties().initializeDataSourceBuilder().build();}@Bean("masterJdbcTemplate")@Primarypublic JdbcTemplate primaryJdbcTemplate(@Qualifier("Master") DataSource Master) {return new JdbcTemplate(Master);}@Bean("slaveJdbcTemplate")public JdbcTemplate secondJdbcTemplate(@Qualifier("Slave") DataSource Master) {return new JdbcTemplate(Master);}}

5.19.1.3.?選擇數據源

// 默認是 Master@Autowiredprivate JdbcTemplate jdbcTemplate;// 或者這樣寫@Qualifier("masterJdbcTemplate")@Autowiredprivate JdbcTemplate masterJdbcTemplate;// 下面是 Slave 數據源@Qualifier("slaveJdbcTemplate")@Autowiredprivate JdbcTemplate slaveJdbcTemplate;

?

?

轉載于:https://my.oschina.net/neochen/blog/3040558

總結

以上是生活随笔為你收集整理的《Netkiller Spring Cloud 手札》之 Master / Slave 主从数据库数据源配置的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。