MySQL数据库自动化运维管理系统的设计与实现
Automated operation and maintenance management system for MySQL database
昝国宁 1王雨晴 1刘娇龙 1张泽明 1张靖宇1
作者信息
- 1. 中铁信大数据科技有限公司,天津 301737
- 折叠
摘要
为解决中国铁路主数据中心MySQL数据库运行维护(简称:运维)工作量大、操作频繁、效率低、运维安全性不高等问题,采用远程控制、定时任务调度、数据管理和数据可视化等技术,设计了MySQL数据库自动化运维管理系统.该系统具有对MySQL数据库的主机管理、运行监控、任务执行、告警展示等功能,提高了MySQL数据库的运维工作效率,以及MySQL数据库的安全性,有助于增强铁路信息化基础设施自动运维能力,保障铁路信息系统的稳定运行.
Abstract
To solve the problems of heavy workload,frequent operations,low efficiency,and low security in the operation and maintenance of MySQL database in China Railway Main Data Center,this paper adopted remote control,scheduled task scheduling,data management,and data visualization technologies to design an automated operation and maintenance management system for MySQL database.The system has functions such as host management,operation monitoring,task execution,and alarm display for MySQL database,which improved the efficiency of MySQL database operation and maintenance,as well as the security of MySQL database.It helps to enhance the automatic operation and maintenance capabilities of railway information infrastructure and ensure the stable operation of railway information systems.
关键词
MySQL数据库/Ansible工具/自动化运维/基础设施运维/管理系统Key words
MySQL database/Ansible tool/automatic operation and maintenance/infrastructure operation and maintenance/management system引用本文复制引用
基金项目
中国铁路信息科技集团有限公司科技研究开发计划重大课题(WJZG-CKY-20230062023A01)
出版年
2024
NETL
NSTL
万方数据