CN116910024A - A method and system for data link string management - Google Patents

Abstract

A method of data link string management, the method is: replacing the data of the database link string with placeholders; creating a database link string configuration table for storing the database link string, the field configuration of the database link string configuration table There is a keyword key; query the database link string configuration table through the keyword key in the Redis cache, obtain the data of the database link string, restore the format of the replaced database link string, obtain the complete data, and store it in the Redis cache; When you need to change the original database server IP, query the original database server IP, obtain the database link string configuration table with all IPs that are the original database server IP, replace them with the new server IP, and clear the Redis cache data of all configuration keyword keys. ; Re-read the database link string configuration table to obtain the data link string data, obtain the modified complete database link string, and re-store it into the Redis cache. This makes it easier to manage and maintain a large number of database link strings and improve development efficiency.

Description

A method and system for data link string management

Technical field

The invention relates to computer technology, in particular to a method and system for managing data link strings.

Background technique

In software development, the database link string is a common configuration item used to specify the parameters required to establish a link between the application and the database, including server IP, port, database name, user name and password, etc. However, managing and maintaining a large number of database connection strings often brings some troubles and challenges.

The existing method usually hardcodes the database connection string directly into the code. When the link parameters need to be changed, the code must be modified and recompiled, which is inflexible and error-prone. And the same server IP may be used in multiple link strings in different projects. If there are a large number of link strings, all link strings need to be modified manually one by one, which is time-consuming and error-prone, and cannot be done in batches. Modify and publish with one click.

Contents of the invention

To overcome the existing method, the database connection string is usually hard-coded directly into the code. When the link parameters need to be changed, the code must be modified and recompiled. The same server IP may be used in multiple link strings in different projects. If there are a large number of link strings, you need to manually modify all the link strings one by one, which is time-consuming and error-prone, and it is impossible to modify and publish them in batches with one click.

The present invention adopts the following solutions to achieve:

A method for managing data link strings. The steps of the method are as follows:

Step 1: Replace the data in the database link string with placeholders;

Step 2: Create a database link string configuration table to store the database link string, and the fields of the database link string configuration table are configured with the keyword key;

Step 3: Query the database link string configuration table through the keyword key in the Redis cache, obtain the data of the database link string, restore the format of the database link string replaced in step 1, obtain the complete data, and store it in the Redis cache;

Step 4: When you need to change the original database server IP, query the original database server IP, obtain the database link string configuration table with all IPs that are the original database server IP, replace them with the new server IP, and clear all configuration keyword keys. Redis cache data;

Step 5: Re-read the database link string configuration table to obtain the data link string data, obtain the modified complete database link string, and re-store it into the Redis cache for next use.

Step 1 is further specific: the data of the database link string includes IP address, database name db, account user, password pwd, and server port port. The content of the link string is replaced with {user}:{pwd}@ based on the above data. tcp({ip}:{port})/{db}? The format of charset=utf8mb4.

The field configurations of the database link string configuration table mentioned in step 2 include: keyword key, format string format, server IP, server port, database name db, account user, and password pwd.

Step 3 is further detailed as follows: Query the database link string configuration table through the keyword key. If it does not exist, query the link string configuration table to obtain the database link string data. Replace the corresponding fields according to the format string format to obtain the complete database link string. Store it in the Redis cache with the configuration keyword as the key.

Step 4 is further specific: when the original database server IP needs to be replaced, query all database link string configuration tables under the original database server IP to obtain the data list, then use the update statement to update all old IP data, and finally loop the list to The Redis cache data of all configuration keyword keys is cleared.

A system for data link string management, the system includes a string conversion module, a configuration table creation module, a data storage module, a management module, and a reading module;

The string conversion module is used to replace the data of the database link string with placeholders;

The configuration table creation module is used to create a database link string configuration table for storing database link strings, and the fields of the database link string configuration table are configured with keywords key;

The data storage module is used to query the database link string configuration table through the keyword key in the Redis cache, obtain the data of the database link string, restore the format of the replaced database link string, obtain the complete data, and store it in the Redis cache middle;

The management module is used to query the original database server IP when it is necessary to change the original database server IP, obtain the database link string configuration table with all IPs as the original database server IP, replace them with new server IPs, and clear all configuration keys. Redis cache data of word key;

