容器化部署MySQL5.7数据库

 数据长期化

1. # 创建数据目录
2. data]# ls
3. mysql  mysql_conf  nginx
5. # 配置文件 中增加了字符集的配置
6. data]# cd mysql_conf/
7. [root@data-visualization-010050101050-security mysql_conf]# ls
8. my.cnf
9. [root@data-visualization-010050101050-security mysql_conf]# cat my.cnf
10. # For advice on how to change settings please see
11. # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
13. [mysqld]
14. #
15. # Remove leading # and set to the amount of RAM for the most important data
16. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
17. # innodb_buffer_pool_size = 128M
18. #
19. # Remove leading # to turn on a very important data integrity option: logging
20. # changes to the binary log between backups.
21. # log_bin
22. #
23. # Remove leading # to set options mainly useful for reporting servers.
24. # The server defaults are faster for transactions and fast SELECTs.
25. # Adjust sizes as needed, experiment to find the optimal values.
26. # join_buffer_size = 128M
27. # sort_buffer_size = 2M
28. # read_rnd_buffer_size = 2M
29. skip-host-cache
30. skip-name-resolve
31. datadir=/var/lib/mysql
32. socket=/var/run/mysqld/mysqld.sock
33. secure-file-priv=/var/lib/mysql-files
34. user=mysql
36. # Disabling symbolic-links is recommended to prevent assorted security risks
37. symbolic-links=0
39. #log-error=/var/log/mysqld.log
40. pid-file=/var/run/mysqld/mysqld.pid
41. # 增加配置文件
42. character-set-server=utf8mb4
43. collation-server=utf8mb4_unicode_ci
45. [client]
46. socket=/var/run/mysqld/mysqld.sock
47. # 增加配置文件
48. default-character-set=utf8mb4
50. !includedir /etc/mysql/conf.d/
51. !includedir /etc/mysql/mysql.conf.d/

复制代码

创建容器服务 

1. # 创建容器服务，挂载数据文件和配置文件，运行以下命令
2. docker run -d --restart=always -e LANG=C.UTF-8 -e TZ=Asia/Shanghai -v /data/mysql_conf/my.cnf:/etc/my.cnf -v /data/mysql:/var/lib/mysql --name=mysql_master -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123123 harbor.dazhenyun.cn/repo/mysql:5.7

复制代码

 验证新建的容器化MySQL服务

1. # 进入容器 验证账号密码和字符集配置
2. bash-4.2# mysql -uroot -p123123
3. mysql: [Warning] Using a password on the command line interface can be insecure.
4. Welcome to the MySQL monitor.  Commands end with ; or \g.
5. Your MySQL connection id is 2
6. Server version: 5.7.44 MySQL Community Server (GPL)
8. Copyright (c) 2000, 2023, Oracle and/or its affiliates.
10. Oracle is a registered trademark of Oracle Corporation and/or its
11. affiliates. Other names may be trademarks of their respective
12. owners.
14. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
16. mysql> SHOW VARIABLES LIKE 'character_set_server';
17. +----------------------+---------+
18. | Variable_name        | Value   |
19. +----------------------+---------+
20. | character_set_server | utf8mb4 |
21. +----------------------+---------+
22. 1 row in set (0.00 sec)
24. mysql> SHOW VARIABLES LIKE 'collation_server';
25. +------------------+--------------------+
26. | Variable_name    | Value              |
27. +------------------+--------------------+
28. | collation_server | utf8mb4_unicode_ci |
29. +------------------+--------------------+
30. 1 row in set (0.00 sec)
32. mysql> exit
33. Bye

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。