Updated on 2023-04-25 GMT+08:00

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.

Constraints

  • Before deploying this solution, you have registered an account with access to the target region.