准备搭建Mysql主从同步，原来是在linux直接安装的，感觉不是很方便，这次准备使用挂载的方式安装，前提是Docker已经安装好了
- 搜索Mysql
docker search mysql
搜索结果如下：
NAME DESCRIPTION STARS OFFICIAL AUTOMATED
mysql MySQL is a widely used, open-source relation… 9968 [OK]
mariadb MariaDB is a community-developed fork of MyS… 3645 [OK]
mysql/mysql-server Optimized MySQL Server Docker images. Create… 727 [OK]
percona Percona Server is a fork of the MySQL relati… 509 [OK]
centos/mysql-57-centos7 MySQL 5.7 SQL database server 83
mysql/mysql-cluster Experimental MySQL Cluster Docker images. Cr… 75
centurylink/mysql Image containing mysql. Optimized to be link… 61 [OK]
bitnami/mysql Bitnami MySQL Docker Image 44 [OK]
deitch/mysql-backup REPLACED! Please use http://hub.docker.com/r… 41 [OK]
tutum/mysql Base docker image to run a MySQL database se… 35
prom/mysqld-exporter 31 [OK]
schickling/mysql-backup-s3 Backup MySQL to S3 (supports periodic backup… 30 [OK]
databack/mysql-backup Back up mysql databases to... anywhere! 30
linuxserver/mysql A Mysql container, brought to you by LinuxSe… 26
centos/mysql-56-centos7 MySQL 5.6 SQL database server 20
circleci/mysql MySQL is a widely used, open-source relation… 19
mysql/mysql-router MySQL Router provides transparent routing be… 16
arey/mysql-client Run a MySQL client from a docker container 14 [OK]
fradelg/mysql-cron-backup MySQL/MariaDB database backup using cron tas… 8 [OK]
openshift/mysql-55-centos7 DEPRECATED: A Centos7 based MySQL v5.5 image… 6
devilbox/mysql Retagged MySQL, MariaDB and PerconaDB offici… 3
ansibleplaybookbundle/mysql-apb An APB which deploys RHSCL MySQL 2 [OK]
widdpim/mysql-client Dockerized MySQL Client (5.7) including Curl… 1 [OK]
jelastic/mysql An image of the MySQL database server mainta… 1
monasca/mysql-init A minimal decoupled init container for mysql 0
- 直接下载最新的Mysql镜像
docker pull mysql
- 查看Docker 镜像
docker images
结果如下：
REPOSITORY TAG IMAGE ID CREATED SIZE
mysql latest e1d7dc9731da 7 days ago 544MB
- 在opt下创建mysql的挂载目录
cd /opt/
mkdir mysql_docker
cd mysql_docker/
echo $PWD
- 在conf目录下新建my.cnf配置文件
[mysqld]
#主从复制设置 本机为副本实例
server-id=2
relay-log=relay-log
relay-log-index=relay-log.index
innodb_file_per_table=ON
skip_name_resolve=ON
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
#!includedir /etc/my.cnf.d
- 启动mysql容器
可以使用$PWD代替/opt/mysql_docker路径，我直接指定路径
docker run --name mysqlserver -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=Jay@:19951027123 -d -i -p 3306:3306 mysql:latest
docker run --name mysqlserver -v /opt/mysql_docker/conf:/etc/mysql/conf.d -v /opt/mysql_docker/logs:/logs -v /opt/mysql_docker/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=Jay@:19951027123 -d -i -p 3306:3306 mysql:latest
命令备注：
-p 3306:3306：将容器的 3306 端口映射到主机的 3306 端口。
-v $PWD/conf:/etc/mysql/conf.d：将主机当前目录下的 conf/my.cnf 挂载到容器的 /etc/mysql/my.cnf。
-v $PWD/logs:/logs：将主机当前目录下的 logs 目录挂载到容器的 /logs。
-v $PWD/data:/var/lib/mysql ：将主机当前目录下的data目录挂载到容器的 /var/lib/mysql 。
-e MYSQL_ROOT_PASSWORD=123456：初始化 root 用户的密码。
docker查看已启动的容器
docker ps
- 进入mysql容器，并登陆mysql
docker exec -it mysqlserver bash
mysql -uroot -p
注意：mysqld和mysql标签对应的socket文件路径不对等的问题，需要修改my.cnf文件中的socket路径为错误提示中的。然后重启mysql可以解决
重启命令
docker restart mysqlserver
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
然后重新登录mysql即可
- 开启远程访问权限
use mysql;
select host,user from user;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
- 密码太简单，最好改个密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'TestBicon@123';
改完刷新权限，重新登录
flush privileges;
- 查看Dokcer日志
docker logs -f --tail 10 a4dac74d48f7
常用命令：
- 关闭docker中mysql容器
docker stop mysqlserver
- docker中mysql重启
docker restart mysqlserver
