k8sclub/mysql repository overview

⁠mysql

Customized mysql image with customized config, management, monitoring, backup based on official image.

Moved from icmdb/applications/mysql.

⁠Reference

• Get Docker Engine - Community for Ubuntu - Docker⁠
• Install Docker Compose - Docker⁠
• Best practices for writing Dockerfiles⁠
  • Dockerfile最佳实践⁠
• Compose file version 3 reference⁠
• Configuring the Server - MySQL Docs⁠
• mysql - DockerHub⁠
• phpmyadmin⁠
• mysqld_exporter - GitHub⁠
• Prometheus⁠
  • prom/prometheus - DockerHub⁠
• Grafana⁠
  • grafana/grafana - DockerHub⁠
  • Installing using Docker⁠
• Using MySQL in Grafana⁠
• 1.4.1 Dumping Data in SQL Format with mysqldump - MySQL Docs⁠
• MySQL HA/Scalability Guide⁠
• Percona Toolkit Documentation⁠

⁠Quick Start

git clone https://github.com/icmdb/mysql.git

cd mysql

docker-compose pull

docker-compose up -d

# Remove (Carefully)
docker-compose down
rm -rf ./mysqldata/
rm -rf ./prometheus/
rm -rf ./grafana/

Then you can access:

Recommanded dashboard for mysql: 7362, 7991, 9777

⁠Environment

Details see: docker-compose.yml⁠

• MYSQL_CREATE_DBS=db1,db2,db3
• MYSQL_CREATE_USERS=user1:pass1:db1,user2:pass2:db2,user3:pass3:db3

⁠Todo List

• MySQL Configfile for customized
• MySQL Initialize Scripts for autocreate DBs/Users
  • Auto Create Databases
  • Auto Create Users
• MySQL Dockerfile for autobuild (DockerHub)
• MySQL docker-compose file for on key start
• MySQL deployment yaml for kubernetes
• MySQL Management for easy to use (phpmyadmin)
• MySQL Monitoring for performance/improvement/alert
  • mysql-exportor
  • Prometheus
  • Grafana
• MySQL Backup for disaster recovery
  • Backup Scripts
• MySQL Tools
  • MySQL percona-toolkit
• MySQL HA for production

⁠Feedback

• issues - GitHub⁠