The Alibaba Cloud ADS User Manual explains how to enable the service, create databases and tables, import data, connect applications, and manage users.
About this manual
This manual provides step‑by‑step instructions for using Alibaba Cloud's Analytic Database (ADS). It covers service activation, database and table creation, data import methods, connection details for various programming languages, and user permission management.
Key sections include a Quick Start guide, detailed procedures for creating and managing tables, importing data from ODPS or other sources, connecting via PHP, Java, or other clients, and configuring user access and security. This manual is written in Chinese.
What's inside
- Quick Start
- Create and Manage Tables
- Import Data
- Connect and Use the Database
- Add Users and Permissions
- Database Overview
Specifications
| ECU minimum quantity | 2 (must be even) |
|---|
| ECU definition | Elastic Compute Unit with various vCPU, memory, and disk sizes |
|---|
| Connection port | 3003 |
|---|
| Supported client protocols | 5.1.x, 5.4.x, 5.6.x |
|---|
| Maximum hash partitions per table | 256 |
Frequently asked questions
How do I enable Alibaba Cloud ADS service?
In the public cloud, eligible users can activate the service by visiting https://buy.aliyun.com/ads and purchasing a pay‑as‑you‑go or subscription plan.
How do I connect to ADS from Java?
Use the JDBC URL provided in the console, e.g., jdbc:mysql://mydbname-xxxx.ads-hz.aliyuncs.com:3003/my_ads_db, with your Access Key ID and Secret as username and password.
How can I check the ADS service status?
Run the heartbeat SQL statement `show status like "%Service_Status%"`; a result row with a second column value of 1 indicates the service is normal.