import configparser

import os

def config_mariadb_yum():

    exists = os.path.exists('/etc/yum.repos.d/mariadb.repo')

    if exists:

        print('mariadb.repo文件已经存在')

        yum_install_mariadb()

    else:

        config = configparser.ConfigParser()

        config.read('/etc/yum.repos.d/mariadb.repo', encoding='utf-8')

        config.add_section('mariadb')

        config.set('mariadb', 'name', 'MariaDB')

        config.set('mariadb', 'baseurl', 'http://mirrors.ustc.edu.cn/mariadb/yum/10.3/centos7-amd64/')

        config.set('mariadb', 'gpgkey', 'http://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB')

        config.set('mariadb', 'gpgcheck', '')

        config.write(open("/etc/yum.repos.d/mariadb.repo", "w"))

        yum_install_mariadb()

def yum_install_mariadb():

        res1 = os.system('yum install MariaDB -y > /dev/null 2&>1')

        if res1 == 0:

            config = configparser.ConfigParser()

            config.read('/etc/my.cnf.d/server.cnf', encoding='utf-8')

            config.set('server','server_id','')

            config.set('server','log-bin','mysql-bin')

            config.write(open("/etc/my.cnf.d/server.cnf", "w"))

            res2 = os.system('service mariadb restart')

            if res2 == 0:

                os.system('mysql_secure_installation')

                os.system('''mysql -uroot -proot -e "grant replication slave on *.* to 'slave'@'%' identified by 'slave'"''')

                os.system("mysql -uroot -proot -e 'show master status'")

def main():

    config_mariadb_yum()

if __name__ == '__main__':

    main()

import configparser

import os

master_ip = input('master_ip:').strip()

log_file = input('log_file:').strip()

pos = input('pos:').strip()

def config_mariadb_yum():

    exists = os.path.exists('/etc/yum.repos.d/mariadb.repo')

    if exists:

        print('mariadb.repo文件已经存在')

        yum_install_mariadb()

    else:

        config = configparser.ConfigParser()

        config.read('/etc/yum.repos.d/mariadb.repo', encoding='utf-8')

        config.add_section('mariadb')

        config.set('mariadb', 'name', 'MariaDB')

        config.set('mariadb', 'baseurl', 'http://mirrors.ustc.edu.cn/mariadb/yum/10.3/centos7-amd64/')

        config.set('mariadb', 'gpgkey', 'http://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB')

        config.set('mariadb', 'gpgcheck', '')

        config.write(open("/etc/yum.repos.d/mariadb.repo", "w"))

        yum_install_mariadb()

def yum_install_mariadb():

        res1 = os.system('yum install MariaDB -y > /dev/null 2&>1')

        if res1 == 0:

            config = configparser.ConfigParser()

            config.read('/etc/my.cnf.d/server.cnf', encoding='utf-8')

            config.set('server','server_id','')

            config.write(open("/etc/my.cnf.d/server.cnf", "w"))

            res2 = os.system('service mariadb restart')

            if res2 == 0:

                os.system('mysql_secure_installation')

                os.system('''mysql -uroot -proot -e "CHANGE MASTER TO MASTER_HOST='%s', MASTER_USER='slave', MASTER_PASSWORD='slave', MASTER_LOG_FILE='%s', MASTER_LOG_POS=%s"''' % (master_ip,log_file,pos))

                os.system("mysql -uroot -proot -e 'start slave;'")

def main():

    config_mariadb_yum()

if __name__ == '__main__':

    main()