Combined server test (1) and combined Server Test

Combined server test (1) and combined Server Test
Server test (1)

1) Advance rehearsals of some services on the Intranet, such as level or point ranking information, pvp data, and pve level ranking. <-- Based on the game business

2) create at least two databases in the intranet and execute script merge.

3) Assume that a disconnection occurs. If the script fails, run the script again to check whether the data is abnormal.

4) Prepare the zone server account used by the Internet in advance, and record the roleid, zone server information, channel account, and password.

The field names are referenced.
1) Merge the game database to the same mysql server. Assume that the game database is merged in three zones: 1, 2, and 3. The database names are gm1, gm2, and gm3.
2) create an empty database with the same structure as the existing Game Database, empty table. (check that the table structure of each database is consistent.) This database is used as the new database after merging.
3) scripts. By default, the database with the name "sr" is merged. The database name of gd1 is changed to sr, and the script is executed to merge to the new database.
4) The gm2 database name is changed to sr, and then merged in this way. Check the database in the first partition after merging.


After Dump data to the Intranet
In the test, you need to filter out several Internet accounts, one in each zone.
1) verify the correctness of the script first (jump to the script)
2) Verify intranet data.
3) return to the Internet Test server for verification.
4) create a platform account and associate it with the previous role roleid
5) Verify the Internet Test server account
6) The dirty data must be verified by the platform.
7) O & M 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 ,...;


Check which tables delete from are clean by configuring the account in advance.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.