Operation and maintenance automatic backup system and method

Abstract

The invention relates to the technical field of data backup and disaster recovery, in particular to an automatic backup system and method for operation and maintenance, and the system comprises file data backup, Nacos configuration backup and database table logic backup. The method has the advantages that safe and efficient remote backup storage is achieved through the SFTP, timing backup of application data, service data, logs and configuration files is supported, and a backup strategy can be flexibly configured through keyword fuzzy matching and specified name filtering. Meanwhile, the system provides an HTTP (Hyper Text Transport Protocol) interface docking short message pushing service, notifies an administrator of a backup state in real time, supports online visual query of a backup result, and greatly improves the operation and maintenance efficiency. At present, the scheme has been successfully applied in a communication system, the data loss risk is effectively reduced, manual intervention is reduced, and reliable guarantee is provided for service continuity.

Description

Technical Field

[0001] This invention relates to the field of data backup and disaster recovery technology, specifically to an automated backup system and method for operation and maintenance. Background Technology

[0002] In the fields of communication systems and enterprise IT operations, data backup is a critical link in ensuring business continuity and disaster recovery. Traditional backup solutions usually rely on manual operation or simple scheduled scripts, which have problems such as low efficiency, poor reliability, and lack of real-time monitoring. Especially in distributed systems and massive data scenarios, they are difficult to meet the requirements of automation and high availability. Summary of the Invention

[0003] The purpose of this invention is to provide an automated backup system and method for operation and maintenance, to solve key problems of traditional backup solutions in communication systems and enterprise IT environments, such as slow recovery speed, poor data consistency, and insufficient disaster recovery capabilities. Specific objectives include achieving rapid disaster recovery, optimizing disaster recovery management processes, and enhancing system availability monitoring.

[0004] To achieve the above objectives, the present invention provides the following technical solution: an automated operation and maintenance backup system, comprising a file data backup module, wherein the file data backup module performs the following steps: The system reads the file configuration list, processes it iteratively, and compresses folders into .zip archives. During compression, it removes specified directories from the list of directories to be removed before zip compression, based on the fuzzy removal directory configuration. Simultaneously, it removes files and directories in the current directory and all its subdirectories that begin with the fuzzy removal configuration, before compressing the files. Finally, it generates a zip file named with the current timestamp and stores it in a temporary directory. It then uses the FTP protocol to upload the generated zip file to the data backup directory of an FTP server. It deletes the zip file generated in the temporary directory, records the backup results and adds them to the database, and sends a backup success SMS notification.

[0005] Preferably, it also includes a Nacos configuration backup module, which performs the following steps: Read Nacos backup configuration information, call the login interface to obtain a token, use the token to access the configuration download interface, store the downloaded Nacos configuration zip file to a temporary directory; use the FTP protocol to upload the generated zip file to the configuration backup directory of the FTP server; delete the zip file generated in the temporary directory; record the backup result and add it to the database; send a backup success SMS notification.

[0006] Preferably, it also includes a database table logical backup module, which performs the following steps: Read the database backup configuration information and generate a temporary SQL file storage folder in the temporary directory with the current date; read the list of database tables to be backed up, export the table structure and table data, and generate .sql files, placing the generated SQL files in the generated temporary SQL folder; compress the generated temporary SQL folder into a zip file and place it in the temporary directory; upload the generated zip file to the DB backup directory of the FTP server using the FTP protocol; delete the generated zip file and the generated temporary directory in the temporary directory; record the backup results and import them into the database; send a backup success SMS notification.

[0007] Preferably, in the file data backup module, the file configuration item list includes folder path information, removal directory list configuration information, and fuzzy removal directory configuration information; the fuzzy removal directory configuration information is used to specify the starting character characteristics of the files and directories to be removed.

[0008] Preferably, in the file data backup module, the file configuration item list includes folder path information, removal directory list configuration information, and fuzzy removal directory configuration information; the fuzzy removal directory configuration information is used to specify the starting character characteristics of the files and directories to be removed.

