我就廢話不多說(shuō)了，大家還是直接看代碼吧~
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
# !/usr/bin/env python # -*- coding:utf-8 -*-__author__ = '_X.xx_'__date__ = '2018/7/18 16:44' from django.http import JsonResponse class HttpCode(object): ok = 200 paramserror = 400 unantu = 401 methoderror = 405 servererror = 500 def ok(): return result() def result(code=HttpCode.ok, message='', data=None, kwargs=None): json_dict = {'code': code, 'message': message, 'data': data} if kwargs and isinstance(kwargs, dict) and kwargs.keys(): json_dict.update(kwargs) return JsonResponse(json_dict) def params_error(message='', data=None): return result(code=HttpCode.paramserror, message=message, data=data) def unauth(message='', data=None): return result(code=HttpCode.unantu, message=message, data=data) def method_error(message='', data=None): return result(code=HttpCode.methoderror, message=message, data=data) def server_error(message='', data=None): return result(code=HttpCode.servererror, message=message, data=data) |
補(bǔ)充知識(shí)：python部署galery集群
galery.py文件內(nèi)容
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
|
import pexpectimport osimport configparserHOSTNAME_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)def config_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'))def 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() 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()def conn_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()def init_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集群已經(jīng)啟動(dòng)') else: print('galera集群?jiǎn)?dòng)失敗') else: print('galera初始化失敗！')def main(): config_parse() cp_server_cnf() init_cmd() conn_db(DB2,server2_cnf) conn_db(DB3,server3_cnf)if __name__ == '__main__': main() |
以上這篇Django封裝交互接口代碼就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持服務(wù)器之家。
原文鏈接：https://blog.csdn.net/weixin_41827390/article/details/81286154
