# 定时备份mysql

#### 相关容器

```
swr.cn-south-1.myhuaweicloud.com/vp-public/mysql-backup:v1.0
```

#### 相关配置

```yaml
    volumes:
      - ./config:/config # 需要备份的数据库链接信息
      - ./data:/data #备份文件保存目录

```

#### 备份文件配置信息
```yaml
# 5-11.yaml

- host: 192.168.5.11
  user: 
  password: 
  name: mysql    # 没有实际意义，用来区分备份文件名称，按时间生成{name}-20240713-141847-732950.tar.gz 这样的文件
  port: 3306


- host: 192.168.5.12
  user: 
  password: 
  name: mysql2  # 没有实际意义，用来区分备份文件名称，按时间生成{name}-20240713-141847-732950.tar.gz 这样的文件
  port: 3306
```

#### 直接运行

```shell
#!/bin/bash

docker run -it \
        -v $(pwd)/config:/config -v $(pwd)/data:/data \
        --privileged=true \
        swr.cn-south-1.myhuaweicloud.com/vp-public/mysql-backup:v1.0

```

#### 在k8s创建定时容器

- 1  **创建服务**

[![](https://iovhm.com/book/uploads/images/gallery/2024-07/scaled-1680-/H95aABiTxgXEYrmJ-image-1720855399570.png)](https://iovhm.com/book/uploads/images/gallery/2024-07/H95aABiTxgXEYrmJ-image-1720855399570.png)

- 2  **挂载数据**


[![](https://iovhm.com/book/uploads/images/gallery/2024-07/scaled-1680-/U5NRljK1wRmNnsoF-image-1720855503074.png)](https://iovhm.com/book/uploads/images/gallery/2024-07/U5NRljK1wRmNnsoF-image-1720855503074.png)