자동 설정

• spring.datasource.url이 모든 Datasource의 url이 된다.

수동 설정 (Java Config)

• spring.datasource.jdbc-url로 해야 HikariCP가 인식한다.

  application.properties에 두개의 데이터베이스에 접근하기 위한 정보를 입력해준다. 여기서 중요한 점은 url이 아닌 jdbc-url을 사용해야한다는 것이다. 그 이유는 spring boot 2.0부터 기본으로 사용하는 커넥션 풀이 HikariCP로 변경되었는데 HikariCP에선 databaseURL 설정에서 정의된 변수가 url 이 아닌 jdbcUrl로 정의되어 있기 때문이다.

  mybatis+jpa

  https://rangerang.tistory.com/70

  https://ehsaniara.medium.com/spring-boot-2-with-multiple-datasource-for-postgres-data-replication-182c89124f54

  https://growing-up-constantly.tistory.com/48

  JPA

  https://github.com/jahe/spring-boot-multiple-datasources/blob/master/src/main/java/com/foobar/FooDbConfig.java

  https://www.computingfacts.com/post/Multiple-Database-Connection-using-Spring-Data-JPA

  https://mudchobo.github.io/posts/spring-boot-jpa-multiple-database

  Mybatis

  https://programmer.group/spring-boot-mybatis-multiple-data-sources.html

  https://chsoft.tistory.com/entry/Spring-Boot-Multi-Datasource-작성

  https://sanghye.tistory.com/26

  https://graykang.tistory.com/56

  https://aljjabaegi.tistory.com/442

  https://dev-overload.tistory.com/30

  https://offbyone.tistory.com/381

  https://eblo.tistory.com/52

  https://jsijsi99.tistory.com/9

  https://mdwgti16.github.io/spring boot/spring_boot_mybatis_multi/#

  기타 참고

  https://docs.spring.io/spring-boot/docs/current/reference/htmlsingle/#howto.data-access.configure-two-datasources

  https://www.fatalerrors.org/a/springboot-db-series-mybatis-multi-data-source-configuration-and-use.html

  https://jonghyeok-dev.tistory.com/44

  https://programmer93.tistory.com/24

  https://ukmo.tistory.com/8

  https://dotheright.tistory.com/188

  https://gigas-blog.tistory.com/122

  나의 코드

  https://github.com/stella6767/Springboot-MultiDatasource-Mybatis