AnalyticDB for MySQL: Real-time Data Warehouse for Petabytes of Data - Alibaba Cloud (original) (raw)
AnalyticDB for MySQL is a high-performance data warehousing service that is secure, stable, and easy to use. It allows you to easily create online statistical reports, multidimensional analysis solutions, and real-time data warehouses. AnalyticDB for MySQL uses a distributed computing architecture that enables it to use the elastic scaling capability of the cloud to compute tens of billions of data records in real time. AnalyticDB for MySQL stores data based on relational models and can use SQL to flexibly compute and analyze data. AnalyticDB for MySQL also allows you to easily manage databases, scale in or out nodes, and scale up or down instances. It provides various visualization and ETL tools to make enterprise data processing easier.
Benefits
Features
Flexible Computing
Capable of computing large amounts of data, allowing you to flexibly explore data and quickly discover data value.
No Prior Data Modeling Required
Provides comprehensive value indexing and block indexing technologies, allowing you to query data without any prior data modeling.
Fast Response
Uses an ultra-large scale engine that integrates MPP with directed acyclic graphs (DAGs), allowing you to query large amounts of data within milliseconds.
Ease of Use
Compatible with MySQL databases. AnalyticDB for MySQL is easy to learn and use.
Compatibility with MySQL
Fully compatible with the MySQL protocol and SQL:2003 syntax. AnalyticDB for MySQL can easily analyze and integrate data by using standard SQL syntax and existing BI tools.
Ease-of-use Assurance
Provides an intuitive graphical management console as well as complete documentation and manuals. The computing engine intelligently optimizes queries.
Availability Assurance
Isolates storage from computing resources, and supports multi-copy data storage and dynamic resource management for always-on connectivity.
High-availability Architecture
Uses a distributed architecture that provides high availability and low latency and can handle high-concurrency queries.
Secure Design
Provides column-level permission management and uses a public/private key mechanism to secure data.
Unique Features
Provides many unique features to help you analyze data more efficiently.
High-performance Automatic Indexing
Automatically creates the most suitable index format for each data column, allowing you to focus on more important work.
Data Migration
Supports multiple data migration tools and solutions, allowing you to quickly import and export data.
Support for Real-time Data Operations
Supports high-concurrency real-time data insert, update, and delete operations.
Intelligent Query Optimization with CBO and HBO
Implements intelligent scheduling of computing resources among distributed clusters.
Multi-version Hybrid Row-Column Storage
Allows you to write and query millions of records in real time.
Use Cases
Gain Business Insights: Build Data Warehouse With Ease & Reduce Costs By Data Tiering
AnalyticDB offers intelligent tiered storage solution for hot and cold data, enabling seamless data tiering without requiring changes to your business logic.
This feature is specifically designed for tables partitioned by date and time. Once activated, each data partition follows its customizable lifecycle:
- Hot data (recently ingested) is stored on high-performance SSDs to deliver lightning-fast query responses.
- Cold data (older or less frequently accessed) is automatically identified as cold data and archived to cost-effective Object Storage Service (OSS), thereby significantly reducing storage expenses.
Data tiering in AnalyticDB for MySQL >
Data tiering in AnalyticDB for PostgreSQL >
Watch the video to discover the transformative power of data tiering in action.
AnalyticDB for MySQL Query Performance Tuning Guide
Beginning with an introduction to the features of AnalyticDB for MySQL V3.0, this document describes the tuning principles of SQL development, common tuning problems, tools provided by AnalyticDB for MySQL for query execution plans optimization , etc., which gives you an impressive MySQL query performance tuning practice.
Setting up Database Performance Benchmarking on Alibaba Cloud
This document gives you a guidance to implement database performance tests based on commonly used benchmarks, including the Transaction Processing Performance Council (TPC) and sysbench benchmarks.
Scenarios
Real-time Data Warehousing
Real-time Computing Service
Real-time Data Warehousing
Real-time Data Warehousing
Enterprise-level Online Data Warehouse Construction
AnalyticDB for MySQL provides real-time computing statistics of business metrics, and uses data visualization tools to display business trends in real time, such as real-time statistics of transaction orders and monitoring of the running status of vehicles and devices.
Challenges that AnalyticDB for MySQL can Address
- Dynamic Monitoring of the Business Dashboard
AnalyticDB for MySQL can be used to monitor the real-time status of business operations throughout the country. For example, a clothing chain manufacturer uses the fast computing capability of AnalyticDB for MySQL to monitor the sales orders of 1,500 stores in China in real time. - Real-time Interactive Query
An interactive query and analysis platform is built based on AnalyticDB for MySQL. You can select various query conditions from the platform to explore and analyze data.
Real-time Computing Service
Real-time Computing Service
Online Data Service Applications
AnalyticDB for MySQL is used to build a real-time computing business system to overcome problems of traditional databases, such as inability to perform quick multi-table join queries on large amounts of data.
Challenges that AnalyticDB for MySQL can Address
- Multi-table Join Queries
AnalyticDB for MySQL can perform join queries on multiple large tables and is ideal for complex data service scenarios such as real-time route planning and profile analysis. - Highly Concurrent Write Operations
AnalyticDB for MySQL can perform highly concurrent write operations on large amounts of data and is suitable for building data systems that require writing large amounts of data.
Rely on Alibaba Cloud's Worldwide Data Centers
Alibaba Cloud has 87 zones strategically located across 29 regions in the world, providing reliable computing support for billions of customers.
No.1
Market Share in the Asia Pacific
IaaS Market Share - Gartner IT Service Report 2022
29
Global Data Center regions
3,200 +
CDN Nodes Globally
87
Availability Zones
Data centers and availability zones
Upgraded Support For You
1 on 1 Presale Consultation, 24/7 Technical Support, Faster Response, and More Free Tickets.
1 on 1 Presale Consultation
Consulting by experienced cloud experts.Learn More
24/7 Technical Support
Extended service time from 10 hours 5 days a week to 24/7. Learn More
6 Free Tickets per Quarter
The number of free tickets doubled from 3 to 6 per quarter. Learn More
Faster Response
Shorten after-sale response time from 36 hours to 18 hours. Learn More