【详述】目前为了多域业务报表查询的业务 ，采用资源隔离，创建了staffer_commisson 用户，并分配资源组staffer_commission_group ，但使用springboot进行多数据源配置的时候，用root账户使用了资源组staffer_commission_group ，客户端单数据源配置的时候正常，用户配置如下，SpringBoot Demo配置如下，返回结果如下
创建用户和配置如下：
CREATE ROLE ‘staffer_commission’;
CREATE USER ‘staffer_commission’ IDENTIFIED WITH mysql_native_password BY ‘****’ DEFAULT ROLE ‘staffer_commission’;
GRANT SELECT_PRIV,ALTER_PRIV,LOAD_PRIV ON . TO ‘staffer_commission’@’%’;
CREATE RESOURCE GROUP staffer_commission_group
TO
( user=‘staffer_commission’,
role=‘staffer_commission’,
query_type in (‘select’,‘insert’)
)
WITH (
‘cpu_core_limit’ = ‘2’, – cpu核数
‘mem_limit’ = ‘10%’, – 内存
‘type’ = ‘normal’
);
SpringBoot配置Demo：
server:
port: ${port:80}
tomcat:
accept-count: 1000
max-connections: 2000
basedir: ./springboot-tomcat-tmp
pagehelper:
helper‐dialect: mysql
数据库连接信息
spring:
datasource:
dynamic:
druid:
initialSize: 1
minIdle: 0
maxActive: 10
maxWait: 180000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 25200000
validationQuery: select 1
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
filters: stat
primary: master #设置默认的数据源或者数据源组,默认值即为master
strict: false #严格匹配数据源,默认false. true未匹配到指定数据源时抛异常,false使用默认数据源
datasource:
#数据库1,以前的数据配置(正式环境地址需要修改对应地址)
master:
continue-on-error: false
url: jdbc:mysql://mysql-bigdata.pre.hdsaas.facehand.cn:3306/saas_statistics?allowMultiQueries=true&serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true&zeroDateTimeBehavior=convertToNull
username: refactor
password: ***
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
#数据库2,新增的大数据库地址(正式环境地址需要修改对应地址)
starRocks:
continue-on-error: false
url: jdbc:mysql://xxxx:9030/dwd?allowMultiQueries=true&serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true&zeroDateTimeBehavior=convertToNull
username: root
password: ***
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
starRocks_commission:
continue-on-error: false
url: jdbc:mysql://xxxxx:9030/dwd?allowMultiQueries=true&serverTimezone=GMT%2B8&characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true&zeroDateTimeBehavior=convertToNull
username: staffer_commission
password: ****
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
【附件】
这是返回的用户日志信息，调用的是SpringBoot 中的starrocks的配置，应该是root，但是返回的是starRocks_commission中的配置
