imega/mysql-client

mysql-client

镜像概述

mysql-client是一个用于运行MySQL客户端的Docker镜像，基于alpine:3.13构建，具有轻量级特性，镜像大小仅39MB。该镜像提供了标准的MySQL客户端工具，可便捷连接MySQL服务器并执行各类SQL操作。

核心功能与特性

• 轻量级设计：基于alpine:3.13构建，镜像大小仅39MB，资源占用低
• 完整工具集：包含mysql、mysqladmin等标准MySQL客户端工具
• 灵活连接：支持连接远程或本地MySQL服务器
• 数据卷支持：可通过挂载数据卷实现数据备份、导入导出等操作
• 连接重试机制：支持在连接失败时等待并重试，提高操作稳定性

使用场景

• 临时需要执行MySQL命令的环境（无需本地安装MySQL客户端）
• CI/CD流程中对数据库进行查询、迁移或备份操作
• 远程数据库管理与维护
• 数据备份与恢复操作

使用方法

前提条件

需确保已部署MySQL服务器（可参考MySQL服务器容器部署）。

基本使用示例

执行MySQL命令

通过docker run命令直接执行MySQL客户端命令，例如查询数据库表：

bash
$ docker run --rm \
    mysql-client \
    mysql --host=example.com --user=root --password=123321 --database=test --execute='show tables;'

挂载数据卷

挂载本地目录至容器内/data目录，用于数据备份或导入：

bash
$ docker run -it -v /path/to/dumps:/data \
    --link mysqlsrv:mysqlsrv \
    imega/mysql-client \
    mysql --host=example.com --user=root --password=123321 --database=mydb --execute='show tables;'

连接重试

当连接无法建立时，使用mysqladmin等待并重试连接（而非直接终止）：

bash
$ docker run --rm \
    --link mysqlsrv:mysqlsrv \
    imega/mysql-client \
    mysqladmin --silent --host=mysqlsrv --wait=5 ping

许可信息

本镜像遵循MIT许可证。详细条款如下：

Copyright © 2020 iMega <***>

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.