DEV Community

leo
leo

Posted on • Updated on

GaussDB(for openGauss) FAQ

GaussDB (for openGauss) is an enterprise-level distributed relational database based on the openGauss ecosystem led by Huawei. It is a self-developed enterprise-level distributed relational database developed by Huawei.

The product has enterprise-level complex transaction mixed load capabilities, and supports excellent distributed transactions, cross-AZ deployment in the same city, zero data loss, support for 1000+ expansion capabilities, PB-level mass storage and other enterprise-level database features. It has key capabilities such as high availability, high reliability, high security, elastic scaling, one-key deployment, fast backup and recovery, monitoring and alarming on the cloud, and can provide enterprises with comprehensive functions, stability, reliability, scalability, and superior performance. Enterprise-level database services .
At the same time, Huawei open source openGauss stand-alone active and standby community version to encourage more partners and developers to jointly prosper China's database ecosystem.

Below is a summary of some frequently asked questions, see:

  1. Does GaussDB (for openGauss) support offline deployment?

Huawei open source openGauss stand-alone active and standby community version to encourage more partners and developers to jointly prosper China's database ecosystem. The stand-alone active and standby community version can be downloaded and deployed on the open source official website ( https://opengauss.org/zh/ ).

  1. Does GaussDB (for openGauss) support SSL connection?

Supported, see the SSL connection method at SSL connection ( https://support.huaweicloud.com/qs-opengauss/opengauss_01_0024.html ).

  1. How to choose the connection method of GaussDB (for openGauss)? (DAS, intranet, public network)?

● We strongly recommend that you use DAS to connect to the database. Through the Huawei Cloud Data Admin Service (DAS), you can perform functions such as SQL, advanced database management, and intelligent operation and maintenance to manage databases in an easy-to-use, secure, and intelligent manner.

● If the DAS connection is not used, it is recommended to use the intranet connection. For intranet connections, ensure that the ECS used is in the same region and VPC as GaussDB (for openGauss).

● If you need to connect to the database instance through the public network, you need to bind the elastic public network IP to the instance, and then connect to the elastic public network IP of the instance through the public network. For details, see Connecting to a Database Instance Through the Public Network ( https://support.huaweicloud.com/qs-opengauss/opengauss_01_0030.html ).

  1. How does GaussDB (for openGauss) grant users SUPER permissions?

GaussDB (for openGauss) cannot grant users SUPER privileges.
If the stored procedure cannot be imported, it is because some of the stored procedure statements require super permission. After removing these statements, the stored procedure can be imported normally.

  1. Does GaussDB (for openGauss) support both cold backup and hot backup?

GaussDB (for openGauss) only supports hot backup.

  1. Does GaussDB (for openGauss) support restoring to the original instance?

GaussDB (for openGauss) only supports recovery to a specified point in time and recovery to a new instance. Because database data is very important to customers, restoring to the original instance may be due to customer misoperation, which may cause risks such as data loss for a certain period of time. Therefore, it is currently recommended to restore data to a new instance.

  1. Import the root certificate into the Windows/Linux operating system.

Import Windows OS:
Click "Start", enter "MMC" in the run box, and press Enter.
Click "File" in the MMC console menu bar and select "Add/Remove Snap-in".
In the Add or Remove Snap-ins dialog box, select Certificates in the Available Snap-ins area. Click Add to add the certificate.
In the "Certificate Management" dialog box, select "Computer Account" and click "Next".
In the Select Computer dialog box, click Finish.
In the Add or Remove Snap-in dialog box, click OK.
In the MMC console, double-click Certificates.
Right-click Trusted Root Certification Authorities, select All Tasks, and click Import.
Click Next.
Click Browse and change the file type to All Files (.).
Locate the downloaded root certificate ca.pem file, click Open, and then click Next in the wizard.
(Note: You must change the file type to "All Files (.)" in the browse window to do this, as ".pem" is not a standard certificate extension.)
Click Next.
Click Finish.
Click OK to complete the root certificate import.

Import the Linux operating system:
You can use any terminal connection tool (such as WinSCP, PuTTY, etc.) to upload the certificate to any directory of the Linux system.

Top comments (0)