{Alibaba AnalyticDB for MySQL} Getting started with Data Warehouse Edition

https://www.alibabacloud.com/help/en/analyticdb-for-mysql/getting-started/getting-started-for-data-warehouse-edition/
https://www.alibabacloud.com/en/product/analyticdb-for-mysql

 

Data Warehouse Edition (V3.0) in elastic mode
8 Cores 32GB -> $0.342/Piece

前提:
コンソールよりService-linked Role作成済み
Role Name: AliyunServiceRoleForAnalyticDBForMySQL
Permission Policy: AliyunServiceRolePolicyForAnalyticDBForMySQL
Role Description: AnalyticDB for MySQL can use this role to manage logs and synchronize data.

 

 

-- 1. クラスターの作成

aliyun adb DescribeAvailableResource \
--endpoint adb.ap-northeast-1.aliyuncs.com

 

 

aliyun adb CreateDBCluster \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterCategory MixedStorage \
--DBClusterNetworkType VPC \
--DBClusterVersion 3.0 \
--PayType Postpaid \
--ComputeResource 8Core32GB \
--DBClusterDescription cluster01 \
--DiskEncryption false \
--ElasticIOResource 0 \
--Mode Flexible \
--VPCId vpc-111111111111111111111 \
--VSwitchId vsw-111111111111111111111 \
--ZoneId ap-northeast-1a 

 

aliyun adb DescribeDBClusters \
--endpoint adb.ap-northeast-1.aliyuncs.com

 

-- 2. アカウントの作成

aliyun adb CreateAccount \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--AccountName user01 \
--AccountPassword 'password' \
--DBClusterId am-11111111111111111 \
--AccountDescription user01 \
--AccountType Super 

 

aliyun adb DescribeAccounts \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111 

 

-- 3. ホワイトリストの設定

aliyun adb ModifyDBClusterAccessWhiteList \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111 \
--SecurityIps "192.0.2.1/32" \
--ModifyMode Append 

 

aliyun adb DescribeDBClusterAccessWhiteList \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111 

 

-- 4. パブリック接続許可

aliyun adb AllocateClusterPublicConnection \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111 

-- 5. 動作確認

mysql -h am-11111111111111111222222.japan.ads.aliyuncs.com -u user01 -p

create database adb_demo;

create database if not exists adb_demo2;

show databases;

 

 

-- 6. クリーンアップ

aliyun adb ReleaseClusterPublicConnection \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111 

aliyun adb DescribeAccounts \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111 

aliyun adb DeleteAccount \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111 \
--AccountName user01 

aliyun adb DescribeDBClusters \
--endpoint adb.ap-northeast-1.aliyuncs.com

aliyun adb DeleteDBCluster \
--endpoint adb.ap-northeast-1.aliyuncs.com \
--DBClusterId am-11111111111111111