Collecting Basic Information About Self-built Databases and Evaluating Specifications and Risks

Preparations

• Prepare a Windows server for installing the MgC Agent. Add a server to which the self-built database to be collected belongs. Complete the network and process collection task for later resource identification. For details, see Collecting Process and Network Information from Servers.
• You have completed deep collection for the server resources to which the self-built database belongs. For details, see Performing a Deep Collection for Servers.

Step 1: Identify Self-built Database Resources

1. To collect port information, resources must be accessible from external systems. If a resource is only accessed by internal services, it can still be identified, but its port information cannot be collected.
2. On Windows servers, only the ports of resources accessible via IPv4 can be collected. If a resource is accessed exclusively through IPv6, its port information cannot be collected.
3. If a component cannot be identified, for example, due to version differences, contact technical support.

1. Sign in to the MgC Agent console.
2. In the navigation pane, click Resources.
3. Select the server where the network and process collection task is complete and click Identify Resources above the list. The system starts resource identification. Resource identification will be displayed in the Source column of the server.
   • If the identification succeeds, all identified resources are automatically displayed in the resource list. You can filter these resources by deployment node name or ID, which correspond to the name and ID of the collected servers. Their sources are marked as Resource identification.

     

   • If the identification fails, move the cursor to Failed to check the failure cause and rectify the fault.

Step 2: Adding and Associating a Database Credential

1. Authorize the database user. For details, see Database Basic Information Collector.
2. Sign in to the MgC Agent console.
3. In the navigation pane, click Credentials.
4. Click Add Credential above the list.
   Figure 1 Adding a credential
   

5. Select Database for Resource Type, customize the Credential Name, select Username/Password for Authentication Method, then enter the username and password authorized in 1.
6. After the credential information is configured, click OK to save the credential.
7. Choose Associate Credential > Manual above the resource list.
8. Select the database credential added in 4 from the drop-down list. Associated credentials will be in the Associated status.
9. (Optional) Click Change in the Access Port column. In the displayed Change Port dialog box, modify the open port of the database as required to ensure that the database can be accessed.

Step 3: Download and Install the Database Basic Information Collector

1. Sign in to the MgC console.
2. In the navigation pane, click MgC Agent.
3. On the Collectors tab, click Download on the Database Basic Information Collector card, and click Download Installation Package.
4. Save the downloaded package to the MgC Agent installation directory (default installation directory: C:\MgC-Agent). For successful installation, place the package in the specified directory and do not change its name.

   

5. On the MgC Agent console, click Collectors in the navigation tree on the left and click Upgrade. If the Database Basic Information Collector tool is displayed, the installation is successful.

   

Step 4: Create a Resource Collection Task

1. In the navigation pane, click Tasks.
2. Click the Resource Collection Tasks tab and click Create Collection Task.
3. In the Basic Information area, configure basic information.
4. In the Resources area, select a database that has credentials configured. Only one database can be selected for each task.
5. In the Configuration Parameters area, set parameters according to Configuring Collector Parameters.
6. After the configuration is complete, click OK. The displayed task list shows the data source collection status.
7. After the database information is collected, click Resources in the navigation pane.
8. On the Resources tab, select a database whose data is successfully collected, click Export, and click Export Selected to JSON to download the collected data.

   

Step 5: Import Database Collection Results

1. Sign in to the MgC console. In the navigation pane on the left, select an application migration project.
2. In the navigation pane, click Resource Discovery.
3. Click the Import tab. Then click the Import card.
   Figure 2 Import
   

4. Click Import collection results and click Add File to upload the .zip file exported in Step 4: Create a Resource Collection Task. The Task Center page will be displayed for you to check the progress.
5. Wait until the task progress reaches 100%. Go back to the resource list to check the imported database resources.

   

6. (Optional) Click a database resource name to check its sub-databases, host machine specifications, and disk information.
7. (Optional) Click the drop-down arrow on the left of a database resource name to check its sub-database details. Click each sub-database to check the details, such as partition tables and tables without primary keys.

Step 6: Create and Check a Database Assessment Task

1. In the navigation pane on the left, click Assessment.
2. On the Target Recommendations tab, click Generate Target Recommendations.
3. Enter a report name, set Scope to Selected Resource, and click Database in the resource list. Select resources for which you want the system to assess migration risks, and click Next.
4. Select a Target Region, complete the configuration, and click Create Assessment.
5. You will be directed to the Target Recommendations page to check the assessment status.
6. After the status becomes Completed, click a report name to check details.
7. In the Target Configurations area, check recommendations for each type of resources. The Target Configuration column displays the recommended specifications of Huawei Cloud resources based on the source resource specifications and assessment settings. The Assessment Priority column shows how you balance performance and costs and the migration strategy. The Billing Mode column shows the billing mode you selected for target resources. The Cost Estimation column provides the estimated costs of the recommended Huawei Cloud resources.

   

8. Check the risk assessment result. Click the drop-down arrow on the left of a database resource name to check its sub-database details. Click a sub-database name and check its risk assessment result.