基于MySQL协议的数据库运维代理系统设计  

Design of database operation and maintenance agent system based on MySQL protocol

作　　者：刘鼎立 许贵林 杨悦 余弦 LIU Dingli;XU Guilin;YANG Yue;YU Xian(Guangxi Vocational and Technical College of Natural Resources,Nanning 532100,China;Nanning Normal University,Nanning 532100,China)

机构地区：[1]广西自然资源职业技术学院,广西南宁532100 [2]南宁师范大学,广西南宁532100

出　　处：《无线互联科技》2024年第20期57-61,共5页Wireless Internet Science and Technology

基　　金：广西科技重大专项,项目名称:空天地一体协同重大灾害应急智慧服务平台研发与应用示范,项目编号:桂科AA22067072;南宁师范大学博士科研启动费(许贵林)项目,项目编号:602021239135。

摘　　要：数据库是重大灾害应急智慧服务平台的重要组成部分,但数据库管理工作存在诸多问题,主要表现为缺乏权限监管、账号共用、数据泄露等。为了强化数据库的安全性,监管运维管理人员的数据库操作行为,文章基于MySQL通信协议,针对国内广泛应用的MySQL数据库开发设计运维代理系统。该系统的重点设计内容包括系统整体架构、功能需求、通信协议的解析方式以及高危SQL命令的识别方法。该系统的主要功能涵盖权限配置、安全认证、监控审计。经过测试,在满足各项功能的前提下,数据库运维代理系统显示出良好的响应速度和高危SQL命令识别效率,能够达到设计预期。The database is an important component of the major disaster emergency intelligent service platform,but there are many problems in database management,mainly manifesting as lack of permission supervision,account sharing,data leakage,etc.In order to enhance the security of the database and regulate the database operation behavior of operation and maintenance management personnel,based on the MySQL communication protocol,this paper develops and designs an operation and maintenance agent system for the widely used MySQL database in China.The key design content includes the overall system architecture,functional requirements,communication protocol parsing methods,and identification methods for high-risk SQL commands.The main functions of this system include permission configuration,security authentication,and monitoring and auditing.After testing,under the premise of meeting various functions,the database operation and maintenance agent system shows good response speed and efficiency in identifying high-risk SQL command,which can meet the design expectation.

关 键 词：数据库代理 MySQL协议 SQL语句识别处理 数据脱敏 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]