[0009] An automated backup method for operations and maintenance includes file data backup steps, as detailed below: Read the file configuration item list, loop through the list, and compress the folder into a .zip package; during the compression process, according to the exclusion directory list configuration in the configuration items, exclude the specified directories and perform the compression operation; at the same time, according to the fuzzy exclusion directory configuration, exclude files and directories in the current directory and all its subordinate subdirectories that start with the fuzzy exclusion configuration, and then compress the files, finally generating a zip file named with the current timestamp and storing it in a temporary directory; The generated zip file is uploaded to the data backup directory of the FTP server using the FTP protocol; Delete the zip file generated in the temporary directory; Record and store the backup results in the database; Send a text message notification that the backup was successful.

[0010] Preferably, the process also includes a Nacos configuration backup step, as follows: Read the Nacos backup configuration information, call the login interface to obtain a token, use the token to access the configuration download interface, and store the downloaded Nacos configuration zip file to a temporary directory; Use the FTP protocol to upload the generated zip file to the configuration backup directory of the FTP server; Delete the zip file generated in the temporary directory; Record and store the backup results in the database; Send a text message notification that the backup was successful.

[0011] Preferably, it also includes a logical backup step for the database tables, as follows: Read the database backup configuration information and generate a temporary SQL file storage folder in the temporary directory with the current date; Read the list of database tables to be backed up, export the table structure and table data and generate an .sql file, and place the generated SQL file in the temporary SQL folder mentioned above; Compress the temporary SQL folder into a zip file and place it in the temporary directory; The generated zip file is uploaded to the DB backup directory of the FTP server using the FTP protocol; Delete the zip file and the temporary SQL folder generated in the temporary directory; Record and store the backup results in the database; Send a text message notification that the backup was successful.

[0012] Preferably, the file configuration item list includes folder path, exclusion directory list configuration, and fuzzy exclusion directory configuration; wherein, the fuzzy exclusion directory configuration is used to specify the starting character characteristics of the files and directories to be excluded, so as to perform accurate exclusion operations during the compression process.

[0013] Preferably, the database backup configuration information includes database connection information and a list of database tables to be backed up; the list of database tables to be backed up is used to accurately specify the names and related attributes of the database tables that need to be backed up, ensuring the integrity and accuracy of the logical backup of the database tables.

[0014] Compared with the prior art, the beneficial effects of the present invention are: The automated backup system and method proposed in this invention employs the SFTP protocol to achieve secure and efficient off-site backup storage. It supports scheduled backups of application data, business data, logs, and configuration files, and allows for flexible configuration of backup strategies through keyword fuzzy matching and specified name filtering. Simultaneously, the system provides an HTTP interface to integrate with SMS push services, notifying administrators of backup status in real time and supporting online visual querying of backup results, significantly improving operational efficiency. Currently, this solution has been successfully applied in communication systems, effectively reducing the risk of data loss, minimizing manual intervention, and providing reliable assurance for business continuity. Attached Figure Description

[0015] Figure 1 This is a flowchart of the method of the present invention. Detailed Implementation

[0016] To make the objectives, technical solutions, and advantages of the present invention clear and complete, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are only some, not all, embodiments of the present invention, and are merely illustrative of the embodiments of the present invention. They are not intended to limit the embodiments of the present invention. All other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0017] Example 1: This invention provides a technical solution: an automated operation and maintenance backup system, including a file data backup module, wherein the file data backup module performs the following steps: The system reads the file configuration list, processes it iteratively, and compresses folders into .zip archives. During compression, it removes specified directories from the list of directories to be removed before zip compression, based on the fuzzy removal directory configuration. Simultaneously, it removes files and directories in the current directory and all its subdirectories that begin with the fuzzy removal configuration, before compressing the files. Finally, it generates a zip file named with the current timestamp and stores it in a temporary directory. It then uses the FTP protocol to upload the generated zip file to the data backup directory of an FTP server. It deletes the zip file generated in the temporary directory, records the backup results and adds them to the database, and sends a backup success SMS notification.

