本文共 3716 字，大约阅读时间需要 12 分钟。

Spring Cloud Config?MySQL??????

1. ?????

Spring Cloud Config?Spring Cloud????????????????????????????Git?????????????????????MySQL???????????????????MySQL????????

• ????????????????????????
• ?????????????????????????
• ??????????????????

2. ????

2.1 ??MySQL

?????MySQL??????????????????MySQL???

mysql -u root -p

??MySQL root????????MySQL??????

2.2 ???????

??MySQL????????????

CREATE DATABASE config;
USE config;
CREATE TABLE config (
    id INT PRIMARY KEY AUTO_INCREMENT,
    key1 VARCHAR(500) NOT NULL,
    value1 VARCHAR(500) NOT NULL,
    application VARCHAR(50) NOT NULL,
    profile VARCHAR(50) NOT NULL,
    label VARCHAR(50) DEFAULT NULL
);

3. Spring Boot????

3.1 pom.xml??

????pom.xml?????????

   
    
    
        
     
      org.springframework.boot
     
        
     
      spring-boot-starter-web
     
    
    
    
    
        
     
      org.springframework.cloud
     
        
     
      spring-cloud-config-server
     
    
    
    
    
        
     
      mysql
     
        
     
      mysql-connector-java
     
        
     
      5.1.21
     
    
    
    
    
        
     
      org.springframework.boot
     
        
     
      spring-boot-starter-jdbc
     
    
    
    
    
        
     
      org.springframework.boot
     
        
     
      spring-boot-starter-data-jpa
     
    
    
   

3.2 ????

??application.properties??bootstrap.properties?????????

spring:
    datasource:
        url: jdbc:mysql://localhost:3306/config
        username: root
        password: root
        driver-class-name: com.mysql.jdbc.Driver
    cloud:
        config:
            server:
                jdbc:
                    sql: "select key1,value1 from config where application=? and profile=? and label=?"
                default-label: master
    application:
        name: config-server
server:
    port: 9060

4. ??????

????????????

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cloud.config.server.EnableConfigServer;
@SpringBootApplication
@EnableConfigServer
public class ConfigServerApplication {
    public static void main(String[] args) {
        SpringApplication.run(ConfigServerApplication.class);
    }
}

?????

mvn spring-boot:run

????????????http://localhost:9060?

5. ???????

5.1 pom.xml??

??????pom.xml?

   
    
    
        
     
      org.springframework.boot
     
        
     
      spring-boot-starter-web
     
    
    
    
    
        
     
      org.springframework.cloud
     
        
     
      spring-cloud-starter-config
     
    
    
   

5.2 ????

??bootstrap.yml???

spring:
    application:
        name: config-consumer
    cloud:
        config:
            uri: http://localhost:9060
            fail-fast: true
    profiles:
        active: dev
management:
    endpoints:
        web:
            exposure:
                include: '*'

5.3 ?????

????????

import org.springframework.beans.factory.annotation.Value;
import org.springframework.cloud.context.config.annotation.RefreshScope;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
@RequestMapping("/config/consumer")
@RefreshScope
public class ConsumerController {
    @Value("${hello}")
    private String hello;
    @RequestMapping("/test")
    public String testConfig() {
        return String.format("hello is %s", hello);
    }
}

?????

mvn spring-boot:run

6. ??

6.1 ??????

????????????????

http://localhost:9060/config/consumer/test

6.2 ???????

?MySQL??????????????

SELECT * FROM config WHERE application='config-server' AND profile='dev';

7. ??

??????????????????MySQL?Spring Cloud Config???????????????????????????????????????????????????????????????

转载地址：http://iyme.baihongyu.com/