# Ansible-MySQL

**Repository Path**: gitchenghe/ansible-mysql

## Basic Information

- **Project Name**: Ansible-MySQL
- **Description**: 使用ansible自动安装配置MySQl MGR集群
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 4
- **Forks**: 3
- **Created**: 2021-11-05
- **Last Updated**: 2024-09-12

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

 **通过ansible自动安装并配置MySQL 8.0 MGR集群** 

1. 准备工作
  准备三台服务器主机名分别为
| 主机名        | IP              | 角色|
|--------------|-----------------|---- |
| MySQL-Master | 192.168.59.101  | 主  |
| MySQL-Slave1 | 192.168.59.102  | 从  |
| MySQL-Slave2 | 192.168.59.103  | 从  |

 三台主机分别添加hosts解析
 
```
cat >> /etc/hosts <<EOF
 192.168.59.101 MySQL-Master
 192.168.59.102 MySQL-Slave1
 192.168.59.103 MySQL-Slave2
EOF
```

2. 编写 ansible hosts 清单文件

```
  cat >> hosts <<EOF
 [mysq_dbs]
 192.168.59.101 role=mgr_primary
 192.168.59.102 role=mgr_second
 192.168.59.103 role=mgr_second
 EOF
```

3. 执行安装命令
 `ansible-playbook -i hosts  install_mysql.yaml`