Shulou(Shulou.com)05/31 Report--

This article is about how to carry out Serverless DB design interpretation and actual combat, the editor feels very practical, so share with you to learn, I hope you can get something after reading this article, say no more, follow the editor to have a look.

Serverless DB!

Let's take a look at it together.

Serverless PostgreSQL component

PostgreSQL for Serverless is a database product that allocates resources on demand based on PostgreSQL database, and its database will automatically allocate resources according to the actual number of requests of users. Through the PostgreSQL ServerlessDB component, users can quickly and easily create, configure and manage Tencent Cloud PostgreSQL instances.

The product has the following characteristics:

Low cost: the product is billed according to the computing resources and capacity used by the user, and there is no need to pay when there is no request, so the use cost is reduced.

Convenient configuration: the default configuration will be completed by Serverless for users, and users can also change it in the yaml file, which can be completed in just a few lines, making it easier for users to better pay attention to their business logic.

Rapid deployment: the deployment process is smooth and fast, and it takes only a few seconds to create or update the database.

High availability: PostgreSQL for Serverless supports one master and one slave with high availability. When the primary instance is unavailable due to an accident, the database will automatically start the standby instance, and the business connection will be transferred to the standby instance to prevent the database from being unavailable due to unexpected circumstances.

Serverless TCB component

When dealing with big data, users often need to face problems such as high concurrency of reading and writing, efficient storage of massive data, high scalability and so on. The traditional RMDB database is difficult to meet the needs of users, and SLS needs to support the creation of NoSQL DB. With the Serverless TCB component based on cloud development TCB, users create the tcb environment through this component, directly call the SDK of tcb in the code, and realize the creation and invocation of NoSQL DB in the tcb environment.

The product has the following advantages:

Full compatibility: the database is fully compatible with MongoDB protocol, which is not only suitable for traditional table structure scenarios, but also suitable for caching, non-relational data and parallel operations of large-scale data sets using MapReduce.

High security: cloud database saves backup data for many days through backup mechanism to facilitate data recovery in case of disaster.

Low cost: postpaid, users do not have to pay extra for unused resources.

Rapid deployment, easy to operate: users only need a few lines of code to complete the configuration, fast deployment and high efficiency.

Having said so much, let's try it together.

Preparation: install Node.js (Node.js version should be no less than 8.6, Node.js10.0 or above is recommended)

Nodejs download address: https://nodejs.org/en/download/

For partners who have not yet installed, you can guide the installation to complete through the following documentation: Serverless Framework Quick start

Practice 1: deploy Vue + Express + PostgreSQL full-stack website

To install Serverless Framework globally through npm:

$npm install-g serverless

After installation, check the version information of Serverless Framework with the following command to make sure that the version is no less than Components: 2.30.1

$serverless-v

Create a new local folder serverless-wty and download the relevant template.

$mkdir serverless-wty & & cd serverless-wty$ serverless create-- template-url https://github.com/serverless-components/tencent-fullstack

Currently, PostgreSQL does not support one-click deployment. Please create a .env file locally and configure the corresponding Tencent Cloud SecretId, SecretKey, region and availability zone information in it.

$touch .env vim.env

.env

TENCENT_SECRET_ID=xxx / / SecretId of your account

TENCENT_SECRET_KEY=xxx / / SecretKey of your account

Configuration of regional availability zone

REGION=ap-guangzhou / / resource deployment area, which refers to the cloud function and static page deployment area in this project

ZONE=ap-guangzhou-2 / / Resource deployment availability zone, which in this project refers to the availability zone where DB deployment is located

Note: if you do not have a Tencent Cloud account, please register a new account first. If you already have a Tencent Cloud account, make sure that your account has been granted AdministratorAccess permission. You can get SecretId and SecretKey in API key management.

ZONE only supports ap-beijing-3, ap-guangzhou-2, ap-shanghai-2.

Install the required dependencies by executing the following command

$npm run bootstrap

Execute the following command to deploy

$sls deploy-all

After the deployment is successful, you can use a browser to access the website link generated by the project to see the generated Web site.

Execute the following command to view the deployment information of the project: vpc, db, api, frontend (front-end website)

$npm run info

Execute the following command to remove the project

$sls remove-all

The above actual combat mainly consists of the following components:

Serverless RESTful API: RESTful API is implemented through the Express framework built by SCF and API gateway.

Serverless static Web site: the front end hosts Vue.js static pages to the COS object store.

PostgreSQL Serverless: provides database services for full-stack websites by creating PostgreSQL DB. VPC: provides network access and use of SCF cloud functions and databases by creating VPC and subnets.

Practice 2: deploy a full-stack website that supports NoSQL databases

To install Serverless CLI globally through npm:

$npm install-g serverless

After installation, check the version information of Serverless Framework with the following command to make sure that the version is no less than Components: 2.30.1

$serverless-v

Create a new local folder and use the create-- template-url command to download the relevant template:

$mkdir my_tcbdemo & & cd my_tcbdemo$ serverless create-- template-url https://github.com/serverless-components/tencent-mongodb/tree/master/example/fullstack-demo

Find the function- > serverless.yaml file, enter your own SecretId and SecretKey, and then go to the function- > src folder directory to install the required dependencies to complete the configuration with the following command:

$npm install

Note: if you do not have a Tencent Cloud account, please register a new account first. If you already have a Tencent Cloud account, you can obtain SecretId and SecretKey in API key management. Currently, sls (short for serverless) supports accessing TCB in domestic regions. Please pay attention to the region settings in the yaml file when deploying. Errors may occur in other regions.

After the configuration is completed, go to the root directory, deploy with the following command, create a new cloud development environment, deploy the backend code to the cloud function SCF platform, and deploy the static website through the website component:

$sls deploy-all

Visit the website url output from the command line to view your Serverless site.

Note:

Due to the restriction of the running role of sls, the user needs to log in to access the administrative role page and manually add the policy of TCBFullAccess for SLS_QcsRole, otherwise it will not work properly.

The current deploy-all directive only supports version 2.30.1 or above of Serverless Framework Component. Please make sure that your component has been updated to the latest version.

Currently, the TCB only supports the creation and destruction of an environment up to 4 times a month. Please create it carefully. If you deploy more than 4 times, an error will be reported.

The DB component defaults to creating a free cloud development environment. If you already have this environment, you will report an error during deployment. Delete the yaml file in the db folder and enter the ID of your existing TCB environment in the MongoId parameter in the yaml file of function to complete the project assignment.

After deployment, you can remove the project with the following command:

$sls remove-debug

The above actual combat mainly consists of the following components:

Serverless Website: the front end hosts HTML static pages to the object store COS.

Serverless Cloud Function: the backend function is deployed to the cloud and triggered by HTTP.

Cloud development TCB environment: provide database services for full-stack websites by creating a cloud development environment and calling NoSQL DB.

Serverless PostgreSQL components and Serverless TCB components not only meet the needs of people to use databases through cloud resources, but also support two database types: PostgreSQL and NoSQL. You can choose the appropriate components to complete deployment according to your usage habits.

The above is how to carry out Serverless DB design interpretation and actual combat, the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.