Linux - 패키지
시스템관리
보안 / 관리 / 복원
자동화 프로그램 개발
백엔드 프로그래머(웹 개발)
# jdbc1
spring.datasource1.driver-class=org.mariadb.jdbc.Driver
spring.datasource1.jdbc-url=jdbc:mariadb://localhost:3306/project
spring.datasource1.username=project
spring.datasource1.password=1234
# jdbc2
spring.datasource2.driver-class=org.mariadb.jdbc.Driver
spring.datasource2.jdbc-url=jdbc:mariadb://192.168.116.1:3306/board
spring.datasource2.username=board
spring.datasource2.password=1234
@SpringBootApplication
public class BootzipcodeApplication implements CommandLineRunner{
@Bean
@Primary
@ConfigurationProperties("spring.datasource1")
public DataSource bootdb1DataSource() {
return DataSourceBuilder.create().build();
}
@Bean
@Primary
@ConfigurationProperties("spring.datasource2")
public DataSource bootdb2DataSource() {
return DataSourceBuilder.create().build();
}
public static void main(String[] args) {
SpringApplication.run(BootzipcodeApplication.class, args);
}
@Override
public void run(String... args) throws Exception {
// TODO Auto-generated method stub
System.out.println(bootdb1DataSource().getConnection());
System.out.println(bootdb2DataSource().getConnection());
}
}
mysqldump -u project -p1234 project zipcode | mysql -h 192.168.116.1 -u board -p1234 board
sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf
ssh
apache-tomcat
mariadb
-> jsp 실행
putty
로그인 : master
sudo reboot