Introduction to Zhijia Cloud Multi-Database Management Platform (RDS)

The article briefly introduces the background of the Zhijia Cloud multi-database management platform, the types of databases currently supported, and the convenient services provided to users, followed by a roadmap for future development.

Business-driven technology continuously expands, making storage a crucial component; databases, as the veteran members of storage, are indispensable in daily work.

With the evolution of technology, various database types have emerged, such as relational databases (MySQL, SQL Server), NoSQL databases (MongoDB), and NewSQL databases (TiDB), each playing irreplaceable roles in specific scenarios.

Developers often face chaos when dealing with multiple databases: requesting resources, locating connection addresses, verifying data, retrieving slow logs, and monitoring resource usage. A unified database management platform becomes essential to streamline these tasks.

01. Zhijia Cloud Multi-Database Management Platform (RDS) Background

The platform aims to provide developers and operations staff with convenient, fast, comprehensive, and accurate database management, query, and monitoring services. It currently integrates MySQL, SQL Server, MongoDB, and TiDB, offering a one‑stop solution.

02. RDS Features

1) Management of database instances, schemas, tables, and accounts: creation, modification, and deletion are streamlined through self‑service workflows, supporting configuration of environments, resources, permissions, scheduled SQL, and sensitive data encryption. A “three‑in‑one” workflow allows simultaneous creation of instances, schemas, and tables.

2) Information Query: includes metadata queries (instance, schema, table, account details), business data queries (direct data retrieval without switching tools), and log queries (slow‑query logs for performance troubleshooting).

3) Monitoring and Alerts: default alert policies are attached to newly created instances, monitoring metrics such as connection count, with configurable alert levels and contacts, allowing users to view policy details and history.

4) Health Diagnosis: provides overall health scores, displays key metrics (connections, QPS, CPU, disk usage), and offers specific diagnostics per database type (session management, redundant index detection, table usage analysis, capacity management). A screenshot shows MySQL health score details.

03. Future Planning

RDS currently supports four databases representing different SQL directions; future work includes integrating additional databases, enabling cross‑database data migration (including metadata and business data), and exposing APIs for external systems to access unified metadata, preparing for comprehensive metadata management.

Author: Qian Lei, member of the Cloud Development Platform R&D team, responsible for middleware-related work.