MYSQL OPS, PRODUCTIZED
MySQL ops,
productized
dbbot is built for the MySQL ecosystem. It turns deployment, replication, backup, recovery, observability, and downstream analytics onboarding into stable, repeatable, and auditable execution flows organized around Playbooks, variables, docs, and release packages.
git clone https://github.com/fanderchan/dbbot
Playbooks
single_node / master_slave / mha_go / mgr / innodb_cluster
Runtime
Bundled portable runtime based on ansible-base 2.10.17
Lifecycle
dbbotctl doctor / env setup / release upgrade
mha_go.yml — dbbot/mysql_ansible
$ ansible-playbook -i inventory mha_go.yml
PLAY [Deploy mha-go HA manager]
TASK [validate common_config.yml] OK
TASK [check os_type and python] OK
TASK [ensure control host tar] OK
TASK [prepare required packages] CHANGED
TASK [validate mha_go settings] OK
TASK [make MySQL replication] CHANGED
TASK [install and enable mha-go] CHANGED
TASK [run dbbot post-deploy checks] OK
PLAY RECAP
db-01 primary ok=14 changed=5 failed=0
db-02 replica ok=12 changed=4 failed=0
db-03 replica ok=12 changed=4 failed=0
✓ MySQL HA workflow delivered · repeatable and auditable
What ships now
Not a concept page, but a database operations base you can run
The source tree is built around Ansible playbooks, default variables, preflight checks, confirmation steps, and post-deploy validation.
MySQL delivery
Standalone, replication, MHA-Go, MGR, InnoDB Cluster, Router, and variable references for MySQL / Percona / GreatSQL.
Backup and recovery loop
MySQL 8.4 backup scripts, PITR, restore validation, and dangerous-operation confirmation put recovery on the same level as backup.
Observability integration
Prometheus, Grafana, Alertmanager, node_exporter, mysqld_exporter, and mysqlrouter_exporter are part of the deployment chain.
ClickHouse downstream
Standalone, cluster, backup, restore, and drill workflows bring MySQL downstream analytics into the same automation toolchain.
Ecosystem
Companion open-source projects by the same author
These projects evolve with dbbot and can be used together or shipped independently.
Go · Failover
MHA-Go Manager
mha_go is a Go rewrite of MHA manager, shipped as one static binary plus one YAML file. dbbot's mha_go.yml playbook orchestrates it directly.
Ansible · Portable runtime
make_ansible_portable
The build chain behind dbbot's bundled portable-ansible runtime, useful for offline and constrained control hosts.
Windows · Local MySQL
make_win_mysql_portable
A portable MySQL workflow for local Windows development and mixed multi-instance deployments without requiring Docker.
Metrics · MySQL Router
mysqlrouter_exporter
A dedicated exporter for MySQL Router metrics, compatible with dbbot's configuration format and service model.
dbbotctl
The CLI sticks to real lifecycle work
doctor
Checks the install root, state directory, required commands, sshpass, portable Ansible, and exporterregistrar.
env setup / exporter register
Bootstraps portable Ansible and registers node, MySQL, and Router exporters into Prometheus file_sd targets.
release upgrade / rollback
Upgrades from GitHub releases or local packages, captures snapshots first, and rolls back through recorded history.
Official homepage
Productize database operations first, then connect automation entry points.
dbbot's direction is not more scattered scripts. It provides a stable, composable, and auditable execution surface for MySQL ecosystem operations.