python集群_python部署galery集群

importpexpectimportosimportconfigparser

HOSTNAME_DB1='db1'HOSTNAME_DB2='db2'HOSTNAME_DB3='db3'DB1= '192.168.254.24'DB2= '192.168.254.27'DB3= '192.168.254.36'PORT= 22USERNAME= 'root'PASSWORD= 'root'server3_cnf= 'sed -i "s/wsrep_node_name = db1/wsrep_node_name = db3/g" /etc/my.cnf.d/server.cnf;sed -i "s/wsrep_node_address = %s/wsrep_node_address = %s/g" /etc/my.cnf.d/server.cnf' %(DB1,DB3)

server2_cnf= 'sed -i "s/wsrep_node_name = db1/wsrep_node_name = db3/g" /etc/my.cnf.d/server.cnf;sed -i "s/wsrep_node_address = %s/wsrep_node_address = %s/g" /etc/my.cnf.d/server.cnf' %(DB1,DB3)defconfig_parse():

config=configparser.ConfigParser()

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

config.set('galera','wsrep_on','ON')

config.set('galera','wsrep_provider','/usr/lib64/galera/libgalera_smm.so')

config.set('galera','wsrep_cluster_address','"gcomm://%s,%s,%s"' %(DB1, DB2, DB3))

config.set('galera','wsrep_node_name','%s' %HOSTNAME_DB1 )

config.set('galera','wsrep_node_address','%s' %DB1)

config.set('galera','binlog_format','row')

config.set('galera','default_storage_engine','InnoDB')

config.set('galera','innodb_autoinc_lock_mode','2')

config.set('galera','wsrep_slave_threads','1')

config.set('galera','innodb_flush_log_at_trx_commit','1')

config.set('galera','innodb_buffer_pool_size','120M')

config.set('galera','wsrep_sst_method','rsync')

config.set('galera','wsrep_causal_reads','ON')

config.write(open('/etc/my.cnf.d/server.cnf','w'))defcp_server_cnf():

child1= pexpect.spawn('scp /etc/my.cnf.d/server.cnf %s@%s:/etc/my.cnf.d/server.cnf' %(USERNAME,DB2))

child1.expect('password:')

child1.sendline(PASSWORD)

child1.interact()

child1.close()

child2= pexpect.spawn('scp /etc/my.cnf.d/server.cnf %s@%s:/etc/my.cnf.d/server.cnf' %(USERNAME,DB3))

child2.expect('password:')

child2.sendline(PASSWORD)

child2.interact()

child2.close()defconn_db(ip,cnf):

child3= pexpect.spawn('ssh %s@%s' %(USERNAME, ip))

child3.expect('password:')

child3.sendline('root')

child3.expect('#')

child3.sendline(cnf)

child3.expect('#')

child3.sendline('systemctl restart mariadb > /dev/null')

child3.sendline('exit')

child3.interact()

child3.close()definit_cmd():

res1= os.system('service mariadb stop')

res2= os.system('mysqld_safe --wsrep_cluster_address=gcomm://%s,%s,%s >/dev/null &' %(DB1, DB2, DB3))

res3= os.system('galera_new_cluster &>/dev/null')if res2 ==0:print('galera初始化完成')if res3 ==0:print('galera集群已经启动')else:print('galera集群启动失败')else:print('galera初始化失败！')defmain():

config_parse()

cp_server_cnf()

init_cmd()

conn_db(DB2,server2_cnf)

conn_db(DB3,server3_cnf)if __name__ == '__main__':

main()