Help Center/ GaussDB/ Best Practices/ Resource Planning
Updated on 2024-09-05 GMT+08:00

Resource Planning

Table 1 Resource planning

Category

Subcategory

Planned Value

Remarks

VPC

VPC name

vpc-src-172

Specify a name that is easy to identify.

Region

Test region

For low network latency and quick resource access, select the region nearest to you.

AZ

AZ3

-

Subnet

172.16.0.0/16

Select a subnet with sufficient network resources.

Subnet name

subnet-src-172

Specify a name that is easy to identify.

On-premises Oracle database

Name

orcl

Specify a name that is easy to identify.

Specifications

16 vCPUs | 32 GB

-

Database version

11.2.0.1

-

Database user

test_info

Specify a username. The user must have the following permissions during migration: CREATE SESSION, SELECT ANY TRANSACTION, SELECT ANY TABLE, SELECT ANY DICTIONARY, and EXECUTE_CATALOG_ROLE.

GaussDB

Instance name

Auto-drs-gaussdbv5-tar-1

Specify a name that is easy to identify.

Database version

GaussDB 3.226 Enterprise Edition

-

Instance type

Distributed (3 CNs, 3 DN shards, and 3 replicas)

In this example, a distributed instance will be created.

Deployment model

Independent

-

Transaction consistency

Strong consistency

-

Shards

3

-

Coordinator nodes

3

-

Storage type

Ultra-high I/O

-

AZ

AZ 2

In this example, a single AZ is select. You are advised to select multiple AZs to improve instance availability in actual use.

Instance specifications

Dedicated (1:8); 8 vCPUs | 64 GB

Small specifications are selected for this test instance. You are advised to configure specifications based on service requirements in actual use.

Storage space

480 GB

A small storage space is selected for this test instance. You are advised to configure the storage space based on service requirements in actual use.

Disk encryption

Disable

In this example, disk encryption is disabled. Enabling disk encryption improves the security of data, but may slightly affect the database read/write performance.

Logging in to the database through DAS

DB engine

GaussDB

-

Database source

GaussDB

Select the GaussDB instance created in this example.

Database name

postgres

-

Username

root

-

Password

-

Password for user root of the GaussDB instance created in this example

DRS migration task

Migration task name

DRS-test-info

Specify a name that is easy to identify.

Destination database name

test_database_info

Specify a name that is easy to identify. The name must be compatible with the Oracle database name.

Source DB engine

Oracle

-

Destination DB engine

GaussDB

-

Network type

Public

In this example, a public network is used.