# ansible-mysql-replication-keepalived

**Repository Path**: hxzqwe/ansible-mysql-replication-keepalived

## Basic Information

- **Project Name**: ansible-mysql-replication-keepalived
- **Description**: Ansible 快速部署Keepalived与MySQL互为主从集群
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 2
- **Created**: 2024-07-16
- **Last Updated**: 2025-03-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Ansible 快速部署Keepalived与MySQL互为主从集群

本项目是根据 `Keepalived与MySQL互为主从自动切换配置.md`文档关于如何部署 `Keepalived与MySQL互为主从集群`改造成的ansible项目

支持以下操作系统:

- CentOS 7
- RedHat 7

## 使用说明

### 下载本项目到ansible服务器

```bash
git clone https://gitee.com/hxzqwe/ansible-mysql-replication-keepalived.git
```

### 修改hosts.yaml配置文件

```yaml
[mysql]
10.1.75.11 master=true
10.1.75.12 slave=true
```

> **修改被控端mysql主服务和mysql从服务器的ip**

### 修改vars.yaml配置文件

```yaml
# mysql
mysql_version: mysql-5.7.42-linux-glibc2.12-x86_64
mysql_install_path: /usr/local
data_path: /data
mysql_sock: /data/mysql/mysql.sock
mysql_port: 3306
mysql_root_passwd: 123456
repl_user: replication
repl_passwd: replication
log_error: mysql.log

master_ip: 10.1.75.11
slave_ip: 10.1.75.12

# keepalived
interface: eth0
vip: 10.1.75.10
```

> **根据自己实际情况修改以上的配置，如：数据库管理员密码、ip地址、网卡名等**

* 开始部署

方式一：使用常规安装好的ansible软件部署该项目

> 要求ansible版本2.13+

```bash
cd ansible-mysql-replication-keepalived
ansible-playbook -i hosts playbook.yaml --ssh-extra-args '-o StrictHostKeyChecking=no'
```

方式二：使用docker运行ansible容器部署该项目

> 使用的ansible镜像的github源码 https://github.com/devture/docker-ansible

```bash
# 切换目录
cd ansible-mysql-replication-keepalived

# 使用docker运行ansible容器部署该项目
docker run --rm \
--network host \
-w /work \
-v `pwd`:/work \
-v  /root/.ssh/id_rsa:/root/.ssh/id_rsa:ro \
devture/ansible:2.13.6-r0-3 \
ansible-playbook -i hosts playbook.yaml --ssh-extra-args '-o StrictHostKeyChecking=no'
```