Buying a GaussDB Instance and Connecting to It Using gsql

Operation Process

Buying an Instance

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB.
4. On the Instances page, click Buy DB Instance.
5. On the displayed page, enter DB Instance Name, select DB Engine Version, DB Instance Type, and Deployment Model, and complete other configurations.

   Table 1 Parameters

   Parameter	Example Value	Description
   Billing Mode	Pay-per-use	GaussDB provides yearly/monthly billing and pay-per-use billing. Yearly/Monthly: You pay upfront for the amount of time you expect to use the DB instance for. You will need to make sure you have a top-up account with a sufficient balance or have a valid payment method configured first. Pay-per-use: You can start using the DB instance first and then pay as you go. Pricing is listed on a per-hour basis, but bills are calculated based on the actual usage duration.
   Region	EU-Dublin	Region where the tenant is located. Products in different regions cannot communicate with each other over a private network. After the instance is created, you cannot change its region.
   DB Instance Name	gauss-d0a7	The instance name is case-sensitive, must start with a letter, and can contain 4 to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed.
   Edition Type	Enterprise edition	GaussDB provides Basic edition and Enterprise edition. The basic edition lacks certain advanced features that are available in the enterprise edition. The basic edition delivers the same level of performance as the enterprise edition at a more affordable price. This edition is ideal for users who prioritize cost and do not need advanced features.
   DB Engine Version	V2.0-8.103	GaussDB database version.
   DB Instance Type	Centralized	Distributed: You can add nodes for distributed instances as needed to handle large volumes of concurrent requests. Centralized: Centralized instances are suitable for scenarios with small and stable volumes of data, where data reliability and service availability are extremely important.
   Deployment Model	1 primary + 2 standby	Distributed Independent: Database components are deployed on different nodes. This model is suitable for where high availability and stability are required and the instance scale is large. Centralized HA (1 primary + 2 standby): 3-node deployment where there is one shard. The shard contains one primary DN and two standby DNs. Single: single-node deployment where there is only one CMS component and one DN. This model is only available for instances of V2.0-2.2 or later.
   AZ	AZ1	An AZ is a physical region where resources have independent power supply and networks. AZs are physically isolated but interconnected through an internal network.
   Time Zone	(UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi	You need to select a time zone for your instance based on the region it is hosted in.

6. Configure instance specifications.

   Table 2 Parameters

   Parameter	Example Value	Description
   Instance Specifications	Dedicated(1:4), 4 vCPUs | 16 GB	The vCPUs and memory of an instance.
   Storage Type	Ultra-high I/O	The storage type determines the read/write speed of an instance. The higher the maximum throughput is, the higher the instance read/write speed can be.
   Storage Space	40 GB	The storage space contains the file system overhead required for inodes, reserved blocks, and database operations.
   Disk Encryption	Disable	Enabling disk encryption improves data security, but slightly affects the read and write performance of the database.

7. Retain the default settings for the network information.

8. Configure the instance password.

   Table 3 Parameters

   Parameter	Example Value	Description
   Administrator Password	-	Enter a strong password and periodically change it to improve security, preventing security risks such as brute force cracking.
   Confirm Password	-	Enter the administrator password again.
   Enterprise Project	default	If the instance has been associated with an enterprise project, select the target project from the Enterprise Project drop-down list. You can also go to the Enterprise Project Management console to create a project. .

9. Click Create Now, confirm the instance information, and click Submit.
10. Go to the instance list.

    If status of the instance becomes Available, the instance has been created.

Buying an ECS

GaussDB provides the gsql tool to help you connect to a database using the command-line interface (CLI). Before the connection, you need to create an ECS for installing the gsql tool.

1. Log in to the management console.
2. Click in the upper left corner of the page and choose Computing > Elastic Cloud Server to go to the Elastic Cloud Server console.
3. On the page that is displayed, click Buy ECS.
4. Configure basic settings and click Next: Configure Network.
   • Region: Select the region of the GaussDB instance to be connected.
   • Billing Mode: Pay-per-use
   • AZ: Select the AZ of the GaussDB instance to be connected.
   • Image: EulerOS and EulerOS 2.5 64bit(40 GiB)
   • Retain the default values for other parameters.

5. Configure the ECS network and click Next: Configure Advanced Settings.
   • Network: Select the VPC of the GaussDB instance to be connected.
   • Security Group: Select the security group of the GaussDB instance to be connected.
   • EIP: Not required

6. Configure a password for the ECS, set other parameters as required, and click Next: Confirm.
   • ECS Name: Enter a name that is easy to identify.
   • Password: Set a strong password to improve security.
   • Confirm Password: Enter the password again.
   • Retain the default values for other parameters.

7. Confirm the configuration and click Submit.
8. View the ECS.

Connecting to a Database

GaussDB lets you select either SSL or non-SSL connections as required.