企业运维篇——ansible部署mysql主从复制

最新推荐文章于 2025-06-29 21:45:20 发布

独听钟声晚

最新推荐文章于 2025-06-29 21:45:20 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

文章标签： ansiable mysql

本文链接：https://blog.youkuaiyun.com/weixin_44321116/article/details/91042646

这篇博客详细介绍了如何运用Ansible自动化工具进行MySQL主从复制的部署，包括设置免密连接、测试连接、创建目录和配置执行脚本等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[root@server1 ~]# ls
ansible-2.7.8-1.el7.noarch.rpm
ansible-tower-setup-bundle-3.4.2-1.el7.tar.gz
libtomcrypt-1.17-25.el7.x86_64.rpm
libtommath-0.42.0-5.el7.x86_64.rpm
python2-crypto-2.6.1-13.el7.x86_64.rpm
python2-jmespath-0.9.0-1.el7.noarch.rpm
python-httplib2-0.9.2-0.1.el7.noarch.rpm
python-keyczar-0.71c-2.el7.noarch.rpm
python-paramiko-2.1.1-0.9.el7.noarch.rpm
sshpass-1.06-1.el7.x86_64.rpm
[root@server1 ~]# yum install -y *

在这里插入图片描述

[root@server1 ~]# cd /etc/ansible/
[root@server1 ansible]# ls
ansible.cfg  hosts  roles
[root@server1 ansible]# vim hosts
[master]
server1

[slave]
server2

在这里插入图片描述

测试ping模块：先ping——>输入yes，再加-k参数

[root@server1 ansible]# ansible server1 -m ping
The authenticity of host 'server1 (172.25.70.1)' can't be established.
ECDSA key fingerprint is 23:30:b9:0b:bd:7e:c3:05:4e:9a:fb:6f:c5:d6:23:c9.
Are you sure you want to continue connecting (yes/no)? yes
server1 | UNREACHABLE! => {
    "changed": false, 
    "msg": "Failed to connect to the host via ssh: Warning: Permanently added 'server1,172.25.70.1' (ECDSA) to the list of known hosts.\r\nPermission denied (publickey,gssapi-keyex,gssapi-with-mic,password).", 
    "unreachable": true
}
[root@server1 ansible]# ansible server1 -m ping -k
SSH password: 
server1 | SUCCESS => {
    "changed": false, 
    "ping": "pong"
}

在这里插入图片描述

  [root@server1 ansible]# ansible server2 -m ping
    The authenticity of host 'server2 (172.25.70.2)' can't be established.
    ECDSA key fingerprint is 23:30:b9:0b:bd:7e:c3:05:4e:9a:fb:6f:c5:d6:23:c9.
    Are you sure you want to continue connecting (yes/no)? yes
    server2 | UNREACHABLE! => {
        "changed": false, 
        "msg": "Failed to connect to the host via ssh: Warning: Permanently added 'server2,172.25.70.2' (ECDSA) to the list of known hosts.\r\nPermission denied (publickey,gssapi-keyex,gssapi-with-mic,password).", 
        "unreachable": true
    }
    [root@server1 ansible]# ansible server2 -m ping -k
    SSH password: 
    server2 | SUCCESS =&