# Neeky/mysqltools

一个用于快速构建大规模，高质量，全自动化的 mysql分布式集群环境的工具；包含mysql 安装、备份、监控、高可用、读写分离、优化、巡检、自行化运维

Repository: https://github.com/Neeky/mysqltools
Canonical: https://ross.abutalabs.com/products/mysqltools
Language: Python
License Family: other
Topics: mysql, mysql-dba, mgr, mysql-group-replicaion, mysql-monitor, mysql-backup, mysql-maintance, zabbix, python, ansible, master-slave, dev-ops, innodb, innodb-cluster, mycat, dble, atlas, mysql-tools
Last push: 2023-03-20T03:52:39+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 3442, "days_push": 1262, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1079, forks 466 (observed 2026-08-28T04:03:30.295856+00:00)

## What it is
mysqltools is a Python/Ansible-based automation toolkit for building large-scale, high-quality MySQL distributed cluster environments. It automates MySQL installation, replication topologies (master-slave, multi-source, group replication), backup, Zabbix-based monitoring, high availability with MHA, and read-write splitting with proxies like MyCAT.

## Use cases
- automate mysql cluster installation across many servers
- set up mysql master-slave replication automatically
- deploy mysql group replication (mgr) clusters
- configure mysql backup schedules
- set up zabbix monitoring for mysql
- configure mha high availability for mysql
- set up read-write splitting with mycat
- upgrade mysql minor versions automatically

## When to choose
- you manage many MySQL instances and want repeatable, automated provisioning
- you want an all-in-one toolkit covering install, backup, monitoring, and HA
- your environment is Linux-based and you already use Ansible

## When to avoid
- you use MySQL 8.0 and want a more actively developed tool (the author recommends dbm-agent)
- you need a supported tool with a clear license
- you need Windows or macOS support
- you want a GUI rather than CLI/Ansible workflows

## Facets
- artifact type: cli-tool
- maturity: maintenance
- function: database, deployment, monitoring, backup, configuration-management, developer-tools
- domain: databases, self-hosted
- platform: python, cli
- tags: mysql, ansible, zabbix, mysql-group-replication, master-slave-replication, read-write-splitting, high-availability, mha, mycat, dba, database-operations, devops, automation, linux

## Member repositories
- Neeky/mysqltools (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:30.295856+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:53:01.700150+00:00, confidence not recorded.
  - readme: https://github.com/Neeky/mysqltools (fetched 2026-08-28T04:03:30.295856+00:00, sha 560a42b2ca8f)
- Data as of 2026-08-30T08:39:29.467469+00:00.