CN112274913B

CN112274913B - Method and device for merging game servers, storage medium and electronic device

Info

Publication number: CN112274913B
Application number: CN202011166604.5A
Authority: CN
Inventors: 高攀; 张琰
Original assignee: Perfect World Chongqing Interactive Technology Co ltd
Current assignee: Perfect World Chongqing Interactive Technology Co ltd
Priority date: 2020-10-27
Filing date: 2020-10-27
Publication date: 2024-04-19
Anticipated expiration: 2040-10-27
Also published as: CN112274913A

Abstract

The invention provides a merging method and device of a game server, a storage medium and an electronic device, wherein the method comprises the following steps: acquiring annotation information of a database code, wherein the database code runs in a master game server and a slave game server, the annotation information is used for indicating a merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server; generating an intermediate table structure of a target game database according to the annotation information; and merging the slave game database and the master game database in the target game database according to the intermediate table structure. The invention solves the technical problem of low service combining efficiency in the related technology, reduces the upgrading of the database and the maintenance work of the service combining, avoids online accidents caused by manually upgrading the database, saves the time for maintaining the game server and improves the service combining efficiency.

Description

Method and device for merging game servers, storage medium and electronic device

Technical Field

The invention relates to the technical field of data processing, in particular to a method and a device for merging game servers, a storage medium and an electronic device.

Background

In the related art, in order to meet the demand of game operation, a database of a plurality of game servers needs to be subjected to a service combination process, wherein the service combination refers to a network game, and database data of several servers are combined into one server according to the operation demand. All the data of the player is transferred to the new server, and the player of the slave suit logs into the server of the master suit to play the game when logging in next time. The main service refers to a target server to which database data of other servers are merged, and finally the server of the main service is taken as the game service of all the merged servers. The slave service refers to a server which needs to be matched with the service, and database data is combined with the master service. The original clothing refers to a certain server selected by a player through a clothing selection interface, the player plays a game on the server after logging in, and data of the player are stored on the original clothing. Cross-service refers to a group of servers that are common to a group of original services, and players of different servers can play games across the group of services.

In the related art, the server is upgraded mainly by manually configuring database codes or manually creating tables, and the first technical scheme includes: new tables or fields need to be added in the server code, corresponding MySQL scripts need to be written, and new tables or fields need to be generated. The script needs to be manually executed during version maintenance, and a new table or field needs to be added correctly. The second technical scheme comprises the following steps: when the server is in close service each time, which tables and fields are added to the server with new versions are needed to be arranged, and the strategies of table or field close service are determined according to the requirements so as to write corresponding close service scripts by handwriting. The first technical proposal has the following defects: each time a new table or field is added to the data store in the server code, a special person is required to maintain MySQL script generation tools, and different generation scripts are required to be maintained for versions of different branches. In the process of project development, frequent communication with the corresponding development program is required, and the format, field type, size and the like of the memory table are designed. Is a heavy burden for project development and requires careful maintenance generation tools for maintenance personnel, otherwise, once new tables or fields are missed, serious on-line accidents can result. The second technical proposal has the following defects: before each service combination, a large number of service combination scripts are required to be written, all tables and fields cannot be omitted, and programs corresponding to all newly added tables are required to be communicated to ensure that the newly added tables, whether a master library and a slave library need to be deleted, whether the master library needs to be reserved, whether the slave library data are combined into the master library, whether special requirements for generating new data need to be generated after service combination, and the like. The complicated communication and development processes, once the communication has a problem, the problems of data loss, coverage and the like after the combination of the clothes can be caused, and the problems can be serious accidents on line. So that each co-administration would be a heavy burden for the program, testing and even operation. In some projects, the efficiency of the combined service of hundreds of servers is extremely low, and great cost and pressure are brought to the maintenance of the servers.

In view of the above problems in the related art, no effective solution has been found yet.

Disclosure of Invention

The embodiment of the invention provides a method and a device for merging game servers, a storage medium and an electronic device.

According to an embodiment of the present invention, there is provided a merging method of game servers, including: acquiring annotation information of a database code, wherein the database code runs in a master game server and a slave game server, the annotation information is used for indicating a merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server; generating an intermediate table structure of a target game database according to the annotation information; and merging the slave game database and the master game database in the target game database according to the intermediate table structure.

