Fit Test (i)
1) Conduct some business previews in the intranet in advance, such as rating or integration leaderboard information, PVP data, PVE level rankings, etc. <--according to the game business to
2) Set up at least 2 libraries in the network to perform a script merge.
3) Rehearsal a break, after the script fails, execute again if the data is abnormal.
4) in advance to prepare the external network needs to use the district service account number, record Roleid, district service information, channel account number, password.
Field names are referenced and need to be based on the actual
1) Collect the merged game library to the same MySQL server, the following assumption is a three-quarter-a-month merge, the database name is GM1,GM2,GM3.
2) build an empty library with the same structure as the existing game library, empty table. (Check that each library table structure is consistent) The library acts as a new merged library.
3) script. SQL defaults to merging the library named "SR", gd1 the library name to SR, and executes the script to merge into the new library.
4) Change the library name of GM2 to SR, and then merge the same. Push it in one click. You need to check 1 times after merging the libraries of the successful 1 extents.
Dump data into the intranet
Testing needs to filter out several external network accounts, each zone 1.
1) Verify the correctness of the script first. (Jump script problem)
2) intranet data validation.
3) Back to the external network test suit verification.
4) Set up the platform account and associate the previous role Roleid
5) Verify the external Network test service account
6) The platform is ultimately required to validate dirty data.
7) operation and maintenance verification
Script. sql
Delete from db_ table;
Replace into Db_ table (field 1, Field 2, Field 3, Field 4,...)
Select field 1, Field 2, Field 3, field 4,...;
See if the test needs to be configured in advance to check which tables delete from is clean
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Fit Test (i)
