cencenhai 发表于 2018-7-29 08:30:09

mydumper-0.9.1

主  
cat /home/mysqlbak/mydumper/backup.sh
  
#!/bin/bash
  
rm -rf /home/mydumper /home/mydumper.tar.gz
  
mkdir -p /home/mydumper
  
array=(a b c d)
  
#库名
  
for num in "${array[@]}"
  
do
  
mydumper -u root -S /home/3306/mysql.sock -p 'password' -B $num -o /home/mydumper
  
done
  
cd /home && tar cvzf mydumper.tar.gz mydumper
  

  
ansible机器
  
cat myloader.yml
  
- hosts: "{{hosts}}"
  
remote_user: root
  
gather_facts: no
  
tasks:
  
- name: mysql
  
    shell: rm -rf /home/mydumper && cd /home && tar xvzf mydumper.tar.gz
  
- name: myloader
  
    shell: myloader -u root -S /opt/{{ mport }}/mysql.sock -p password -t 4 -o -d /home/mydumper
  

  

  
对各个环境mydumper的安装
  
cat installmydumper.sh
  
#!/bin/bash
  

  
[ -f /usr/local/bin/mydumper ] && exit 0
  

  
yum install gcc-c++ cmake glib2-devel pcre-devel.x86_64 -y
  
yum -y install zlib-devel
  
yum -y install zlib
  
cd /opt/soft
  
tar -zxvf mydumper-0.9.1.tar.gz -C /usr/local/
  
cd /usr/local/mydumper-0.9.1
  
cmake .
  
make && make install
页: [1]
查看完整版本: mydumper-0.9.1