Optionally, obtaining annotation information of the database code includes: traversing all classes in the database code, and searching a class file containing entity annotation; reading annotation parameters in the class file, wherein the annotation parameters comprise: a table identifier and a field attribute, wherein the table identifier is used for indicating the merging type of the master game database and the slave game database, and the field attribute is used for indicating the constraint condition of corresponding fields in the master game database and the slave game database.

Optionally, generating the intermediate table structure of the target game database according to the annotation information includes: analyzing a first annotation parameter of the annotation information, and determining the merging type of the game database as a newly added form or an updated form based on the first annotation parameter; if the merging type is a newly added form, analyzing a second annotation parameter of the annotation information, acquiring a field constraint condition of a code field based on the second annotation parameter, and generating a first MySQL statement by using the field constraint condition; if the merging type is the updated form, generating a second MySQL statement by using the newly added field attribute; an intermediate table structure is generated in a target game database based on the first MySQL statement or the second MySQL statement.

Optionally, generating the first MySQL statement using the field constraint includes: traversing all enumerated fields in a class of the database code; obtaining constraint conditions of the enumeration field through the annotation information; and generating a first MySQL statement through the constraint condition, wherein the first MySQL statement is used for creating a new table structure in the target game database.

Optionally, the constraint includes at least one of: the field type, the field length, whether the field is an index, whether the field is null, the field default value, and the annotation information of the field.

Optionally, generating the second MySQL statement using the newly added field attribute includes: searching a first field list of a target table in the master game database, and acquiring a second field list of the target table in the slave game database; comparing whether the first field list and the second field list are identical; if the first field list and the second field list are the same, generating a second MySQL statement based on the attribute differences of the master game database and the slave game database, wherein the attribute differences are used for representing at least one of the following: whether the field is newly added with an index, whether the field length is changed, and whether the field type is changed; and if the first field list and the second field list are different, splicing the difference fields of the master game database and the slave game database to generate a second MySQL statement, wherein the second MySQL statement is used for updating the table structure of the target table in the target game database.

Optionally, before merging the slave game database and the master game database according to the intermediate table structure in the target game database, the method further includes: determining whether a repeated game element exists in the intermediate table structure, wherein the game element comprises at least one of the following: a game player identification, a game Gang identification; and if repeated game elements exist in the middle table structure, adding a rename mark on the game elements, and distributing a rename card for the corresponding game account.

Optionally, before generating the intermediate table structure of the target game database according to the annotation information, the method further comprises: and deleting the game data of the designated account number from the main game database, wherein the designated account number is used for representing that the game activity of the player is lower than a designated threshold value.

According to another embodiment of the present invention, there is provided a merging device of game servers, including: the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring annotation information of a database code, the database code is operated in a master game server and a slave game server, the annotation information is used for indicating the merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server; the generation module is used for generating an intermediate table structure of the target game database according to the annotation information; and the merging module is used for merging the slave game database and the master game database in the target game database according to the intermediate table structure.

Optionally, the acquiring module includes: the searching unit is used for traversing all classes in the database code and searching class files containing entity annotation; the reading unit is used for reading annotation parameters in the class file, wherein the annotation parameters comprise: a table identifier and a field attribute, wherein the table identifier is used for indicating the merging type of the master game database and the slave game database, and the field attribute is used for indicating the constraint condition of corresponding fields in the master game database and the slave game database.

Optionally, the generating module includes: the analysis unit is used for analyzing a first annotation parameter of the annotation information, and determining the merging type of the game database as a newly added form or an updated form based on the first annotation parameter; the first generation unit is used for analyzing a second annotation parameter of the annotation information if the merging type is a new added form, acquiring a field constraint condition of a code field based on the second annotation parameter, and generating a first MySQL statement by using the field constraint condition; if the merging type is the updated form, generating a second MySQL statement by using the newly added field attribute; and the second generation unit is used for generating an intermediate table structure in the target game database based on the first MySQL statement or the second MySQL statement.

Optionally, the first generating unit includes: a traversal subunit, configured to traverse all enumeration fields in a class of the database code; an acquisition subunit, configured to acquire constraint conditions of the enumeration field through the annotation information; and the first generation subunit is used for generating a first MySQL statement through the constraint condition, wherein the first MySQL statement is used for creating a new table structure in the target game database.

