# geerlingguy/ansible-role-mysql

Ansible Role - MySQL

Repository: https://github.com/geerlingguy/ansible-role-mysql
Canonical: https://ross.abutalabs.com/products/ansible-role-mysql
Homepage: https://galaxy.ansible.com/geerlingguy/mysql/
Language: Jinja
License: MIT
License Family: permissive
Topics: mysql, ansible, role, database, mariadb, playbook
Last push: 2026-07-31T02:41:47+00:00

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

## Adoption (not part of the score)
Stars 1130, forks 891 (observed 2026-08-28T04:03:42.340279+00:00)

## What it is
A widely used Ansible role that installs and configures MySQL or MariaDB servers on RHEL/CentOS and Debian/Ubuntu systems. It exposes many variables for managing users, databases, configuration files, and startup behavior.

## Use cases
- install mysql server with ansible
- provision mariadb on ubuntu playbook
- configure mysql users and databases via ansible
- automate database server setup on centos
- manage my.cnf configuration with ansible role

## When to choose
- you use Ansible and need repeatable MySQL/MariaDB installation on RHEL or Debian-based servers
- you want a battle-tested role with extensive configuration variables
- you need to manage databases, users, and config files declaratively

## When to avoid
- you don't use Ansible for infrastructure automation
- you need MySQL on non-Linux platforms
- you require highly customized or clustered database setups beyond the role's scope

## Facets
- artifact type: infra-config
- maturity: active
- function: configuration-management, database, deployment
- domain: databases, infrastructure-as-code
- platform: self-hosted
- tags: ansible-role, mysql, mariadb, ansible-galaxy, provisioning, devops, linux, docker

## Member repositories
- geerlingguy/ansible-role-mysql (main) score 75

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:42.340279+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:38:15.027022+00:00, confidence not recorded.
  - readme: https://github.com/geerlingguy/ansible-role-mysql (fetched 2026-08-28T04:03:42.340279+00:00, sha 51ea7c1635fd)
  - homepage: https://galaxy.ansible.com/geerlingguy/mysql/ (fetched 2026-08-29T12:42:36.266640+00:00, sha d611c676f7a6)
- Data as of 2026-08-30T08:39:29.467469+00:00.