I'll cut to the chase, so let's get right to the code~
# !/usr/bin/env python # -*- coding:utf-8 -*- __author__ = '_X.xx_' __date__ = '2018/7/18 16:44' from import JsonResponse class HttpCode(object): ok = 200 paramserror = 400 unantu = 401 methoderror = 405 servererror = 500 def ok(): return result() def result(code=, message='', data=None, kwargs=None): json_dict = {'code': code, 'message': message, 'data': data} if kwargs and isinstance(kwargs, dict) and (): json_dict.update(kwargs) return JsonResponse(json_dict) def params_error(message='', data=None): return result(code=, message=message, data=data) def unauth(message='', data=None): return result(code=, message=message, data=data) def method_error(message='', data=None): return result(code=, message=message, data=data) def server_error(message='', data=None): return result(code=, message=message, data=data)
Additional knowledge:python deployment of galery clusters
Contents of the document
import pexpect import os import configparser 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 = 22 USERNAME = 'root' PASSWORD = 'root' server3_cnf = 'sed -i "s/wsrep_node_name = db1/wsrep_node_name = db3/g" /etc//;sed -i "s/wsrep_node_address = %s/wsrep_node_address = %s/g" /etc//' % (DB1,DB3) server2_cnf = 'sed -i "s/wsrep_node_name = db1/wsrep_node_name = db3/g" /etc//;sed -i "s/wsrep_node_address = %s/wsrep_node_address = %s/g" /etc//' % (DB1,DB3) def config_parse(): config = () ("/etc//", encoding="utf-8") ('galera','wsrep_on','ON') ('galera','wsrep_provider','/usr/lib64/galera/libgalera_smm.so') ('galera','wsrep_cluster_address','"gcomm://%s,%s,%s"' % (DB1, DB2, DB3)) ('galera','wsrep_node_name','%s' % HOSTNAME_DB1 ) ('galera','wsrep_node_address','%s' % DB1) ('galera','binlog_format','row') ('galera','default_storage_engine','InnoDB') ('galera','innodb_autoinc_lock_mode','2') ('galera','wsrep_slave_threads','1') ('galera','innodb_flush_log_at_trx_commit','1') ('galera','innodb_buffer_pool_size','120M') ('galera','wsrep_sst_method','rsync') ('galera','wsrep_causal_reads','ON') (open('/etc//','w')) def cp_server_cnf(): child1 = ('scp /etc// %s@%s:/etc//' % (USERNAME,DB2)) ('password:') (PASSWORD) () () child2 = ('scp /etc// %s@%s:/etc//' % (USERNAME,DB3)) ('password:') (PASSWORD) () () def conn_db(ip,cnf): child3 = ('ssh %s@%s' % (USERNAME, ip)) ('password:') ('root') ('#') (cnf) ('#') ('systemctl restart mariadb > /dev/null') ('exit') () () def init_cmd(): res1 = ('service mariadb stop') res2 = ('mysqld_safe --wsrep_cluster_address=gcomm://%s,%s,%s >/dev/null &' % (DB1, DB2, DB3)) res3 = ('galera_new_cluster &>/dev/null') if res2 == 0: print('galera initialization complete') if res3 == 0: print('The galera cluster has been started') else: print('galera cluster startup failed') else: print('galera initialization failed!') def main(): config_parse() cp_server_cnf() init_cmd() conn_db(DB2,server2_cnf) conn_db(DB3,server3_cnf) if __name__ == '__main__': main()
Above this Django encapsulated interactive interface code is all I have to share with you, I hope to give you a reference, and I hope you support me more.