Optionally, the first generating unit includes: an obtaining subunit, configured to find a first field list of a target table in the master game database, and obtain a second field list of the target table in the slave game database; a comparing subunit, configured to compare whether the first field list and the second field list are the same; a second generating subunit, configured to generate a second MySQL statement based on a difference in attributes of the master game database and the slave game database if the first field list and the second field list are the same, where the difference in attributes is used to characterize at least one of: whether the field is newly added with an index, whether the field length is changed, and whether the field type is changed; and if the first field list and the second field list are different, splicing the difference fields of the master game database and the slave game database to generate a second MySQL statement, wherein the second MySQL statement is used for updating the table structure of the target table in the target game database.

Optionally, the apparatus further includes: a judging module, configured to judge whether repeated game elements exist in the intermediate table structure before the merging module merges the slave game database and the master game database in the target game database according to the intermediate table structure, where the game elements include at least one of the following: a game player identification, a game Gang identification; and the processing module is used for adding a rename mark to the game element and distributing a rename card to the corresponding game account if the repeated game element exists in the middle table structure.

Optionally, the apparatus further includes: and the deleting module is used for deleting the game data of the appointed account number from the main game database and the slave game database before the generating module generates the middle table structure of the target game database according to the annotation information, wherein the appointed account number is used for representing that the game activity of the player is lower than an appointed threshold value.

According to a further embodiment of the invention, there is also provided a storage medium having stored therein a computer program, wherein the computer program is arranged to perform the steps of any of the method embodiments described above when run.

According to a further embodiment of the invention, there is also provided an electronic device comprising a memory having stored therein a computer program and a processor arranged to run the computer program to perform the steps of any of the method embodiments described above.

According to the method and the system, annotation information of the database codes is acquired, an intermediate table structure of the target game database is generated according to the annotation information, the slave game database and the master game database are combined in the target game database according to the intermediate table structure, the intermediate table structure of the target game database is automatically generated by using the annotation information of the database codes of the slave game database and the master game database to be combined, a game server can be automatically combined, a service combining script is not required to be developed, the technical problem of low service combining efficiency in the related art is solved, online accidents caused by manually upgrading the databases are avoided, the time for maintaining the game server is saved, and the service combining efficiency is improved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:

FIG. 1 is a block diagram of a consolidated hardware architecture of a game server according to an embodiment of the invention;

FIG. 2 is a flow chart of a method of merging game servers according to an embodiment of the present invention;

FIG. 3 is a flow chart of an embodiment of the present invention for automatically upgrading data;

FIG. 4 is a flow chart of database auto-close in an embodiment of the invention;

Fig. 5 is a block diagram showing a configuration of a merging device of a game server according to an embodiment of the present invention;

fig. 6 is a block diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

In order that those skilled in the art will better understand the present application, a technical solution in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present application without making any inventive effort, shall fall within the scope of the present application. It should be noted that, without conflict, the embodiments of the present application and features of the embodiments may be combined with each other.

It should be noted that the terms "first," "second," and the like in the description and the claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the application described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Example 1

The method embodiment provided by the first embodiment of the application can be executed in a server, a computer or a similar electronic device. Taking the example of running on a server, fig. 1 is a block diagram of a combined hardware structure of a game server according to an embodiment of the present application. As shown in fig. 1, the server 10 may include one or more (only one is shown in fig. 1) processors 102 (the processor 102 may include, but is not limited to, a microprocessor MCU or a processing device such as a programmable logic device FPGA) and a memory 104 for storing data, and optionally, a transmission device 106 for communication functions and an input-output device 108. It will be appreciated by those skilled in the art that the structure shown in fig. 1 is merely illustrative, and is not intended to limit the structure of the server described above. For example, the server 10 may also include more or fewer components than shown in FIG. 1, or have a different configuration than shown in FIG. 1.

