Universal database synchronization method

[0026] Example

[0027] For example, there are 20 terminal computers in a local area network, terminal computers PC1, PC2,..., PC20, one main server (M-SERVER), one standby server (E-SERVER), and the operations issued by these 20 terminal computers The operation result of request and reply of the main server (M-SERVER) is monitored, and the update of the SQL Server database on the main server (M-SERVER) is synchronized to the MySQL database on the standby server (E-SERVER) in real time. The general purpose of the present invention The database synchronization method includes the following steps:

[0028] a. The main server configures proxy splitter information;

[0029] The proxy splitter information includes main service information and standby server information;

[0030] The main server information includes the IP address of the main server and the port of the database on the main server;

[0031] The backup server information includes the IP address of the backup server, the database type on the backup server, and the port of the database on the backup server;

[0032] Proxy shunt information configuration:

[0033] The IP address of the main server (M-SERVER) is 192.168.0.1, and the port of the database on the main server (M-SERVER) is 1433;

[0034] The IP address of the standby server (E-SERVER) is 192.168.0.2, the database type on the standby server (E-SERVER) is MySQL, and the database port on the standby server (E-SERVER) is 3306;

[0035] b. The terminal computer sends out the operation request data packet;

[0036] The terminal computer PC6 sends out an operation request data packet to modify the IP address of the machine;

[0037] c. The proxy splitter intercepts the operation request data packet sent by the terminal computer;

[0038] The proxy splitter intercepts the data packet of the operation request to modify the local IP address of the terminal computer PC6;

[0039] d. The main server receives the operation request data packet sent by the terminal computer, and replies the operation result data packet to the terminal computer;

[0040] The main server (M-SERVER) receives the operation request data packet for modifying the local IP address sent by the terminal computer PC6, updates the modified IP address to the SQL Server database, and replies the update result data package to the terminal computer PC6;

[0041] e. The proxy splitter monitors the operation result data packet replies from the main server in real time.

[0042] The proxy splitter monitors the operation result data packet replies from the main server (M-SERVER) in real time. The specific working steps are as follows:

[0043] e1. In this embodiment, the proxy splitter detects the operation result data packet of the successful IP address modification that the main server (M-SERVER) replies to the terminal computer PC6, and continues to perform step e2;

[0044] e2. The proxy splitter confirms that the main server (M-SERVER) has updated the SQL Server database on the main server (M-SERVER) according to the operation request of the terminal computer PC6 to modify the IP address of the machine, and the operation result is normal, continue to step e3;

[0045] e3. According to the normal operation result, the proxy splitter analyzes and intercepts the database language type in the operation request data packet sent by the terminal computer PC6 as a data manipulation language, and continues to perform step e4;

[0046] e4. The proxy splitter translates the data manipulation language of the SQL Server database in the operation request packet sent by the intercepted terminal computer PC6 into a database statement that meets the MySQL database rules on the standby server (E-SERVER), and sends it to the standby server (E-SERVER). SERVER), the standby server (E-SERVER) updates the MySQL database on the standby server (E-SERVER) according to the database statements translated by the proxy splitter and meets the MySQL database rules on the standby server (E-SERVER), and completes the connection with the primary server (M -SERVER) on the SQL Server database synchronization.

[0047] The method of the present invention configures the proxy splitter information on the main server. The proxy splitter intercepts the operation request data packet sent by the terminal computer in the local area network, and monitors the response result data packet of the operation request sent by the main server to the terminal computer in real time. After confirming whether the response result data packet of the main server is normal, analyze the operation request data packet sent by the intercepted terminal computer to identify the database statement. When the database statement is identified as the data definition language, data manipulation language, and data control function, it will be identified After the database statement is translated into a database statement that meets the database rules of the standby server, it sends a database synchronization statement to the standby server, and the standby server completes the real-time database synchronization after receiving the database statement that meets the database rules of the standby server sent by the proxy splitter. This method has no limitation on database types, has good versatility, low cost, and can meet the needs of data management and analysis in real time.