1.在pom文件中添加如下依赖
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId>
<version>4.1.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.shardingsphere/sharding-jdbc-orchestration -->
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-orchestration</artifactId>
<version>4.1.1</version>
</dependency>
<dependency>
<groupId>io.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>3.0.0</version>
</dependency>
<dependency>
<groupId>com.alibaba.cloud</groupId>
<artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId>
<version>2.1.0.RELEASE</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.14</version>
</dependency>
2.在bootstrap.yaml中添加如下nacos配置
spring:
application:
name: test
cloud:
nacos:
config:
server-addr: 192.***.**.***:8848
prefix: pre
file-extension: yaml
group: DEFAULT_GROUP
discovery:
server-addr: 192.***.**.***:8848
profiles:
active: sharding-datasource
3.开启nacos,进入首页登录
4.点击加号进行新文件配置
Data ID:pre-sharding-datasource.yaml
格式:prefix-active.file-extension
5.将配置内容写进配置文件中发布
sharding:
jdbc:
datasource:
names: ds0,ds1,ds2
ds0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
username:
password:
ds1:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
username:
password:
ds2:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
url:
username:
password:
6.如果是从单数据源改成多数据源,记得添加以下内容到bootstrap.yaml中
spring:
main:
allow-bean-definition-overriding: true