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.