python部署galery集群

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了python部署galery集群，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2857字，纯文字阅读大概需要5分钟。

内容图文

galery.py文件内容

import pexpect 
import os  
import configparser

HOSTNAME_DB1='db1'
HOSTNAME_DB2='db2'
HOSTNAME_DB3='db3'


DB1 = '192.168.254.30'
DB2 = '192.168.254.31'
DB3 = '192.168.254.39'
PORT = 22
USERNAME = 'root'
PASSWORD = 'root'
#DB1
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'))
res = os.system('galera_new_cluster &>/dev/null')
if res == 0:
    #cp 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()

    child3 = pexpect.spawn('scp /etc/my.cnf.d/server.cnf %s@%s:/etc/my.cnf.d/server.cnf' % (USERNAME,DB3)
)
    child3.expect('password:')
    child3.sendline(PASSWORD)
    child3.interact()
    child3.close()
#connect DB2
    child3 = pexpect.spawn('ssh %s@%s' % (USERNAME, DB2))
    child3.expect('password:')
    child3.sendline('root')
    child3.expect('#')
    child3.sendline('sed -i "s/wsrep_node_name = db1/wsrep_node_name = db2/g" /etc/my.cnf.d/server.cnf;se
d -i "s/wsrep_node_address = 192.168.254.30/wsrep_node_address = 192.168.254.31/g" /etc/my.cnf.d/server.c
nf')
    child3.expect('#')
    child3.sendline('systemctl restart mariadb > /dev/null')
    child3.sendline('exit')
    child3.interact()
    child3.close()


    #connect DB3
    child4 = pexpect.spawn('ssh %s@%s' % (USERNAME, DB3))
    child4.expect('password:')
    child4.sendline('root')
    child4.expect('#')
    child4.sendline('sed -i "s/wsrep_node_name = db1/wsrep_node_name = db3/g" /etc/my.cnf.d/server.cnf;se
d -i "s/wsrep_node_address = 192.168.254.30/wsrep_node_address = 192.168.254.39/g" /etc/my.cnf.d/server.c
nf')
    child4.expect('#')
    child4.sendline('systemctl restart mariadb > /dev/null')
    child4.sendline('exit')
    child4.interact()
    child4.close()
    print('galera集群配置完成')
else:
    print('galera服务启动故障')

server_db2.conf

[server]

[mysqld]

[galera]
wsrep_on = ON
wsrep_provider = /usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address = "gcomm://192.168.254.30,192.168.254.31,192.168.254.39"
wsrep_node_name = db2 
wsrep_node_address = 192.168.254.31
binlog_format = row 
default_storage_engine = InnoDB
innodb_autoinc_lock_mode = 2 
wsrep_slave_threads = 1 
innodb_flush_log_at_trx_commit = 1 
innodb_buffer_pool_size = 120M
wsrep_sst_method = rsync
wsrep_causal_reads = ON

[embedded]

[mariadb]

[mariadb-10.3]

内容总结

以上是互联网集市为您收集整理的python部署galery集群全部内容，希望文章能够帮你解决python部署galery集群所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端