[0018] It also includes a Nacos configuration backup module, which performs the following steps: Read Nacos backup configuration information, call the login interface to obtain a token, use the token to access the configuration download interface, store the downloaded Nacos configuration zip file to a temporary directory; use the FTP protocol to upload the generated zip file to the configuration backup directory of the FTP server; delete the zip file generated in the temporary directory; record the backup result and add it to the database; send a backup success SMS notification.

[0019] It also includes a database table logical backup module, which performs the following steps: Read the database backup configuration information and generate a temporary SQL file storage folder in the temporary directory with the current date; read the list of database tables to be backed up, export the table structure and table data, and generate .sql files, placing the generated SQL files in the generated temporary SQL folder; compress the generated temporary SQL folder into a zip file and place it in the temporary directory; upload the generated zip file to the DB backup directory of the FTP server using the FTP protocol; delete the generated zip file and the generated temporary directory in the temporary directory; record the backup results and import them into the database; send a backup success SMS notification.

[0020] In the file data backup module, the file configuration item list includes folder path information, list of directories to be removed configuration information, and fuzzy removal directory configuration information; the fuzzy removal directory configuration information is used to specify the starting character characteristics of the files and directories to be removed.

[0021] In the logical backup module for database tables, the database backup configuration information includes database connection information and a list of database tables to be backed up. The list of database tables to be backed up is used to specify the names and related attributes of the database tables that need to be backed up.

[0022] Example 2, based on Example 1, proposes an automated backup method for operation and maintenance, including the following steps: A) File data backup 1) Read the file configuration item list, loop through the list to compress the folder into a .zip package; during the compression process, according to the directory removal list configuration in the configuration items, remove the specified directories before zip compression; during the compression process, according to the fuzzy removal directory configuration, remove files and directories in the current directory and all its subdirectories that start with the fuzzy removal configuration, and then compress the files, finally generating a zip file named according to the current timestamp and storing it in a temporary directory.

[0023] 2) Upload the generated zip file to the FTP server's data backup directory using the FTP protocol.

[0024] 3) Delete the zip files generated in the temporary directory.

[0025] 4) Record the backup results and store them in the database.

[0026] 5) Send a text message notification that the backup was successful.

[0027] B) Nacos configuration backup 1) Read the Nacos backup configuration information, call the login interface to obtain the Token, access the configuration download interface, and download the Nacos configuration zip file to a temporary directory.

[0028] 2) Upload the generated zip file to the FTP server and configure the backup directory using the FTP protocol.

[0029] 3) Delete the zip files generated in the temporary directory.

[0030] 4) Record the backup results and store them in the database.

[0031] 5) Send a text message notification that the backup was successful.

[0032] C) Logical backup of database tables 1) Read the database backup configuration information and generate a temporary SQL file storage folder in the temporary directory with the current date.

[0033] 2) Read the list of database tables to be backed up, export the table structure and table data and generate an .sql file, and then place the SQL file in the temporary SQL folder of step 1).

[0034] 3) Compress the temporary SQL folder from step 1 into a zip file and place it in the temporary directory.

[0035] 4) Upload the generated zip file to the FTP server's DB backup directory using the FTP protocol.

[0036] 5) Delete the zip file generated in the temporary directory and delete the temporary directory from step 1).

[0037] 6) Record the backup results and store them in the database.

[0038] 7) Send a text message notification that the backup was successful.

[0039] Although embodiments of the invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made to these embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the appended claims and their equivalents.

Claims

1. An automated backup system for operation and maintenance, characterized in that: Includes a file data backup module, which performs the following steps: Read the file configuration item list, process the list in a loop, and compress the folder into a .zip package; during the compression process, according to the directory list configuration in the configuration items, remove the specified directories before zip compression; at the same time, according to the fuzzy directory removal configuration, remove files and directories in the current directory and all its subordinate subdirectories that start with the fuzzy removal configuration before compressing the files; finally, generate a zip file named with the current timestamp and store it in a temporary directory; Use the FTP protocol to upload the generated zip file to the data backup directory of the FTP server; Delete the zip file generated in the temporary directory; Record the backup results and store them in the database; Send a text message notification that the backup was successful.

