1. import org.slf4j.LoggerFactory;
    2. import org.springframework.beans.factory.annotation.Qualifier;
    3. import org.springframework.boot.context.properties.ConfigurationProperties;
    4. import org.springframework.boot.jdbc.DataSourceBuilder;
    5. import org.springframework.context.annotation.Bean;
    6. import org.springframework.context.annotation.Configuration;
    7. import org.springframework.context.annotation.Primary;
    9. import javax.sql.DataSource;
    11. /**
    12.  * @author robot
    13.  */
    14. @Configuration
    15. public class DbConfiguration {
    17.     @Bean(name = "alarmDataSource")
    18.     @Primary
    19.     @ConfigurationProperties(prefix = "spring.datasource")
    20.     public DataSource alarmDataSource() {
    21.         return DataSourceBuilder.create().build();
    22.     }
    24.     @Bean(name = "profileDataSource")
    25.     @ConfigurationProperties(prefix = "spring.datasource2")
    26.     public DataSource profileDataSource() {
    27.         return DataSourceBuilder.create().build();
    28.     }
    30.     /**
    31.      * 告警中心的db
    32.      */
    33.     @Bean(value = "alarmDb")
    34.     public Neo alarmDb(@Qualifier("alarmDataSource")DataSource alarmDataSource) {
    35.         try {
    36.             Neo neo = Neo.connect(alarmDataSource);
    37.             // 关闭 explain 解析
    38.             neo.setExplainFlag(false);
    39.             // 关闭 sql 耗时监控
    40.             neo.setMonitorFlag(false);
    41.             // 开启日志打印
    42.             // neo.setLogPrint(true);
    43.             // 关闭 sql 规范校验
    44.             neo.setStandardFlag(false);
    45.             return neo;
    46.         } catch (Exception e) {
    47.             LoggerFactory.getLogger(getClass()).warn("neo初始化异常", e);
    48.             return new Neo();
    49.         }
    50.     }
    52.     /**
    53.      * 环境变量的db
    54.      */
    55.     @Bean(value = "profileDb")
    56.     public Neo profileDb(@Qualifier("profileDataSource") DataSource profileDataSource) {
    57.         try {
    58.             Neo neo = Neo.connect(profileDataSource);
    59.             // 关闭 explain 解析
    60.             neo.setExplainFlag(false);
    61.             // 关闭 sql 耗时监控
    62.             neo.setMonitorFlag(false);
    63.             // 开启日志打印
    64.             // neo.setLogPrint(true);
    65.             // 关闭 sql 规范校验
    66.             neo.setStandardFlag(false);
    67.             return neo;
    68.         } catch (Exception e) {
    69.             LoggerFactory.getLogger(getClass()).warn("neo初始化异常", e);
    70.             return new Neo();
    71.         }
    72.     }
    73. }
    1. spring:
    2.   application:
    3.     name: isc-alarm-service
    4.   datasource:
    5.     jdbcUrl: jdbc:mysql://xxx:xxxx/xxxx?useUnicode=true&characterEncoding=UTF-8&useAffectedRows=true&allowMultiQueries=true&useSSL=false&AppName=${spring.application.name}&AppVersion=1.0&AppSignature=NA&serverTimezone=Asia/Shanghai
    6.     username: xxx
    7.     password: xxx
    8.     driver-class-name: com.mysql.cj.jdbc.Driver
    9.     type: com.zaxxer.hikari.HikariDataSource
    10.     hikari:
    11.       auto-commit: true
    12.       idle-timeout: 180000
    13.       pool-name: panda.server-HikariCP
    14.       max-lifetime: 1800000
    15.       connection-timeout: 30000
    16.       connection-test-query: SELECT 1
    17.       maximum-pool-size: 10
    18.       minimum-idle: 10
    19.   datasource2:
    20.     jdbcUrl: jdbc:mysql://xxxx:xxx/xxx?useUnicode=true&characterEncoding=UTF-8&useAffectedRows=true&allowMultiQueries=true&useSSL=false&AppName=${spring.application.name}&AppVersion=1.0&AppSignature=NA&serverTimezone=Asia/Shanghai
    21.     username: xxxx
    22.     password: xxxx
    23.     driver-class-name: com.mysql.cj.jdbc.Driver
    24.     type: com.zaxxer.hikari.HikariDataSource
    25.     hikari:
    26.       auto-commit: true
    27.       idle-timeout: 180000
    28.       pool-name: panda.server-HikariCP
    29.       max-lifetime: 1800000
    30.       connection-timeout: 30000
    31.       connection-test-query: SELECT 1
    32.       maximum-pool-size: 10
    33.       minimum-idle: 10