FROM docker.io/centos
COPY mycat/jdk-8u171-linux-x64.tar.gz /usr/local/
RUN tar -zxvf /usr/local/jdk-8u171-linux-x64.tar.gz -C /usr/local/
ENV JAVA_HOME=/usr/local/jdk1.8.0_171
ENV PATH=$PATH:$JAVA_HOME/bin
ENV CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
COPY mycat/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz  /usr/local/
RUN tar -zxvf /usr/local/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz -C /usr/local/
ENV MYCAT_HOME=/usr/local/mycat

RUN source /etc/profile
RUN source ~/.bash_profile
CMD ["/usr/local/mycat/bin/mycat", "console"]

docker build -t centos-jdk8-mycat1.6 -f Dockerfile  /home/wen/

  


  

        
    
    
    
     
      
       
        
        
         select user()
         
         
        
        
        
         select user()
         
         
        
        
        
         select user()
         
         
       
       
docker-compose文件的编写
       
docker-compose.yml 其实就是帮我们做了个服务编排，使用起来就很方便了，下面贴出本次实验的服务编排明细：
       
version: '2'
services:
  mycat:
   image: centos-jdk8-mycat1.6
   networks:
       jznet:
         ipv4_address: 172.18.4.26
   volumes:
     - /root/data/mycat/logs:/usr/local/mycat/logs
     - /home/wen/mycat-test/schema.xml:/usr/local/mycat/conf/schema.xml
   ports:
     - "8066:8066"
     - "9066:9066"
  mysql-01:
   image: docker.io/centos/mysql-57-centos7
   networks:
       jznet:
         ipv4_address: 172.18.4.21
   ports:
     - "3301:3306"
   environment:
     - MYSQL_ROOT_PASSWORD=123456
  mysql-02:
   image: docker.io/centos/mysql-57-centos7
   networks:
       jznet:
         ipv4_address: 172.18.4.22
   ports:
     - "3302:3306"
   environment:
     - MYSQL_ROOT_PASSWORD=123456
  mysql-03:
   image: docker.io/centos/mysql-57-centos7
   networks:
       jznet:
         ipv4_address: 172.18.4.23
   ports:
     - "3303:3306"
   environment:
     - MYSQL_ROOT_PASSWORD=123456
networks:
  jznet:
    driver: bridge
    ipam:
      driver: default
      config:
      - subnet: 172.18.4.0/26
 
       
启动服务
 
       
 
       
启动之后我们发现mycat的日志还是会报错的，报下面的错误：
 
       
 
       
其实这个是由于我们数据的db1、db2、db3、没创建好导致的，我们在各自的数据库将这三个库手动创建好就可以了
 
       
 
       
实验sql
 
       
select * from user_consumption_record limit 10;

create table user(id int not null,name varchar(20));
create table user_consumption_record(id int not null PRIMARY key  COMMENT "主键" auto_increment ,goods varchar(20) COMMENT "商品",amount DECIMAL(15,2) COMMENT "金额",finish_time datetime) COMMENT "完成时间";


insert into user_consumption_record(id,goods,amount,finish_time) values(7,'a',1,now());

insert into user_consumption_record(id,goods,amount,finish_time) valu