2. The automated backup system for operation and maintenance according to claim 1, characterized in that: It also includes a Nacos configuration backup module, which performs the following steps: Read the Nacos backup configuration information, call the login interface to obtain a token, use the token to access the configuration download interface, and store the downloaded Nacos configuration zip file to a temporary directory; Use the FTP protocol to upload the generated zip file to the configuration backup directory of the FTP server; Delete the zip file generated in the temporary directory; Record the backup results and store them in the database; Send a text message notification that the backup was successful.

3. The automated backup system for operation and maintenance according to claim 2, characterized in that: It also includes a database table logical backup module, which performs the following steps: Read the database backup configuration information and generate a temporary SQL file storage folder in the temporary directory with the current date; read the list of database tables to be backed up, export the table structure and table data and generate .sql files, and place the generated SQL files in the generated temporary SQL folder; Compress the generated temporary SQL folder into a zip file and place it in a temporary directory; Use the FTP protocol to upload the generated zip file to the DB backup directory of the FTP server; Delete the generated zip file and the generated temporary directory in the temporary directory; Record the backup results and store them in the database; Send a text message notification that the backup was successful.

4. The automated backup system for operation and maintenance according to claim 3, characterized in that: In the file data backup module, the file configuration item list includes folder path information, directory list configuration information to be removed, and fuzzy directory removal configuration information; The fuzzy removal directory configuration information is used to specify the initial character characteristics of the files and directories to be removed.

5. The automated backup system for operation and maintenance according to claim 4, characterized in that: In the database table logical backup module, the database backup configuration information includes database connection information and a list of database tables to be backed up; The database table list information is used to specify the names and related attributes of the database tables that need to be backed up.

6. An automated backup method for operation and maintenance, using the system described in claim 5, characterized in that: The file data backup steps are as follows: Read the file configuration item list, loop through the list, and compress the folder into a .zip package; during the compression process, according to the directory to be removed configuration item, remove the specified directories and then perform the compression operation; At the same time, based on the fuzzy removal directory configuration, files and directories in the current directory and all its subordinate subdirectories that start with the fuzzy removal configuration are removed, then the files are compressed, and finally a zip file named with the current timestamp is generated and stored in a temporary directory; The generated zip file is uploaded to the data backup directory of the FTP server using the FTP protocol; Delete the zip file generated in the temporary directory; Record and store the backup results in the database; Send a text message notification that the backup was successful.

7. The automated backup method for operation and maintenance according to claim 6, characterized in that: It also includes the Nacos configuration backup steps, as follows: Read the Nacos backup configuration information, call the login interface to obtain a token, use the token to access the configuration download interface, and store the downloaded Nacos configuration zip file to a temporary directory; Use the FTP protocol to upload the generated zip file to the configuration backup directory of the FTP server; Delete the zip file generated in the temporary directory; Record and store the backup results in the database; Send a text message notification that the backup was successful.

8. The automated backup method for operation and maintenance according to claim 7, characterized in that: It also includes a logical backup step for database tables, as detailed below: Read the database backup configuration information and generate a temporary SQL file storage folder in the temporary directory with the current date; Read the list of database tables to be backed up, export the table structure and table data and generate an .sql file, and place the generated SQL file in the temporary SQL folder mentioned above; Compress the temporary SQL folder into a zip file and place it in the temporary directory; The generated zip file is uploaded to the DB backup directory of the FTP server using the FTP protocol; Delete the generated zip file and temporary SQL folder in the temporary directory; Record and store the backup results in the database; Send a text message notification that the backup was successful.

9. The automated backup method for operation and maintenance according to claim 8, characterized in that: The file configuration options list includes folder path, list of directories to be removed, and fuzzy removal directory configuration; among them, the fuzzy removal directory configuration is used to specify the starting character characteristics of the files and directories to be removed, so as to perform precise removal operations during the compression process.

10. The automated backup method for operation and maintenance according to claim 9, characterized in that: Database backup configuration information includes database connection information and a list of database tables to be backed up; The database table list information is used to accurately specify the names and related attributes of the database tables that need to be backed up, ensuring the integrity and accuracy of the logical backup of the database tables.

Images