The reading module is used to re-read the database link string configuration table to obtain the data link string data, obtain the modified complete database link string, and re-store it into the Redis cache for next use.

The string conversion module is further specific: the data of the database link string includes IP address, database name db, account user, password pwd, and server port port. The above data is replaced with {user}:{pwd}@tcp({ ip}:{port})/{db}? The format of charset=utf8mb4.

The field configurations of the database link string configuration table described in the configuration table creation module include: keyword key, format string format, server IP, server port port, database name db, account user, and password pwd.

The data storage module is further detailed as follows: query the database link string configuration table through the keyword key. If it does not exist, query the link string configuration table to obtain the database link string data. Replace the corresponding fields according to the format string format to obtain the complete database link string. And stored in the Redis cache with the configuration keyword as the key.

The management module is further detailed as follows: when the original database server IP needs to be replaced, query all database link string configuration tables under the original database server IP to obtain the data list, then use the update statement to update all old IP data, and finally loop through the list. The Redis cache data of all configuration keyword keys is cleared.

The beneficial effects of the present invention are:

The present invention provides a method and system for data link string management, which can more easily manage and maintain a large number of database link strings, and can operate more efficiently and accurately when modification or update is needed, thereby improving development and operation and maintenance. efficiency, reduce errors and risks, and enhance system flexibility and maintainability.

Description of the drawings

Figure 1 is a flow chart of the method of the present invention;

Figure 2 is a structural block diagram of the system of the present invention.

Detailed ways

The present invention will be further described below in conjunction with the accompanying drawings.

As shown in Figure 1, a method for managing data link strings has the following steps:

Step 1: Replace the data in the database link string with placeholders;

Step 2: Create a database link string configuration table to store the database link string, and the fields of the database link string configuration table are configured with the keyword key;

Step 3: Query the database link string configuration table through the keyword key in the Redis cache, obtain the data of the database link string, restore the format of the database link string replaced in step 1, obtain the complete data, and store it in the Redis cache;

Step 4: When you need to change the original database server IP, query the original database server IP, obtain the database link string configuration table with all IPs that are the original database server IP, replace them with the new server IP, and clear all configuration keyword keys. Redis cache data;

Step 5: Re-read the database link string configuration table to obtain the data link string data, obtain the modified complete database link string, and re-store it into the Redis cache for next use.

In one embodiment of the present invention, a method and system for data link string management:

Replace the IP, database name, account number, and password of the database link string with placeholders and design it as {user}:{pwd}@tcp({ip}:{port})/{db}? The format of charset=utf8mb4.

Suppose there is a system that needs to connect to the mysql database, link string=zhifu:ABCDEFG@tcp172.10.32.16:3306/pay? charset=utf8mb4, replace the IP, library name, account, and password in the link string with placeholders, and design it into the following format {user}:{pwd}@tcp({ip}:{port})/{db} ? charset=utf8mb4.

{user}, {pwd}, {ip}, {port} and {db} all represent variables, in the format:, @tcp, (:), /,? and charset=utf8mb4 are both fixed formats.

Create a database link string configuration table con_tb to store all database link strings. The fields of the database link string configuration table con_tb include configuration keyword key, format string format, server IP, server port port, library name db, and account user , password pwd.

Create a database link string configuration table con_tb to store all database link strings. The fields are as follows: configuration keyword key, format string format, server IP, server port port, database name db, account user, and password pwd. The table structure is as follows:

CREATE TABLE`con_tb`(

`id`int(11)NOT NULL AUTO_INCREMENT,

`key`varchar(10)DEFAULT NULL,

`format`varchar(255)DEFAULT NULL,

`ip`varchar(20)DEFAULT NULL,

`port`int(5)DEFAULT NULL,

`db`varchar(10)DEFAULT NULL,

`user`varchar(10)DEFAULT NULL,

`pwd`varchar(20)DEFAULT NULL,

`create_time`datetime DEFAULT NULL,

PRIMARY KEY(`id`)

)ENGINE=InnoDB DEFAULT CHARSET=utf8;

When the program starts, query the Redis cache according to the required key to obtain the database link string. If it does not exist, query the link string configuration table con_tb to obtain the database link string data. Replace the corresponding fields according to the format string format to obtain the complete database link string. Store it in the Redis cache with the configuration keyword as the key for next use.

