docker容器(docker compose)python 3.14执行脚本

环境:
OS:Centos 7
python:3.14.7

1.准备yaml文件
mkdir /opt/rds_slowsql/
mkdir /opt/rds_slowsql/pyscript ##脚本存放目录
vi /opt/rds_slowsql/docker-compose.yml

chmod -R 700 /opt/rds_slowsql/ ##修改目录权限

内容如下:

version: "3.8"

services:
  python314:
    image: registry.cn-shenzhen.aliyuncs.com/hxlk8s/python:3.14.7
    container_name: python314
    command: sleep infinity
    volumes:
      # 本地脚本目录挂载容器 /app
      - ./pyscript:/app
      # 同步宿主机时区时间(只读)
      - /etc/localtime:/etc/localtime:ro
      - /etc/timezone:/etc/timezone:ro

 

2.启动
docker compose up -d

 

3.尝试登录
docker exec -ti python314 /bin/bash
查看容器时间
root@9070ad2f6de9:/# date
Mon Aug 10 13:53:42 CST 2026

 

4.安装依赖包
docker exec -ti python314 /bin/bash
阿里云
pip3 install pymysql
pip3 install aliyun-python-sdk-core
pip3 install aliyun-python-sdk-rds

华为云:
pip3 install huaweicloudsdkcore
pip3 install huaweicloudsdkrds

 

5.执行程序
docker exec -it python314 python /app/get_rds_slowsql_log.py

制作成shell
cd /opt/rds_slowsql/pyscript
vi get_rds_slowsql_log.sh
#!/bin/bash
docker exec python314 python /app/get_rds_slowsql_log.py

chmod u+x get_rds_slowsql_log.sh

 

6.制作成crontab执行
## 下载慢查询日志
38 11 * * * /opt/rds_slowsql/pyscript/get_rds_slowsql_log.sh >/dev/null 2>&1

 

说明:若容器删除后需要重新安装如下包
阿里云
pip3 install pymysql
pip3 install aliyun-python-sdk-core
pip3 install aliyun-python-sdk-rds

华为云:
pip3 install huaweicloudsdkcore
pip3 install huaweicloudsdkrds