页面“Phone耳机手机购买”与“Mysql安装之Docker mysql”之间的差异

来自linux中国网wiki
(页面间的差异)
跳到导航 跳到搜索
 
(Evan移动页面Docker mysqlMysql安装之Docker mysql
 
第1行: 第1行:
香港自提 请见 [[海淘知识]]
+
=Run the application using Docker Compose=
=nokia=
 
Nokia/诺基亚 X7
 
¥1699.00
 
  
https://post.smzdm.com/p/676868/
+
==文件目录==
 +
<pre>
 +
#mkdir -p /home/data/docker-compose-mysql/mysql
 +
#mkdir -p /home/data/docker-compose-mysql/data
  
https://post.smzdm.com/p/a78eq875/
 
  
https://post.smzdm.com/p/a25r8kk2/
+
mkdir -p /data/apps/docker-compose-mysql/mysql
 +
mkdir -p /data/apps/docker-compose-mysql/data
 +
docker-compose-mysql]# tree .
 +
.
 +
├── data
 +
├── docker-compose.yml
 +
└── mysql
 +
    └── docker-my.cnf</pre>
  
[https://www.jb51.net/shouji/641306_2.html Nokia X7手机值得买吗?Nokia X7全面详细评测]
+
== mysql/docker-my.cnf==
 +
<pre>
 +
[mysqld]
  
=essential=
+
default-storage-engine=INNODB
Screen Size 5.71 in
 
[https://www.amazon.com/dp/B074BWGRKH/ref=twister_B07BHGD33F?_encoding=UTF8&psc=1  339 有次223]
 
  
https://post.smzdm.com/p/562711/
+
character-set-server=utf8mb4
 +
server-id = 100
 +
#default-time_zone = '+8:00'
 +
explicit_defaults_for_timestamp=true
 +
log-bin=mysql-bin
  
=nexus6p=
+
max_connections = 10667
exus 6P(代号 Angler)是一款Google在2015年推出,由华为代工的Android智能手机。在2015年9月29日,Google发布两款新Nexus系列的智能手机,分别为LG生产基本款的Nexus 5X,及华为生产高端市场的Nexus 6P
+
max_connect_errors = 6000
搭载高通骁龙810 v2.1 2.0GHz八核处理器,3GB RAM + 32GB/64GB/128GB ROM(没有microSD卡扩展槽)
+
open_files_limit = 65535
 +
table_open_cache = 1024
 +
max_allowed_packet = 500M
 +
binlog_cache_size = 1M
 +
max_heap_table_size = 8M
 +
tmp_table_size = 128M
  
在amazon.com 上买 LG的 5X  OR HUAWEI 6P
+
read_buffer_size = 2M
 +
read_rnd_buffer_size = 8M
 +
sort_buffer_size = 8M
 +
join_buffer_size = 8M
 +
key_buffer_size = 256M
  
 +
thread_cache_size = 64
  
闲鱼上买吧
+
query_cache_type = 1
[https://post.smzdm.com/p/414986/ 进击的“亲儿子”—NEXUS 6P体验评测(华为做的)]
+
query_cache_size = 64M
 +
query_cache_limit = 2M
  
[https://post.smzdm.com/p/385794/ 因为喜欢, 所以剁手:海淘Google 谷歌 Nexus 6P 64G (附与ip6p对比)]
+
ft_min_word_len = 4
  
= Pixel =
 
能在 amazon.cn 买么
 
google 耳机  30
 
  
https://store.google.com/us/product/usb_c_earbuds
+
binlog_format = mixed
 +
expire_logs_days = 7
  
pixel 有耳机口
+
slow_query_log = 1
 +
long_query_time = 2
 +
slow_query_log_file = /var/lib/mysql/mysql-slow.log
 +
general_log = 1
 +
general_log_file = /var/lib/mysql/mysql.log
  
PIXEL XL
 
$384.98
 
https://www.amazon.com/Google-Pixel-XL-Phone-128GB/dp/B01M01ZZAC?th=1
 
  
 +
[client]
 +
default-character-set=utf8mb4
 +
[mysql]
 +
default-character-set=utf8mb4
  
PIXEL
+
</pre>
  
https://www.amazon.com/Google-G2PW210032GBBK-Unlocked-Smartphone-5-5-Inch/dp/B076M7J2WC?th=1
+
== docker-compose.yml==
$278.95
+
<pre>
 +
version: '3.1' 
 +
services:
 +
  mysql:
 +
    image: mysql:5.7.31
 +
    #image: mysql:5.7.26
 +
    hostname: dev-hello-mysql
 +
    volumes:
 +
      - ./data/mysql:/var/lib/mysql
 +
      - ./mysql/docker-my.cnf:/etc/mysql/conf.d/docker-my.cnf
 +
#      - ./mysql/timezone:/etc/timezone
 +
    ports:
 +
      - 3306:3306
 +
    environment:
 +
      MYSQL_ROOT_PASSWORD: 4339pAss3335EOV
 +
      TZ: Asia/Shanghai
 +
    restart: always
  
看来是官网便宜一点
 
buy the pixel 2 xl
 
649 US
 
https://store.google.com/config/pixel_2
 
  
2 xl 6 in
+
#note  这个密码不能位数太多呢 不然好多问题
 +
</pre>
  
https://store.google.com/sg/product/pixel_2_xl
+
==usage==
 +
<pre>
 +
#本机访问 mysql
 +
yum install mysql -y  #client  可能是 mariadb-client
 +
mysql -uroot -p -h127.0.0.1
 +
</pre>
  
 +
=上机有是 2020的 下面的是以前的 有空要优化一下 打包不要用 centos作 容器os=
  
[https://post.smzdm.com/p/636224/ GOOGLE 谷歌 Pixel 2 XL 手机 开箱 + 3周使用体验]
+
= my dockerfile=
[https://post.smzdm.com/p/507972/ 谷歌 像素手机 Google Pixel XL]
+
<pre>
  
[https://post.smzdm.com/p/605927/ Pixel 2 XL开箱+谷歌商店定制保护壳]
+
cat Dockerfile
 +
#名称:
 +
#
 +
# time
 +
FROM centos
 +
MAINTAINER evan [email protected]
 +
WORKDIR /root/
 +
RUN yum -y  install wget
 +
RUN  wget http://repo.mysql.com/mysql-community-release-el7-7.noarch.rpm
 +
RUN rpm -ivh /root/mysql-community-release-el7-7.noarch.rpm
 +
RUN yum -y install  mysql-server
 +
RUN mysql_install_db --user=mysql
 +
ENV MYSQL_USER test
 +
ENV MYSQL_PASS mypassword
 +
#支持中文
 +
ENV LC_ALL  en_US.UTF-8
 +
ADD build_table.sh  /root/build_table.sh
 +
RUN chmod u+x /root/build_table.sh
 +
EXPOSE 3306
 +
ADD  run.sh  /root/run.sh
 +
RUN  chmod u+x /root/run.sh
 +
CMD  /root/run.sh
 +
 
 +
 
 +
cat  build_table.sh
 +
#!/bin/bash
 +
mysqld_safe &
 +
sleep 3
 +
mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'MYSQL_USER'@'%' IDENTIFIED BY '$MYSQL_PASS' WITH GRANT OPTION; "
 +
mysql -e "create database evans"
 +
mysql -e "create table evans.name(name char(20) not null,evan int not null) DEFAULT CHARSET=utf8"
 +
mysql -e "insert into evans.evan values('韦子虚',36),('丽莉',33)"
 +
 
 +
 
 +
cat run.sh
 +
#!/bin/bash
 +
mysqld_safe
 +
 
 +
 
 +
 
 +
 
 +
 
 +
docker build -t evan886/centos-mysql:v1  .
 +
 +
Successfully built 3c3879c54e3b
 +
Successfully tagged evan886/centos-mysql:v1
 +
 
 +
 
 +
 
 +
 
 +
[root@localhost mysql]# docker images
 +
REPOSITORY            TAG                IMAGE ID            CREATED            SIZE
 +
evan886/centos-mysql  v1                  3c3879c54e3b        8 minutes ago      867MB
 +
 
 +
 
 +
 
 +
docker push evan886/centos-mysql:v1
 +
 
 +
#测试 不加-d
 +
  docker run -p 3309:3306 --name mysql -e MYSQL_ROOT_PASSWORD=mypassword --privileged=true mysql
 +
 
 +
  docker run -p 3309:3306 --name mysql -e MYSQL_ROOT_PASSWORD=mypassword  -d --privileged=true mysql
 +
 
 +
 
 +
如果想拉我的镜像
 +
docker pull evan886/centos-mysql:v1
 +
 
 +
</pre>
 +
 
 +
=测试=
 +
<pre>
 +
#我的母机是192.168.50.206
 +
mysql  -uroot -p -h 192.168.50.206  -P3309
 +
Enter password:
 +
Welcome to the MariaDB monitor.  Commands end with ; or \g.</pre>
 +
 
 +
 
 +
==完整测试==
 +
<pre>
 +
docker pull evan886/centos-mysql:v1
 +
 
 +
root@debian:~/mysql# docker  images
 +
REPOSITORY            TAG                IMAGE ID            CREATED            SIZE
 +
evan886/centos-mysql  v1                  3c3879c54e3b        17 hours ago        867MB
 +
 
 +
#运行 加-v 会有问题
 +
docker run -p 3309:3306 --name mysql -e MYSQL_ROOT_PASSWORD=mypassword -v /data/mysql:/var/lib/mysql  -d --privileged=true 3c3879c54e3b
 +
 
 +
root@debian:~/mysql# docker  ps  -a
 +
CONTAINER ID        IMAGE              COMMAND                  CREATED            STATUS                    PORTS              NAMES
 +
34ce2a368d7d        3c3879c54e3b        "/bin/sh -c /root/ru…"  4 minutes ago      Exited (0) 4 minutes ago                      mysql
 +
root@debian:~/mysql#  docker  logs 34ce2a368d7d
 +
180411 03:00:34 mysqld_safe Logging to '/var/log/mysqld.log'.
 +
180411 03:00:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
 +
180411 03:00:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
 +
 
 +
 
 +
</pre>
 +
 
 +
=用官方的=
 +
<pre>
 +
 
 +
docker pull mysql:5.7
 +
#config and run
 +
docker run -p 3307:3306 --restart 策略名称 -v 宿主机数据目录:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID
 +
 
 +
docker run -p 3307:3306 --restart always -v /data/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=2240800 -d 75576f90a779
 +
</pre>
 +
 
 +
=注意 =
 +
<pre>
 +
运行启动
 +
映射mysql外网访问端口: 3307
 +
docker run -p 3307:3306 --restart 策略名称 -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID
 +
docker run -p 3307:3306 --restart always -v /data/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=224099 -d 75576f90a779
 +
 
 +
Docker容器自启动策略
 +
no 不自动重启容器. (默认value)
 +
always 在容器已经stop掉或Docker stoped/restarted的时候才重启容器
 +
on-failure 容器发生error而退出(容器退出状态不为0)重启容器
 +
unless-stopped 在容器已经stop掉或Docker stoped/restarted的时候才重启容器
 +
</pre>
 +
==将MySQL的数据存到宿主机上==
 +
<pre>docker run -p 3307:3306 --restart 策略名称 -v 宿主机数据目录:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID
 +
 
 +
docker run -p 3307:3306 --restart always -v /home/mysql-db-backup:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=rootroot -d 5709795eeffa</pre>
 +
 
 +
 
 +
==使用本地的MySQL配置文件==
 +
<pre>docker run -p 3307:3306 --restart 策略名称 -v 宿主机数据目录:/var/lib/mysql -v 宿主机数据库配置文件目录:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID
 +
 
 +
docker run -p 33306:3306 --restart always -v /data/mysql0:/var/lib/mysql -v /data/mysql0_conf:/etc/mysql/connf.d -e MYSQL_ROOT_PASSWORD=rootroot -d 5709795eeffa
 +
</pre>
 +
 
 +
 
 +
=err=
 +
<pre>
 +
# err  你现在不能用套接字建立连接因为它不见了,所以可以建立一个TCP/IP连接
 +
mysql -uroot -p2240881 -P3307
 +
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 +
您在 /var/spool/mail/root 中有新邮件
 +
[root@localhost ~]# mysql -uroot -p2240881 -P3307  -h 127.0.0.1
 +
Welcome to the MariaDB monitor.  Commands end with ; or \g.
 +
 
 +
https://blog.csdn.net/hjf161105/article/details/78850658 解决Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "
 +
</pre>
 +
 
 +
 
 +
f4ba7ff24ae9: Waiting
 +
ERROR: error pulling image configuration: Get https://production.cloudflare.docker.com/registry-v2/docker/registry/v2/blobs/sha256/e9/e9c354083de75cbcde66071c228fca267d0e946fb41a5399f58265e5a858fcb4/data?verify=1596806434-OrTgZox94HL0JXxYMfUx6j5RT8I%3D: net/http: TLS handshake timeout
 +
 
 +
请见 [[DockerHub镜像加速]]
 +
 
 +
=see also=
 +
 
 +
[https://github.com/docker-library/mysql/blob/f279c9cc0d20407a2c4d9465adae6b077dcf1b51/5.6/Dockerfile docker-library/mysql 5.6/Dockerfile]
 +
 
 +
[https://itbilu.com/linux/docker/EyP7QP86M.html MySQL 官方Docker镜像的使用]
 +
 
 +
[https://www.jianshu.com/p/5c18a4b01dcc?utm_campaign=maleskine&utm_content=note&utm_medium=seo_notes&utm_source=recommendation Docker部署安装MySQL5.7]
 +
 
 +
[https://www.jyoryo.com/index.php/archives/89.html MySQL 5.6 Linux Debian/Ubuntu源码编译安装 LNMP之MySQL]
 +
 
 +
[https://blog.csdn.net/sunyuhua_keyboard/article/details/81540012 docker 安装mysql 8]
 +
 
 +
[https://blog.csdn.net/xiaolyuh123/article/details/72629300 Docker运行Mysql实例]
 +
 
 +
[https://www.jianshu.com/p/7a01046b3c54 Docker部署(二):MySQL数据库]
 +
 
 +
[https://www.cnblogs.com/atuotuo/p/9402132.html#_labelTop 修改 Docker-MySQL 容器的 默认用户加密规则]
 +
 
 +
[https://blog.csdn.net/wxb880114/article/details/82219720 阿里云ECS-使用docker官方镜像安装mysql服务]
 +
[[category:ops]]  [[category:mysql]] [[category: container]]

2020年10月13日 (二) 09:15的版本

Run the application using Docker Compose

文件目录

#mkdir -p /home/data/docker-compose-mysql/mysql
#mkdir -p /home/data/docker-compose-mysql/data


mkdir -p /data/apps/docker-compose-mysql/mysql
mkdir -p /data/apps/docker-compose-mysql/data
docker-compose-mysql]# tree .
.
├── data
├── docker-compose.yml
└── mysql
    └── docker-my.cnf

mysql/docker-my.cnf

[mysqld]

default-storage-engine=INNODB

character-set-server=utf8mb4
server-id = 100
#default-time_zone = '+8:00'
explicit_defaults_for_timestamp=true
log-bin=mysql-bin

max_connections = 10667
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 1024
max_allowed_packet = 500M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 128M

read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 256M

thread_cache_size = 64

query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 2M

ft_min_word_len = 4


binlog_format = mixed
expire_logs_days = 7

slow_query_log = 1
long_query_time = 2
slow_query_log_file = /var/lib/mysql/mysql-slow.log
general_log = 1
general_log_file = /var/lib/mysql/mysql.log


[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

docker-compose.yml

version: '3.1'  
services:
  mysql:
    image: mysql:5.7.31
    #image: mysql:5.7.26
    hostname: dev-hello-mysql
    volumes:
      - ./data/mysql:/var/lib/mysql
      - ./mysql/docker-my.cnf:/etc/mysql/conf.d/docker-my.cnf
#      - ./mysql/timezone:/etc/timezone
    ports:
      - 3306:3306
    environment:
      MYSQL_ROOT_PASSWORD: 4339pAss3335EOV
      TZ: Asia/Shanghai
    restart: always


#note  这个密码不能位数太多呢 不然好多问题

usage

#本机访问 mysql 
yum install mysql -y  #client  可能是 mariadb-client
mysql -uroot -p -h127.0.0.1

上机有是 2020的 下面的是以前的 有空要优化一下 打包不要用 centos作 容器os

my dockerfile


cat Dockerfile 
#名称:
#
# time
FROM centos
MAINTAINER evan [email protected]
WORKDIR /root/
RUN yum -y  install wget
RUN  wget http://repo.mysql.com/mysql-community-release-el7-7.noarch.rpm
RUN rpm -ivh /root/mysql-community-release-el7-7.noarch.rpm
RUN yum -y install  mysql-server
RUN mysql_install_db --user=mysql
ENV MYSQL_USER test
ENV MYSQL_PASS mypassword
#支持中文
ENV LC_ALL  en_US.UTF-8
ADD build_table.sh  /root/build_table.sh
RUN chmod u+x /root/build_table.sh
EXPOSE 3306
ADD  run.sh  /root/run.sh
RUN  chmod u+x /root/run.sh
CMD  /root/run.sh


cat  build_table.sh 
#!/bin/bash
mysqld_safe &
sleep 3
mysql -e "GRANT ALL PRIVILEGES ON *.* TO 'MYSQL_USER'@'%' IDENTIFIED BY '$MYSQL_PASS' WITH GRANT OPTION; "
mysql -e "create database evans"
mysql -e "create table evans.name(name char(20) not null,evan int not null) DEFAULT CHARSET=utf8"
mysql -e "insert into evans.evan values('韦子虚',36),('丽莉',33)"


cat run.sh 
#!/bin/bash
mysqld_safe





docker build -t evan886/centos-mysql:v1  .
 
Successfully built 3c3879c54e3b
Successfully tagged evan886/centos-mysql:v1




 [root@localhost mysql]# docker images
REPOSITORY             TAG                 IMAGE ID            CREATED             SIZE
evan886/centos-mysql   v1                  3c3879c54e3b        8 minutes ago       867MB



docker push evan886/centos-mysql:v1

#测试 不加-d
  docker run -p 3309:3306 --name mysql -e MYSQL_ROOT_PASSWORD=mypassword --privileged=true mysql

  docker run -p 3309:3306 --name mysql -e MYSQL_ROOT_PASSWORD=mypassword  -d --privileged=true mysql


如果想拉我的镜像
docker pull evan886/centos-mysql:v1

测试

#我的母机是192.168.50.206
mysql  -uroot -p -h 192.168.50.206  -P3309
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.


完整测试

docker pull evan886/centos-mysql:v1

root@debian:~/mysql# docker  images 
REPOSITORY             TAG                 IMAGE ID            CREATED             SIZE
evan886/centos-mysql   v1                  3c3879c54e3b        17 hours ago        867MB

#运行 加-v 会有问题
docker run -p 3309:3306 --name mysql -e MYSQL_ROOT_PASSWORD=mypassword -v /data/mysql:/var/lib/mysql  -d --privileged=true 3c3879c54e3b

root@debian:~/mysql# docker  ps  -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                     PORTS               NAMES
34ce2a368d7d        3c3879c54e3b        "/bin/sh -c /root/ru…"   4 minutes ago       Exited (0) 4 minutes ago                       mysql
root@debian:~/mysql#  docker  logs 34ce2a368d7d
180411 03:00:34 mysqld_safe Logging to '/var/log/mysqld.log'.
180411 03:00:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180411 03:00:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


用官方的


 docker pull mysql:5.7
#config and run 
docker run -p 3307:3306 --restart 策略名称 -v 宿主机数据目录:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID

docker run -p 3307:3306 --restart always -v /data/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=2240800 -d 75576f90a779

注意

运行启动
映射mysql外网访问端口: 3307
docker run -p 3307:3306 --restart 策略名称 -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID
docker run -p 3307:3306 --restart always -v /data/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=224099 -d 75576f90a779

Docker容器自启动策略
no 不自动重启容器. (默认value)
always 在容器已经stop掉或Docker stoped/restarted的时候才重启容器
on-failure 容器发生error而退出(容器退出状态不为0)重启容器
unless-stopped 在容器已经stop掉或Docker stoped/restarted的时候才重启容器

将MySQL的数据存到宿主机上

docker run -p 3307:3306 --restart 策略名称 -v 宿主机数据目录:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID

docker run -p 3307:3306 --restart always -v /home/mysql-db-backup:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=rootroot -d 5709795eeffa


使用本地的MySQL配置文件

docker run -p 3307:3306 --restart 策略名称 -v 宿主机数据目录:/var/lib/mysql -v 宿主机数据库配置文件目录:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=mysql密码 -d 镜像ID

docker run -p 33306:3306 --restart always -v /data/mysql0:/var/lib/mysql -v /data/mysql0_conf:/etc/mysql/connf.d -e MYSQL_ROOT_PASSWORD=rootroot -d 5709795eeffa


err

# err  你现在不能用套接字建立连接因为它不见了,所以可以建立一个TCP/IP连接
 mysql -uroot -p2240881 -P3307 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
您在 /var/spool/mail/root 中有新邮件
[root@localhost ~]# mysql -uroot -p2240881 -P3307  -h 127.0.0.1
Welcome to the MariaDB monitor.  Commands end with ; or \g.

https://blog.csdn.net/hjf161105/article/details/78850658 解决Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "


f4ba7ff24ae9: Waiting ERROR: error pulling image configuration: Get https://production.cloudflare.docker.com/registry-v2/docker/registry/v2/blobs/sha256/e9/e9c354083de75cbcde66071c228fca267d0e946fb41a5399f58265e5a858fcb4/data?verify=1596806434-OrTgZox94HL0JXxYMfUx6j5RT8I%3D: net/http: TLS handshake timeout

请见 DockerHub镜像加速

see also

docker-library/mysql 5.6/Dockerfile

MySQL 官方Docker镜像的使用

Docker部署安装MySQL5.7

MySQL 5.6 Linux Debian/Ubuntu源码编译安装 LNMP之MySQL

docker 安装mysql 8

Docker运行Mysql实例

Docker部署(二):MySQL数据库

修改 Docker-MySQL 容器的 默认用户加密规则

阿里云ECS-使用docker官方镜像安装mysql服务