Assume that this system stores the database link string in the data row with the configuration keyword key as paysystem. The data table stores the data as shown in Table 1:

Table 1

When the program starts, read the cache data of Redis cache key=paysystem. If it exists, it will be returned to the system for use. If it does not exist, query the link string configuration table con_tb to obtain the database link string data, and execute the statement select*from con_tb where key=' paysystem'limit 1. After obtaining the data, replace the corresponding fields according to the format string format to obtain the complete database link string=zhifu:ABCDEFG@tcp172.10.32.16:3306/pay? charset=utf8mb4. Then store it in the Redis cache with Redis cache key=paysystem for next use.

When the database server IP needs to be changed, query the ip field of the database link string configuration table con_tb which is equal to the keylist of the data list of the original database server IP, and then use the update statement update con_tb set ip = new database server IP where ip = original database server IP Update all old configuration data, finally cycle the keylist, and clear the Redis cache data of all configuration keyword keys.

Assume that during the daily operation of the system, the server with IP address 172.10.32.16 needs to be migrated to a new server due to any reasons such as failure or changes in the computer room. Assume that the new server IP is 121.15.22.20, and the IP address 172.10.32.16 is not only used by paysystem. It is also used by dozens of other systems, so here's how to quickly update in batches.

Query the ip field of the database link string configuration table con_tb which is equal to the data list of the original database server IP. Execute the query statement select key from con_tb where ip='172.10.32.16' to get the keylist of all link string configuration data using the IP 172.10.32.16. Then use the update statement update con_tb setip='121.15.22.20' where ip='172.10.32.16' to update all link string configuration data using the IP 172.10.32.16. Then loop through the keylist obtained previously and execute the Redis cache command del{key} to clear all cached Redis cache data.

When the program queries the Redis cache to obtain the database link string according to the required key, the Redis cache data has been cleared, then re-reads the link string configuration table con_tb to obtain the data link string data, reorganizes the complete database link string, and re-stores it. Redis caches for next time use.

When each program queries the Redis cache according to the key required by its own system to obtain the database link string, it is found that the Redis cache cannot read the data because the Redis cache data has been cleared, and then re-reads the link string configuration table con_tb to obtain the data. And reorganize according to the rules of step 3 to obtain the complete database link string, and re-store it into the Redis cache for next use.

As shown in Figure 2, the present invention also provides a system for data link string management. The system includes a string conversion module, a configuration table creation module, a data storage module, a management module, and a reading module;

The string conversion module is used to replace the data of the database link string with placeholders;

The configuration table creation module is used to create a database link string configuration table for storing database link strings, and the fields of the database link string configuration table are configured with keywords key;

The data storage module is used to query the database link string configuration table through the keyword key in the Redis cache, obtain the data of the database link string, restore the format of the replaced database link string, obtain the complete data, and store it in the Redis cache middle;

The management module is used to query the original database server IP when it is necessary to change the original database server IP, obtain the database link string configuration table with all IPs as the original database server IP, replace them with new server IPs, and clear all configuration keys. Redis cache data of word key;

The reading module is used to re-read the database link string configuration table to obtain the data link string data, obtain the modified complete database link string, and re-store it into the Redis cache for next use.

The string conversion module is further specific: the data of the database link string includes IP address, database name db, account user, password pwd, and server port port. The above data is replaced with {user}:{pwd}@tcp({ ip}:{port})/{db}? The format of charset=utf8mb4.

The field configurations of the database link string configuration table described in the configuration table creation module include: keyword key, format string format, server IP, server port port, database name db, account user, and password pwd.

The data storage module is further detailed as follows: query the database link string configuration table through the keyword key. If it does not exist, query the link string configuration table to obtain the database link string data. Replace the corresponding fields according to the format string format to obtain the complete database link string. And stored in the Redis cache with the configuration keyword as the key.

The management module is further detailed as follows: when the original database server IP needs to be replaced, query all database link string configuration tables under the original database server IP to obtain the data list, then use the update statement to update all old IP data, and finally loop through the list. The Redis cache data of all configuration keyword keys is cleared.