The memory 104 may be used to store server programs, such as software programs and modules of application software, such as a server program corresponding to a method for merging game servers in an embodiment of the present invention, and the processor 102 executes the server programs stored in the memory 104 to perform various functional applications and data processing, that is, to implement the above-described method. Memory 104 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory remotely located with respect to the processor 102, which may be connected to the server 10 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof. In this embodiment, the processor 104 is configured to control the target virtual character to perform a specified operation to complete the game task in response to the man-machine interaction instruction and the game policy. The memory 104 is used to store program scripts for the electronic game, configuration information, attribute information for the virtual character, and the like.

The transmission means 106 is arranged to receive or transmit data via a network. The specific example of the network described above may include a wireless network provided by a communication provider of the server 10. In one example, the transmission device 106 includes a network adapter (Network Interface Controller, simply referred to as a NIC) that can connect to other network devices through a base station to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used to communicate with the internet wirelessly.

Optionally, the input/output device 108 further includes a man-machine interaction screen for acquiring a man-machine interaction instruction through a man-machine interaction interface;

In this embodiment, a method for merging game servers is provided, and fig. 2 is a flowchart of a method for merging game servers according to an embodiment of the present invention, as shown in fig. 2, where the flowchart includes the following steps:

Step S202, annotation information of a database code is obtained, wherein the database code operates in a master game server and a slave game server, the annotation information is used for indicating the merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server;

The annotation information of the present embodiment is added when the database code is configured, and is used to instruct the merging type of the master game database and the slave game database to generate MySQL statements of different types when the server merging is executed, and because the annotation information can also interpret attribute information (such as type, length, index, etc.) of each entity in the code, the SQL statements of the database can be automatically generated according to the annotation information.

Step S204, generating an intermediate table structure of the target game database according to the annotation information;

The intermediate table structure of the embodiment is a table structure newly created based on the merging type corresponding to the annotation information and the field attribute in the database code, or is a table structure updated based on the table structure of the main game database;

Step S206, merging the slave game database and the master game database in the target game database according to the intermediate table structure;

in the merging process, table item contents are read from the main game database and the slave game database, game data of each table item are filled based on a data format of an intermediate table structure, and finally the two game databases of the main game server and the slave game server are merged into one game database, so that automatic merging is realized.

According to the method, annotation information of database codes is obtained, an intermediate table structure of a target game database is generated according to the annotation information, a slave game database and a master game database are combined in the target game database according to the intermediate table structure, the intermediate table structure of the target game database is automatically generated by using the annotation information of the database codes of the slave game database and the master game database to be combined, a game server can be automatically combined, a service combining script is not required to be developed, the technical problem of low service combining efficiency in the related art is solved, online accidents caused by manually upgrading the database are avoided, the time for maintaining the game server is saved, and the service combining efficiency is improved.

In an implementation of the present embodiment, obtaining annotation information of the database code includes:

S11, traversing all classes in the database code, and searching a class file containing entity annotation;

In one example of this embodiment, all classes in the code are traversed by the database code being converted into an abstract syntax tree (Abstract Syntax Tree, AST), including parsing the source code file of the database code to generate a corresponding abstract syntax tree; the abstract syntax tree in this embodiment can be applied to all types of programming languages for abstractly expressing the logical relations of the source code syntax structure. Then traversing each tree node in AST; and filling the node content of the tree node in a description block of a preset template document according to the node type of the tree node to generate a description document, wherein the description document is used for recording attribute information and interaction relations of all objects in a database code.

In this embodiment, parsing the source code file to generate a corresponding AST includes: reading a character string in a source code file; the present embodiment can read the character string in the source code file in a recursive manner. Identifying character features of the character string; the character features of the present embodiment are used to describe attribute information and associated information of the character string, and the character features of the identification character string may be, but are not limited to: the props attribute of the identification character string, props attribute, is used for describing the data transfer direction between the parent component and the child component; identifying a character identifier of the character string; annotation information identifying the character string; identifying the type of the character string; an AST is generated from the string and the character features.

The present embodiment may generate an AST in various manners, and in one implementation manner of the present embodiment, generating an AST according to a character string and character features includes: generating a Token sequence based on the character features, wherein the Token sequence comprises a plurality of character strings in a source code file; constructing an AST of a source code file from top to bottom according to a Token sequence, wherein each character string in the Token sequence corresponds to a tree node. The Token of this embodiment is a word obtained by similarly segmenting a sentence of a source code, and the Token sequence is a word sequence composed of a plurality of words, and the word is a character string, which is the minimum unit constituting the source code.

