×
Community Blog How to Set up and Configure Alibaba Cloud ApsaraDB for PolarDB

How to Set up and Configure Alibaba Cloud ApsaraDB for PolarDB

This article explains how to set up and configure Alibaba Cloud ApsaraDB for PolarDB.

By Kelvin Galabuzi

What Is ApsaraDB for PolarDB?

Alibaba Cloud ApsaraDB for PolarDB is a relational database built for resource-intensive database applications. PolarDB supports multiple SQL engines, such as MySQL, PostgreSQL, and Oracle.

ApsaraDB for PolarDB also supports a large storage capacity of up to 100TB of data. It is highly stable and provides data security and higher performance compared to traditional database workloads.

Core ApsaraDB for PolarDB Features

  • Dedicated Compute and Storage: ApsaraDB for PolarDB has dedicated compute nodes to execute SQL queries and multiple storage nodes to store database data. In addition, Apsara has the on-demand storage capacity to allow unpredictable storage needs.
  • Improved Performance: ApsaraDB for PolarDB features cutting-edge database performance. Each PolarDB node can handle millions of queries per second, autoscaling to meet varying demands.
  • Scaling out of Read-Only Instances: Read-only instances can be created in a few minutes with ApsaraDB for PolarDB to meet intensive read requirements, and these instances can be set up in a few minutes.
  • Quick Data Backup and Recovery: You can backup database data in just a few seconds with ApsraDB for PolarDB. Recovery times also happen in record time to ensure fewer downtimes.
  • Quick Data MIgration: ApsaraDB for PolarDB supports quick migrations from RDS MySQL databases to PolarDB.

Setting up an Alibaba Cloud ApsaraDB for PolarDB

  • Step 1: On the Alibaba Cloud Console, access the ApsaraDB for PolarDB service under the Relational Databases section:

1

  • Step 2: On the ApsaraDB for PolarDB console, click Create Cluster:

2

  • Step 3: Select the Billing Type, the Region, Creation Method, Primary Availability, and Network Type:

3

  • Step 4: Select the VPC, vSwitch, Compatibility, Edition, Specification Type, Node Specification, and number of Nodes. Then, provide a Cluster Name, the number of nodes, and click Buy Now:

4
5

  • Step 5: Review all the configurations you have set and accept the terms of service. Click Activate Now:

6

  • Step 6: After a few minutes, the new cluster will show up in the ApsaraDB for PolarDB console:

7

  • Step 7: Create a database account to start managing the database:

8

  • Step 8: Create the account with the password and click OK:

9

  • Step 9: Select Log On to Database, which will launch the Data Management Service interface where you can work with your ApsaraDB for PolarDB:

10

  • Step 10: In the Data Management Service, insert all the database type, instance region, instance id, database account, and database password and click Login:

11

  • Step 11: After logging in to the console, you can start managing your ApsaraDB for PolarBD databases within your newly created Database cluster:

12

Optional Features

You can create multiple databases in your ApsaraDB for PolarDB cluster by accessing the Databases blade:

13

Give your database a name, set the supported character set, choose the authorized database account, account permissions and description, and click OK:

14

Your created databases will appear within the databases section:

15

0 0 0
Share on

Alibaba Cloud Community

500 posts | 43 followers

You may also like

Comments

Alibaba Cloud Community

500 posts | 43 followers

Related Products

  • PolarDB

    PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle.

    Learn More
  • PolarDB-X

    Designed to address database challenges such as ultra-high concurrency, massive data storage, and large table performance bottlenecks.

    Learn More
  • PolarDB Stack

    A cloud-native database management platform that allows you to manage on-premises databases in the same way as in Alibaba Cloud.

    Learn More
  • ApsaraDB for OceanBase

    A financial-grade distributed relational database that features high stability, high scalability, and high performance.

    Learn More