In short, the present invention provides a method and system for data link string management, which can more easily manage and maintain a large number of database link strings, and can operate more efficiently and accurately when modification or update is needed, improving development and Operation and maintenance efficiency, reducing errors and risks, and enhancing system flexibility and maintainability.

The above are only preferred embodiments of the present invention, and all equivalent changes and modifications made in accordance with the patentable scope of the present invention shall fall within the scope of the present invention.

Claims (10)

1. A method of data link string management, the method comprising the steps of:

step 1: replacing the data of the database link string with a placeholder;

step 2: creating a database link string configuration table for storing database link strings, wherein the fields of the database link string configuration table are configured with key words;

step 3: inquiring a database link string configuration table in a Redis cache through a keyword key, acquiring data of the database link string, restoring the format of the database link string replaced in the step 1 to obtain complete data, and storing the complete data in the Redis cache;

step 4: when the original database server IP needs to be replaced, inquiring the original database server IP, acquiring database link string configuration tables with all the IPs being the original database server IP, replacing the database link string configuration tables with new server IPs, and clearing Redis cache data of all configuration key words;

step 5: and re-reading the database link string configuration table to obtain data link string data, obtaining a modified complete database link string, and re-storing the modified complete database link string in a Redis cache for the next use.

2. The method of claim 1, wherein step 1 is further specifically: the data of the database link string comprises an IP address, a database name db, an account user, a password pwd and a server port, and the content of the link string is replaced by { user }: { pwd @ tcp ({ IP }: { port })/{ db? charset=utf8mb4 format.

3. The method of claim 2, wherein the fields of the database link string configuration table in step 2 are configured with: key, format string format, server IP, server port, library name db, account user, password pwd.

4. A method of data link string management according to claim 3, wherein step 3 is further specifically: and inquiring a database link string configuration table through a key, if the key does not exist, inquiring the link string configuration table to acquire database link string data, replacing corresponding fields according to a format character string format to acquire a complete database link string, and storing the complete database link string into a Redis cache taking the configuration key as the key.

5. The method of claim 4, wherein step 4 is further specifically: when the original database server IP needs to be replaced, all database link string configuration tables under the original database server IP are queried to obtain a data list, then all old IP data are updated by using an update statement, and finally list is circulated, and Redis cache data of all configuration key words are emptied.

6. The system for managing the data link strings is characterized by comprising a character string conversion module, a configuration table creation module, a data storage module, a management module and a reading module;

the character string conversion module is used for replacing the data of the database link string with the placeholder;

the configuration table creation module is used for creating a database link string configuration table for storing database link strings, and the fields of the database link string configuration table are configured with key words;

the data storage module is used for inquiring the database link string configuration table through the key in the Redis cache, acquiring the data of the database link string, restoring the format of the replaced database link string to obtain complete data, and storing the complete data in the Redis cache;

the management module is used for inquiring the original database server IP when the original database server IP needs to be replaced, acquiring database link string configuration tables with all the IPs being the original database server IP, replacing the database link string configuration tables with new server IPs, and clearing Redis cache data of all the configuration key words;

the reading module is used for reading the database link string configuration table again to obtain data link string data, obtaining a modified complete database link string, and storing the modified complete database link string in the Redis cache again for the next use.

7. The system for managing data link strings according to claim 6, wherein the string conversion module is further specifically configured to: the data of the database link string comprises an IP address, a database name db, an account user, a password pwd and a server port, and the data is replaced by { user }: { pwd @ tcp ({ IP }: { port })/{ db? charset=utf8mb4 format.

8. The system for data link string management according to claim 7, wherein the fields of the database link string configuration table in the configuration table creation module are configured with: key, format string format, server IP, server port, library name db, account user, password pwd.

9. The system for data link string management according to claim 8, wherein the data storage module is further specifically configured to: and inquiring a database link string configuration table through a key, if the key does not exist, inquiring the link string configuration table to acquire database link string data, replacing corresponding fields according to a format character string format to acquire a complete database link string, and storing the complete database link string into a Redis cache taking the configuration key as the key.

10. The system of claim 9, wherein the management module is further configured to: when the original database server IP needs to be replaced, all database link string configuration tables under the original database server IP are queried to obtain a data list, then all old IP data are updated by using an update statement, and finally list is circulated, and Redis cache data of all configuration key words are emptied.