PostgreSQL ServerlessDB Component

Last updated: 2020-07-31 11:05:44

    Operation Scenarios

    PostgreSQL for Serverless (ServerlessDB) is a PostgreSQL-based database product that enables on-demand allocation of resources. It can automatically allocate resources according to the actual number of requests. You can simply create a database instance to use PostgreSQL for Serverless without caring about instance specification, and you only need to pay for resource usage during active period of the instance.

    Through the PostgreSQL ServerlessDB component, you can create, configure, and manage Tencent Cloud PostgreSQL instances with speed and ease.

    Features:

    • Pay per use: fees are charged based on the request usage, and you don't need to pay anything if there is no request.
    • Zero configuration: the default configuration is implemented by Serverless.
    • Fast deployment: you can create or update your database in a matter of seconds.
    • Convenient collaboration: the status information and deployment logs of the database in the cloud make multi-person collaborative development easier.

    Directions

    Installation

    Use npm to install Serverless CLI globally:

    $ npm install -g serverless

    Account configuration

    Create the .env file locally:

    $ touch .env # Tencent Cloud configuration information

    Configure Tencent Cloud's SecretId and SecretKey information in the .env file and save it:

    # .env
    TENCENT_SECRET_ID=123
    TENCENT_SECRET_KEY=123

    Note:

    • If you don't have a Tencent Cloud account yet, please sign up first.
    • If you already have a Tencent Cloud account, you can get SecretId and SecretKey in API Key Management.

    Configuration

    Create a directory and enter it:

    $ mkdir tencent-postgreSQL && cd tencent-postgreSQL

    Create a serverless.yml file in the new directory:

    $ touch serverless.yml

    Configure serverless.yml as follows:

    # serverless.yml
    component: postgresql # (Required) Name of the imported component. The `postgresql` component is used in this example
    name: serverlessDB # (Required) Name of the instance created by the `postgresql` component
    org: test # (Optional) Organization information. The default value is the `appid` of your Tencent Cloud account.
    app: serverlessDB # (Optional) SQL application name
    stage: dev # (Optional) Information for identifying environment. The default value is `dev`.
    
    inputs:
      region: ap-guangzhou  # You can select `ap-guangzhou`, `ap-shanghai`, or `ap-beijing`
      zone: ap-guangzhou-2  # You can select `ap-guangzhou-2`, `ap-shanghai-2`, or `ap-beijing-3`
      dBInstanceName: serverlessDB
      vpcConfig:
        vpcId: vpc-xxxxxxx
        subnetId: subnet-xxxxxx
      extranetAccess: false

    The PostgreSQL ServerlessDB component supports "zero" configuration deployment, that is, it can be deployed directly through the default values in the configuration file. Nonetheless, you can also modify more optional configuration items to further customize your project.

    Detailed Configuration >>

    Note:

    Currently, PostgreSQL for Serverless instances can be created and deployed only in Beijing Zone 3, Guangzhou Zone 2, and Shanghai Zone 2. Therefore, when entering the region and AZ in the YAML file, please be sure to enter a correct region and corresponding VPC and subnet information.

    Deployment

    Deploy by running the sls command, and you can add the --debug parameter to view the information during the deployment process:

    Note:

    sls is short for the serverless command.

    $ sls deploy

    Removal

    You can run the following commands to remove the deployed database instance:

    $ sls remove

    More Components

    You can view more component information in the repository of Serverless Components.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help