S12, reading annotation parameters in the class file, wherein the annotation parameters comprise: a table identification for indicating the merging type of the master game database and the slave game database, and a field attribute for indicating the constraint condition of the corresponding fields in the master game database and the slave game database.

In this embodiment, note @ Entity is used to represent an annotation to an Entity, note @ Column is used to declare the mapping of the attribute to the database field. In one example, the annotation information is as follows:

@Entlty(entityNlame＝"ServerDB8",tablelNlame＝"demo-serven",

isCross＝true,mergeType＝2)public enum EntityServer{

Color (type-int.class, section= "phase of starting server, 0: default 1: test phase 2: already started") type,

@ CoLumn (type = long. Class, comment = "type"

startTime,

@Comment (type=int.class, comment= "group tries on current scene sn")

teamExercisestageSn,

Color (type=long. Class, comment= "last time taken together")

mergeTme,

Color (type=category. Class, comment= "send cross-collar fight mail") crossLandlarMaiL,

}

For a file marked with the @ Entity class in the code, where parameters MERGETYPE are used to decide the merging policy of the table, examples are as follows, by predefined configuration: 1, a combination mode is not specified, and a combination tool reports errors; 0, directly combining the two libraries; 1, emptying; 2, the main library is the standard; and 3, customizing a merging mode (custom combined script is needed).

In one implementation of the present embodiment, generating the intermediate table structure of the target game database from the annotation information includes:

s21, analyzing first annotation parameters of the annotation information, and determining the merging type of the game database as a newly added form or an updated form based on the first annotation parameters;

S22, if the merging type is a newly added form, analyzing a second annotation parameter of the annotation information, acquiring a field constraint condition of a code field based on the second annotation parameter, and generating a first MySQL statement by using the field constraint condition; if the merging type is the updated form, generating a second MySQL statement by using the newly added field attribute;

In one example, generating the first MySQL statement using the field constraint includes: traversing all enumerated fields in a class of database code; acquiring constraint conditions of the enumeration field through annotation information; and generating a first MySQL statement through the constraint condition, wherein the first MySQL statement is used for creating a new table structure in the target game database.

Alternatively, the constraints may be, but are not limited to: the field type, the field length, whether the field is an index, whether the field is null, the field default value, and the annotation information of the field.

After the first MySQL statement is generated, a new table structure is created in the target server according to the constraint condition, the target server executes the first MySQL statement, game data such as user identification, Gang identification, game assets, game level and the like are obtained from the game server, and the new table structure is filled in according to the constraint condition to form a new database item.

In one example, generating the second MySQL statement using the added field attribute includes: searching a first field list of a target table in a master game database, and acquiring a second field list of the target table in a slave game database; comparing whether the first field list and the second field list are the same; if the first field list and the second field list are the same, generating a second MySQL statement based on the attribute differences of the master game database and the slave game database, wherein the attribute differences are used for representing at least one of the following: whether the field is newly added with an index, whether the field length is changed, and whether the field type is changed; if the first field list and the second field list are different, a second MySQL statement is generated by splicing the difference fields of the main game database and the auxiliary game database, wherein the second MySQL statement is used for updating the table structure of the target table in the target game database.

After the second MySQL statement is generated, the table structure of the original table, that is, the table structure of the main game database, is modified in the target server according to the attribute difference, the table structure of the original table is updated to a new table structure, then game data such as user identification, Gang identification, game assets, game grades and the like are obtained from the game server, and the new database items are formed by filling according to the rules of the new table structure.

S23, generating an intermediate table structure in the target game database based on the first MySQL statement or the second MySQL statement.

FIG. 3 is a flowchart of an embodiment of the invention for automatically upgrading data by adding comments to a code in a certain module in the code, when a server is started, the database upgrading code traverses all classes in the project, finds out class files containing comments @ Entity, obtains parameters in the comments, includes data such as table names, and judges whether to be a new table or update an existing table according to the table names in MySql data.

If the table is a new table, traversing all enumerated fields in the class, and then obtaining constraint conditions of the fields, such as information of field type, length, index, null, default value, annotation and the like through annotating @ Column, generating a MySQL statement for creating the new table through all the information, and creating the MySql statement for creating the index if the table is indexed. Finally, a new table structure is created by communicating with the MySQL database.

If the table is updated, firstly, all the fields ASet of the table are found in MySQL data, then all the fields BSet in the class are obtained, the Aset and the Bset are compared, if the fields are the same, whether the index is newly added, whether the field length is changed, whether the type is changed, and the like are judged, a corresponding MySql statement is generated, and the statement is executed. If the two sets have different parts, new fields are spliced into MySQL sentences, the MySQL sentences are added into the tables of the database, the operation of updating the tables is executed, finally, the database connection is closed, and the automatic upgrading work of the database is completed.

In one implementation of this embodiment, before merging the slave game database and the master game database according to the intermediate table structure in the target game database, further includes: determining whether there are duplicate game elements in the intermediate table structure, wherein the game elements include at least one of: a game player identification, a game Gang identification; if repeated game elements exist in the middle table structure, a rename mark is added to the game elements, and a rename card is allocated to the corresponding game account.

Because the two servers are combined, the possibility of duplicate names exists, the duplicate name card can be allocated to the game account corresponding to the duplicate game element (such as player account, Gang names and the like), or one of the duplicate game elements is directly remarked, so that the user experience is improved, and the disorder of game data caused by duplicate primary keys is avoided.

In one implementation of this embodiment, before generating the intermediate table structure of the target game database from the annotation information, the method further includes: and deleting the game data of the designated account number from the main game database, wherein the designated account number is used for representing that the game activity of the player is lower than a designated threshold value.

By deleting the user data with low game activity, the data volume of the main server after the service combination can be reduced, the processing efficiency and the processing speed of the main server can be improved, and the maintenance burden on useless data can be reduced.

FIG. 4 is a flowchart of automatic service combination of databases according to an embodiment of the present invention, in which a service combination tool is executed to perform service combination, a database name, a database address, and a password of a master service and a slave service need to be transmitted. The tool then traverses the class under the specified package, finds the class file with the @ Entity annotation, and deletes the data of the table associated with the inactive user (in order to reduce the size of the library after the syndication) and all the inactive users according to the operation policy. Assuming a master library A and a slave library B, the two libraries A and B are not modified in the merging process and are used for possible combination failure, and the data of the libraries A and B are restored, so that a new target library C is newly established. Then traversing all database tables, generating different MySQL statements according to MERGETYPE in each table, and executing operations. Some special treatments of the MERGETYPE-3 custom fit strategy are provided, such as player, Gang name repetition, marking on the data of one of the renames according to the strategy, and a rename card is sent to the player after the player is online, and the custom treatments are provided.

And when the client is taken together, only tools are needed to be provided for operation and maintenance personnel to be responsible for transmitting the library names, addresses and passwords of the master library and the slave library. Several hundred groups of servers can be executed simultaneously in parallel to run simultaneously, so that the service combining efficiency is greatly improved, the service combining process is simplified, and the maintenance cost of the servers is effectively reduced.

Through the scheme of the embodiment, the problem that MySQL scripts are required to be manually maintained every time a table or a field is newly added in program codes is solved. According to the embodiment, the database is automatically updated according to the table or the field required by the program code, special maintenance is not needed, and a developer only needs to annotate the table or the field in the code according to the requirement of the respective function. The server process automatically detects which tables or fields are newly added and automatically upgrades the tables or fields when the server process is started each time. The problem that a person maintaining the database possibly leaks to add a table or a field is solved, and the problem caused by each maintenance of the server due to the database problem is greatly reduced. The technical problem that a large number of scripts are required to be written for combined use is solved. In the program code, all database tables are marked through annotation, such as directly merging the tables of the two libraries, deleting the tables of the master library and the slave library, clearing the tables of the master library and the slave library, taking the master library table as the main, and customizing the merging mode. The program developer can customize the rule of the combined service according to the function of the program developer, a person specially responsible for maintaining the combined service of the database is not needed, and the combined service can be operated by simply configuring a plurality of parameters by the operation and maintenance personnel, so that the combined service process is greatly reduced, possible accidents are avoided, and simultaneous combined service of a plurality of groups of servers is realized.

From the description of the above embodiments, it will be clear to a person skilled in the art that the method according to the above embodiments may be implemented by means of software plus the necessary general hardware platform, but of course also by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server, or a network device, etc.) to perform the method according to the embodiments of the present invention.

