Solution Overview

Application Scenarios

Based on Cloud Search Service (CSS), this solution synchronizes MySQL data to CSS in real time. CSS provides stable, low-latency, high-concurrency, and scalable query performance, as well as excellent multi-dimensional query analysis and full-text search capabilities. This solution is applicable to operation departments of e-commerce and logistics to query and analyze offering orders and logistics information from multiple dimensions.

Solution Architecture

This solution helps you deploy the CSS-based SQL acceleration solution with just a few clicks and quickly complete basic configurations for Relational Database Service (RDS), Data Replication Service (DRS), and CSS.

To use this solution, you need to:

Create an RDS for MySQL or GaussDB(for MySQL) database to store your service data.
Synchronize RDS data to CSS in real time.
Create a CSS cluster. CSS is a fully hosted, distributed search service powered by open-source Elasticsearch. It provides high-concurrency and low-latency query and analysis capabilities.

Advantages

Ease of use
This solution is out-of-the-box. You can use DRS to synchronize data in real time without coding or data synchronization tasks.
High performance
With the industry-leading vector retrieval engine and composite index capability of CSS, this solution can support full-text retrieval and random multi-dimensional analysis in ad-hoc scenarios.
Capability expansion
CSS improves database concurrency, scale-out capability, and complex query (full-text search, fuzzy search, and random multi-dimensional analysis) satisfaction.