Shulou(Shulou.com)06/02 Report--

POLARDB background

POLARDB is a landmark new generation of relational database independently developed by Aliyun. It is a cloud managed database product that is fully compatible with MySQL. Adhering to the native design concept of Cloud Native, it adopts the design of distributed storage engine, and its performance can be up to 6 times that of MySQL. While providing high throughput and low latency OLTP services, POLARDB provides users with better online expansion services with lower cost.

-excerpt from POLARDB product introduction document

Architecture

Cdn.com/5891207b220a7678752eeafb4eb586dcb5a3d91a.png ">

Design features of the architecture:

Write and read many times

Separation of computing and storage

Separation of reading and writing

High-speed link interconnection

Shared distributed storage

Multiple copies of data, supporting Parallel-Raft protocol

Thinking: POLARDB is an excellent product in the evolution of Ali's technology system, and its power lies in: making these complex issues transparent through the architectural design of POLARDB, making the difficulties such as storage, synchronization and performance of large-scale data transparent, allowing technicians to focus on business development.

Experience POLARDB

Open products and services in turn-Cloud Database POLARDB

Choose the configuration you need

There are prepaid and pay-per-view, which can be selected according to your business needs. If the usage of your business scenario is stable, you can choose to pay in advance. If there is a need for flexible capacity expansion, you can choose to pay by quantity.

Example summary

POLARDB uses a distributed cluster architecture, with a cluster containing one primary instance and up to 15 read-only instances (to ensure high availability). The read-write separation database access feature is a transparent, highly available and adaptive load balancing capability provided free of charge by default in POLARDB clusters. This creation includes a primary instance (responsible for reading and writing) and a read-only instance (responsible for reading).

Instance details

Cluster outline

Cluster details

Create an account

The initial POLARDB account can only be set on the cluster details page and can be used to log in to any instance in the cluster.

Connect an instance

VPC (Virtual Private Cloud): it can be understood as a private network. If you are connected from Ali's ECS, it is recommended to use VPC. Note: this address is automatically generated and cannot be released.

Let's demonstrate how to connect POLARDB instances through VPC and public network:

VPC network

If you use ECS, it is recommended that you use this method: instance address: pc-xxxxxxxxx.mysql.polardb.rds.aliyuncs.com:3306 (xxxxxxxxx configures id for your instance) Port: 3306 (by default, check whether port 3306 is enabled in the firewall configuration of ECS) account: byronzoz password: xxxxxx

Log in through Aliyun's RDS interface:

Pros: log in through Aliyun's RDS, which is the easiest and does not require any clients to be installed.

Through Aliyun's ECS direct connection:

[byron@yanglaomap-prod] $mysql-u byronzoz@pi-xxxxxx-pi-xxxxxx.mysql.polardb.rds.aliyuncs.com:3306

This method is directly connected by command, which is no different from mysql operation.

Public network

Instance address: byronzoz-0.mysql.polardb.rds.aliyuncs.com port: 3306 account: byronzoz password: xxxxxx

In this test, we use the navicat client to connect, of course, you can use the client that comes with mysql is also OK.

Note: the public network needs to be added to the whitelist, otherwise the connection will not work. For example, my public network IP is: 171.221.xxx.xxx, which is also the pit I stepped on.

Build tables and transfer business

Ladies and gentlemen, this is your turn to play. Summary

Through a brief introduction to this article, you have a preliminary understanding of POLARDB:

POLARDB is 100% compatible with mysql.

Architecture Design of POLARDB

How to purchase POLARDB products

Create an instance

Create an account

Demonstrate two connections: VPC (via Aliyun RDS page and ECS server) and public network (Navicat client) to connect to the instance

POLARDB, as a new member of Aliyun system, can be quickly integrated with Aliyun's products, including VPC, ECS, RDS and so on. It is very easy to use. If you are a mysql veteran, you can get started very quickly with POLARDB. If you are a novice, follow the tutorial step by step, you can also get started quickly.

POLARDB's innovative architectural design has a lot of capabilities that mysql databases do not have or require a lot of effort to have. For example, POLARDB has multiple master and slave instances by default after creating instances. These features allow developers to focus on business implementation without paying attention to the horizontal expansion of the database, storage, networking and other energy-consuming things.

Of course, there are some shortcomings:

Whitelist. You need to set a whitelist under the public network connection. This is a bit tedious, and it is expected that this function can be further improved. For example, through policy groups, instead of configuring a set of whitelists for each cluster.

The user table cannot be accessed. This seems to limit the functionality of the database.

Documents. Many developers complain about Aliyun's technical documentation (orz...): non-standard and slow to update, which does not match the high-end Aliyun. Look forward to the future Aliyun all cloud product documents are in a unified format / template, so that it is easier to read, and it is recommended to synchronize with English documents (English Docs), after all, has taken the road of internationalization.

Some people may ask: the ECS I bought can also install mysql, why should I choose POLARDB alone?

The reason is simple: it takes a long time and effort to do the following:

Database network and node management

Master-slave configuration

Separation of reading and writing

Database expansion

Performance aspect

Data disaster recovery

.

POLARDB saves you the time you spend, and you just need to focus most of your energy on business development.

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.