Example 2

The embodiment also provides a merging device of game servers, which is used for realizing the above embodiment and the preferred implementation, and the description is omitted. As used below, the term "module" may be a combination of software and/or hardware that implements a predetermined function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.

Fig. 5 is a block diagram showing a configuration of a merging apparatus of game servers according to an embodiment of the present invention, as shown in fig. 5, the apparatus comprising: an acquisition module 50, a generation module 52, a combination module 54, wherein,

An acquisition module 50 for acquiring annotation information of a database code, wherein the database code runs in a master game server and a slave game server, the annotation information is used for indicating a merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server;

A generation module 52 for generating an intermediate table structure of the target game database from the annotation information;

A merging module 54, configured to merge the slave game database and the master game database in the target game database according to the intermediate table structure.

It should be noted that each of the above modules may be implemented by software or hardware, and for the latter, it may be implemented by, but not limited to: the modules are all located in the same processor; or the above modules may be located in different processors in any combination.

Example 3

The embodiment of the application also provides an electronic device, and fig. 6 is a structural diagram of the electronic device according to the embodiment of the application, as shown in fig. 6, including a processor 61, a communication interface 62, a memory 63 and a communication bus 64, where the processor 61, the communication interface 62 and the memory 63 complete communication with each other through the communication bus 64, and the memory 63 is used for storing a computer program;

