51,412
社区成员
发帖
与我相关
我的任务
分享正常公司的项目中,连接的mysql都是一个域名+端口的形式,那么如果mysq做的是主从模式,公司给的这个域名对应的IP端口是主库还是从库?
mysql集群你连接的vip也就是你连的域名最初是在主库的,只有当主库挂掉,才会切换到从库,并将从库提升为主库,如果是主库,你登录进去show master 跟从库进去show master不一样吧?
spring:
shardingsphere:
datasource:
names: master,slave
master:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/reggie?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
username: root
password: 123456
type: com.alibaba.druid.pool.DruidDataSource
#Spring Boot 默认是不注入这些属性值的,需要自己绑定
#druid 数据源专有配置
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
slave:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://192.168.233.141:3306/reggie?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
username: root
password: Ai@15012706016
type: com.alibaba.druid.pool.DruidDataSource
#Spring Boot 默认是不注入这些属性值的,需要自己绑定
#druid 数据源专有配置
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
masterslave: # 主从复制的配置
# 负载均衡的配置:配置为轮询
load-balance-algorithm-type: round_robin
# 最终暴露的数据源名称
name: datasource
# 从数据库名称列表,用','号隔开
slave-data-source-names: slave
props:
sql:
show: true # 开启在控制台显示sql,默认是false
master-data-source-name: master