MyCat 测试环境搭建
mycat镜像
FROM centos
MAINTAINER 592128196@qq.com
ADD jdk-8u20-linux-x64.tar.gz /usr/local/
ADD mycat /usr/local/mycat
ENV JAVA_HOME /usr/local/jdk1.8.0_20
ENV CLASSPATH $JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
ENV PATH $PATH:$JAVA_HOME/bin
EXPOSE 8066 9066
RUN chmod -R 777 /usr/local/mycat/bin
构建镜像 docker build -t mycat:1.65 .
运行不停止镜像：
docker run --name mycat -p 8066:8066 -p 9066:9066 \
-h notice --privileged \
-v /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime:ro \
-v /mnt/apps/mycat/conf/rule.xml:/usr/local/mycat/conf/rule.xml \
-v /mnt/apps/mycat/conf/schema.xml:/usr/local/mycat/conf/schema.xml \
-v /mnt/apps/mycat/conf/server.xml:/usr/local/mycat/conf/server.xml \
-d -i -t mycat:1.65 /bin/bash
docker run --name mycat -p 8066:8066 -p 9066:9066 \
-h notice --privileged \
-v /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime:ro \
-v /mnt/mycat/conf/rule.xml:/usr/local/mycat/conf/rule.xml \
-v /mnt/mycat/conf/schema.xml:/usr/local/mycat/conf/schema.xml \
-v /mnt/mycat/conf/server.xml:/usr/local/mycat/conf/server.xml \
-d -i -t mycat:1.65 /bin/bash
docker run --name mycat -p 8066:8066 -p 9066:9066 \
-v /mnt/apps/mycat/conf:/usr/local/mycat/conf \
-d -i -t mycat:1.65 /bin/bash
主数据库：
docker run -p 33061:3306 --name mysql_mycat_Lord \
-v /mnt/apps/mysql/conf1:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD=YUIHkwen12423qIUKwefhausildfk \
-d mysql:5.7
从数据库
docker run -p 33062:3306 --name mysql_mycat_From \
-e MYSQL_ROOT_PASSWORD=YUIHkwen12423qIUKwefhausildfk \
-d mysql:5.7
test1
docker run -p 33063:3306 --name mysql_mycat_Lord1 \
-h notice --privileged \
-v /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime:ro \
-v /mnt/apps/mysql/conf1:/etc/mysql/conf.d \
-v /mnt/apps/mysql/data1:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=YUIHkwen12423qIUKwefhausildfk \
-d mysql:5.7
docker run -p 33064:3306 --name mysql_mycat_From1 \
-h notice --privileged \
-v /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime:ro \
-v /mnt/apps/mysql/conf2:/etc/mysql/conf.d \
-v /mnt/apps/mysql/data2:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=YUIHkwen12423qIUKwefhausildfk \
--link mysql_mycat_Lord1:mycatlord1db \
-d mysql:5.7
docker run -p 33064:3306 --name mysql_mycat_From1 \
-h notice --privileged \
-v /usr/share/zoneinfo/Asia/Shanghai:/etc/localtime:ro \
-v /mnt/apps/mysql/conf2:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD= \
--link mysql_mycat_Lord1:mycatlord1db \
-d mysql_mycat_from1_backup
ps -ef|grep mycat
kill -9 217
Docker 装vim
apt-get update && apt-get install vim 安装
change master to master_host='172.17.0.3', master_user='rep1', master_password='123456', master_port=33061, master_log_file='mysql-bin.000002', master_log_pos=437, master_connect_retry=30;
change master to master_host='mycatlord1db', master_user='slave', master_password='123456', master_port=3306, master_log_file='edu-mysql-bin.000004', master_log_pos=154, master_connect_retry=30;
change master to master_host='192.168.1.100', master_user='slave', master_password='123456', master_port=3306, master_log_file='edu-mysql-bin.000001', master_log_pos=1389, master_connect_retry=30;
change master to master_host=’172.17.0.3’, master_port=33061, master_user=’rep1’, master_password=’123456’, master_log_file='mysql-bin.000002', master_log_pos=437;
docker inspect --format='{{.NetworkSettings.IPAddress}}' 661f22826d0a
[mysqld]
server_id=100
binlog-ignore-db=mysql
log-bin=edu-mysql-bin
binlog_cache_size=1M
binlog_format=mixed
expire_logs_days=7
slave_skip_errors=1062
[mysqld]
server_id=101
binlog-ignore-db=mysql
log-bin=edu-mysql-slave1-bin
binlog_cache_size=1M
binlog_format=mixed
expire_logs_days=7
slave_skip_errors=1062
relay_log=edu-mysql-relay-bin
log_slave_updates=1
read_only=1
