Amazonrds 简明教程

Amazon RDS - MySQL Creating DB

作为云平台，AWS让你只需很少的步骤即可在RDS中设置一个数据库。可以通过三种方式创建MYSqlDB。使用AWS管理控制台、AWS CLI或AWS API。我们将一个接一个地了解每种方法。

As a cloud platform AWS gives you very minimal number of steps to setup a DB in RDS. Creating a MYSqlDB can be done in three ways. Using AWS management console, AWS CLI or AWS API. We will look at each of these approaches one by one.

Using AWS management Console

AWS管理控制台是开始使用RDS最便捷的方式。使用AWS帐户详细信息登录AWS控制台，找到RDS服务，然后按照下面所示的步骤创建一个MariaDB实例。

AWS management console is the most convenient way to get started with RDS. You login to the AWS console using your AWS account details, locate the RDS service and then follow the steps shown below to create a MariaDB instance.

Step-1

从控制台中选择MSSql Engine。

Select the MSSql Engine form the console.

create mysqldb step 1

Step-2

指定所需的数据库详细信息。

Specify the required DB details.

create mysqldb step 3

Step-3

在本步骤中，您确定数据库实例类型、分配的存储量、设置主密码以及其他一些详细信息。

In this step you decide on the db instance class, amount of storage allocated also set the master password along with few other details.

create mysqldb step 4

Stpe—4

最后一步是单击创建数据库，然后创建 MySQL 数据库，并显示可用的端点，如下所示。

The final step is to click create database, after which the MySql DB is created with a available end point as shown below.

connecting mysql 1

Using CLI

要使用 AWS CLI 创建 MySQL 数据库实例，请使用以下参数调用 create-db-instance 命令。

To create a MySql DB instance by using the AWS CLI, call the create-db-instance command with the parameters below.

aws rds create-db-instance \
    --db-instance-identifier mydbinstance \
    --db-instance-class db.m1.small \
    --engine MySQL \
    --allocated-storage 20 \
    --master-username masterawsuser \
    --master-user-password masteruserpassword \
    --backup-retention-period 3

Using API

要使用 Amazon RDS API 创建 MariaDB 实例，我们使用以下所示的参数调用 CreateDBInstance 操作。

To create a MariaDB instance by using the Amazon RDS API, we call the CreateDBInstance action with the parameters as shown below.

https://rds.us-west-2.amazonaws.com/
    ?Action=CreateDBInstance
    &AllocatedStorage=20
    &BackupRetentionPeriod=3
    &DBInstanceClass=db.m3.medium
    &DBInstanceIdentifier=mydbinstance
    &DBName=mydatabase
    &DBSecurityGroups.member.1=mysecuritygroup
    &DBSubnetGroup=mydbsubnetgroup
    &Engine=mysql
    &MasterUserPassword=masteruserpassword
    &MasterUsername=masterawsuser
    &Version=2014-10-31
    &X-Amz-Algorithm=AWS4-HMAC-SHA256
    &X-Amz-Credential=AKIADQKE4SARGYLE/20140213/us-west-2/rds/aws4_request
    &X-Amz-Date=20140213T162136Z
    &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date
    &X-Amz-Signature=8052a76dfb18469393c5f0182cdab0ebc224a9c7c5c949155376c1c250fc7ec3