python管理mysql，请叫我雷锋

       elif command == "check":

           diffvariavles(instance_name)

       elif command == "abjust":

           variable=args[0]

           value=args[1]

           setVariable(instance_name,variable,value)

       elif command == "backup":

           backupMySQL(instance_name)

       elif command == "restore":

           serverid=args[0]

           master_host=args[1]

           master_port=args[2]

           master_user=EPLICATION_USER

           master_password=EPLICATION_PASS

           sqlfile=args[3]

           #master_log_file,master_log_pos=getLogPos(sqlfile)

           master_log_file,master_log_pos=get_log_pos(sqlfile)

           mysqld_options={"server-id":serverid}

           mysqld_options["replicate-ignore-db"]="mysql"

           mysqld_options["skip-slave-start"]=None

           restoreMySQL(instance_name,instance_port,sqlfile,**mysqld_options)

           cur=connMySQL(instance_name)

           changeMaster(cur,master_host,master_port,master_user,master_password,master_log_file,master_log_pos)

   else:

       print >> sys.stderr,"\033[31;1mcommand is not found! please ‘create/start/stop/status/check/abjust/backup/restore‘\033[0m"

if __name__ =="__main__":

   main()

本文出自 “” 博客，请务必保留此出处

python管理mysql，请叫我雷锋,布布扣,bubuko.com