def mysql_install(host,user,password): oper_type = '安装mysql数据库' server_type = 'Mysql' task_id = uuid.uuid1() task_name = '%s:mysql_install' % host args = 'host:' + host + ',' + 'user:' + user + ',' + 'password:' + password tools.begin_task(task_id, oper_type, server_type, host, task_name, args) mysql.mysql_install(host, user, password) result = '' state = 'SUCCESS' tools.end_task(task_id, result, state)
def oracle_startup(tags,host,user,password): oper_type = '启动oracle数据库' server_type = 'Oracle' task_id = uuid.uuid1() task_name = '%s:oracle_startup' %tags args = 'host:' + host + ',' + 'user:' + user + ',' + 'password:' + password tools.begin_task(task_id,oper_type,server_type,tags,task_name,args) oracle.oracle_startup(host,user,password) result = '' state = 'SUCCESS' tools.end_task(task_id,result,state)
def get_report(tags,url,user,password,report_type,begin_snap,end_snap): oper_type = 'Oracle性能报告' server_type = 'Oracle' task_id = uuid.uuid1() task_name = '%s:oracle_rpt' %tags args = 'tags:' + tags + ',' + 'url:' + url + ',' + 'user:' + user \ + ',' + 'password:' + password + ',' + 'report_type:' + report_type + ',' + 'begin_snap:' + begin_snap +',' + 'end_snap:' + end_snap tools.begin_task(task_id,oper_type,server_type,tags,task_name,args) oracle.get_report(tags,url,user,password,report_type,begin_snap,end_snap) result = '' state = 'SUCCESS' tools.end_task(task_id,result,state)
def oracle_switchover(primary_tags,p_host,p_user,p_password,standby_tags,s_host,s_user,s_password): oper_type = 'Oracle容灾切换' server_type = 'Oracle' task_id = uuid.uuid1() task_name = '%s<-->%s:oracle_switchover' %(primary_tags,standby_tags) args = 'p_host:' + p_host + ',' + 'p_user:' + p_user + ',' + 'p_password:' + p_password \ + ',' + 's_host:' + s_host + ',' + 's_user:' + s_user + ',' + 's_password:' + s_password tools.begin_task(task_id,oper_type,server_type,primary_tags + ',' +standby_tags,task_name,args) oracle.oracle_switchover(p_host,p_user,p_password,s_host,s_user,s_password) result = '' state = 'SUCCESS' tools.end_task(task_id,result,state)
def oracle_startup(tags, host, user, password, ssh_port, version): oper_type = '启动oracle数据库' server_type = 'Oracle' task_id = uuid.uuid1() task_name = '%s:oracle_startup' % tags args = 'host:' + host + ',' + 'user:' + user + ',' + 'password:' + password + ', ' + \ 'ssh_port: ' + str(ssh_port) + ', ' + 'version: ' + version tools.begin_task(task_id, oper_type, server_type, tags, task_name, args) oracle.oracle_startup(host, user, password, ssh_port, version) result = '' state = 'SUCCESS' tools.end_task(task_id, result, state)
def mysql_install(host, user, password, data_path, mysql_base, port): oper_type = '安装MySQL数据库' server_type = 'MySQL' task_id = uuid.uuid1() task_name = '%s:mysql_install' % host args = 'host:' + host + ',' + 'user:' + user + ',' + 'password:' + password + \ 'data_path: ' + data_path + 'mysql_base: ' +mysql_base + 'port: ' + port tools.begin_task(task_id, oper_type, server_type, host, task_name, args) mysql_ins.mysql_install(host, user, password, data_path, mysql_base, port) result = '' state = 'SUCCESS' tools.end_task(task_id, result, state)
def mysql_fullbackup(tags,host,user,password,user_os,password_os,mysql_path,bakdir): oper_type = 'Mysql全量备份' server_type = 'Mysql' task_id = uuid.uuid1() task_name = '%s:mysql_fullbak' %tags args = 'tags:' + tags + ',' + 'host:' + host + 'user:' + user_os\ + ',' + 'password:' + password_os + ',' + 'mysql_path:' + mysql_path + ',' + 'bakdir:' + bakdir tools.begin_task(task_id,oper_type,server_type,tags,task_name,args) mysql_bak.mysql_fullbackup(host,user,password,user_os,password_os,mysql_path,bakdir) result = '' state = 'SUCCESS' tools.end_task(task_id,result,state)
def oracle_logmnr(tags, url, user, password, schema, object, operation, log_list): oper_type = 'oracle日志挖掘' server_type = 'Oracle' task_id = uuid.uuid1() task_name = '%s:oracle_logmnr' % tags args = 'tags:%s url:%s user:%s password:%s schema:%s bject:%s operation:%s' % ( tags, url, user, password, schema, object, operation) tools.begin_task(task_id, oper_type, server_type, tags, task_name, args) oracle.oracle_logmnr(url, user, password, schema, object, operation, log_list) result = '' state = 'SUCCESS' tools.end_task(task_id, result, state)
def oracle_fullbackup(tags, host, user, password, user_os, password_os, service_name, url, bakdir, backup_retain_day, arch_keep_days): oper_type = 'Oracle全量备份' server_type = 'Oracle' task_id = uuid.uuid1() task_name = '%s:oracle_fullbak' % tags args = 'tags:' + tags + ',' + 'host:' + host + 'user:' + user_os\ + ',' + 'password:' + password_os + ',' + 'bakdir:' + bakdir + ',' + 'sid:' + service_name +',' + 'backup_retain_day:' + backup_retain_day + 'arch_keep_days:' + arch_keep_days tools.begin_task(task_id, oper_type, server_type, tags, task_name, args) oracle_bak.oracle_fullbackup(host, user_os, password_os, bakdir, service_name, backup_retain_day, arch_keep_days) result = '' state = 'SUCCESS' tools.end_task(task_id, result, state)