the processor 61 is configured to execute the program stored in the memory 63, and implement the following steps:

Acquiring annotation information of a database code, wherein the database code runs in a master game server and a slave game server, the annotation information is used for indicating a merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server; generating an intermediate table structure of a target game database according to the annotation information; and merging the slave game database and the master game database in the target game database according to the intermediate table structure.

The communication bus mentioned by the above terminal may be a peripheral component interconnect standard (PERIPHERAL COMPONENT INTERCONNECT, abbreviated as PCI) bus or an extended industry standard architecture (Extended Industry Standard Architecture, abbreviated as EISA) bus, etc. The communication bus may be classified as an address bus, a data bus, a control bus, or the like. For ease of illustration, the figures are shown with only one bold line, but not with only one bus or one type of bus.

The communication interface is used for communication between the terminal and other devices.

The memory may include random access memory (Random Access Memory, RAM) or may include non-volatile memory (non-volatile memory), such as at least one disk memory. Optionally, the memory may also be at least one memory device located remotely from the aforementioned processor.

The processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, abbreviated as CPU), a network processor (Network Processor, abbreviated as NP), etc.; but may also be a digital signal processor (DIGITAL SIGNAL Processing, DSP), application Specific Integrated Circuit (ASIC), field-Programmable gate array (FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware components.

In yet another embodiment of the present application, a computer readable storage medium is provided, in which instructions are stored, which when run on a computer, cause the computer to perform the method for processing risk level data according to any of the above embodiments.

In a further embodiment of the present application, a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method for processing risk level data according to any of the above embodiments is also provided.

In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, produces a flow or function in accordance with embodiments of the present application, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in or transmitted from one computer-readable storage medium to another, for example, by wired (e.g., coaxial cable, optical fiber, digital Subscriber Line (DSL)), or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., solid state disk Solid STATE DISK (SSD)), etc.

The foregoing embodiment numbers of the present application are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.

In the foregoing embodiments of the present application, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.

In the several embodiments provided in the present application, it should be understood that the disclosed technology may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units, such as the division of the units, is merely a logical function division, and may be implemented in another manner, for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.

The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.

The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a usb disk, a read-only memory (ROM), a random access memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.

The foregoing is merely a preferred embodiment of the present application and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present application, which are intended to be comprehended within the scope of the present application.

Claims

1. A method of merging game servers, comprising:

Acquiring annotation information of a database code, wherein the database code runs in a master game server and a slave game server, the annotation information is used for indicating a merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server;

generating an intermediate table structure of a target game database according to the annotation information;

merging the slave game database and the master game database in the target game database according to the intermediate table structure;

Wherein obtaining annotation information of the database code comprises: traversing all classes in the database code, and searching a class file containing entity annotation; reading annotation parameters in the class file, wherein the annotation parameters comprise: a table identifier and a field attribute, wherein the table identifier is used for indicating the merging type of the master game database and the slave game database, and the field attribute is used for indicating the constraint condition of corresponding fields in the master game database and the slave game database;

Wherein generating an intermediate table structure of the target game database from the annotation information comprises: analyzing a first annotation parameter of the annotation information, and determining the merging type of the game database as a newly added form or an updated form based on the first annotation parameter; if the merging type is a newly added form, analyzing a second annotation parameter of the annotation information, acquiring a field constraint condition of a code field based on the second annotation parameter, and generating a first MySQL statement by using the field constraint condition; if the merging type is the updated form, generating a second MySQL statement by using the newly added field attribute; an intermediate table structure is generated in a target game database based on the first MySQL statement or the second MySQL statement.

2. The method of claim 1, wherein generating the first MySQL statement using a field constraint comprises:

Traversing all enumerated fields in a class of the database code;

obtaining constraint conditions of the enumeration field through the annotation information;

and generating a first MySQL statement through the constraint condition, wherein the first MySQL statement is used for creating a new table structure in the target game database.

3. The method of claim 2, wherein the constraints include at least one of: the field type, the field length, whether the field is an index, whether the field is null, the field default value, and the annotation information of the field.

4. The method of claim 1, wherein generating a second MySQL statement using the added field attribute comprises:

Searching a first field list of a target table in the master game database, and acquiring a second field list of the target table in the slave game database;

Comparing whether the first field list and the second field list are identical;

if the first field list and the second field list are the same, generating a second MySQL statement based on the attribute differences of the master game database and the slave game database, wherein the attribute differences are used for representing at least one of the following: whether the field is newly added with an index, whether the field length is changed, and whether the field type is changed; and if the first field list and the second field list are different, splicing the difference fields of the master game database and the slave game database to generate a second MySQL statement, wherein the second MySQL statement is used for updating the table structure of the target table in the target game database.

5. The method of claim 1, wherein prior to merging the secondary game database and the primary game database in the target game database according to the intermediate table structure, the method further comprises:

Determining whether a repeated game element exists in the intermediate table structure, wherein the game element comprises at least one of the following: a game player identification, a game Gang identification;

And if repeated game elements exist in the middle table structure, adding a rename mark on the game elements, and distributing a rename card for the corresponding game account.

6. The method of claim 1, wherein prior to generating the intermediate table structure of the target game database from the annotation information, the method further comprises:

And deleting the game data of the designated account number from the main game database, wherein the designated account number is used for representing that the game activity of the player is lower than a designated threshold value.

7. A merging device of game servers, comprising:

The system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring annotation information of a database code, the database code is operated in a master game server and a slave game server, the annotation information is used for indicating the merging type of the master game database and the slave game database, the master game database is stored in the master game server, and the slave game database is stored in the slave game server;

The generation module is used for generating an intermediate table structure of the target game database according to the annotation information;

A merging module, configured to merge the slave game database and the master game database in the target game database according to the intermediate table structure;

Wherein, the acquisition module includes: the searching unit is used for traversing all classes in the database code and searching class files containing entity annotation; the reading unit is used for reading annotation parameters in the class file, wherein the annotation parameters comprise: a table identifier and a field attribute, wherein the table identifier is used for indicating the merging type of the master game database and the slave game database, and the field attribute is used for indicating the constraint condition of corresponding fields in the master game database and the slave game database;

Wherein, the generating module includes: the analysis unit is used for analyzing a first annotation parameter of the annotation information, and determining the merging type of the game database as a newly added form or an updated form based on the first annotation parameter; the first generation unit is used for analyzing a second annotation parameter of the annotation information if the merging type is a new added form, acquiring a field constraint condition of a code field based on the second annotation parameter, and generating a first MySQL statement by using the field constraint condition; if the merging type is the updated form, generating a second MySQL statement by using the newly added field attribute; and the second generation unit is used for generating an intermediate table structure in the target game database based on the first MySQL statement or the second MySQL statement.

8. A storage medium having a computer program stored therein, wherein the computer program is arranged to perform the method of any of claims 1 to 6 when run.

9. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to run the computer program to perform the method of any of claims 1 to 6.