For some enterprise customers, the coexistence of commercial databases, open source databases, and information innovation databases has become the new normal. With the increase in the variety of databases and the scale of deployment, the complexity of management is rising dramatically, which seriously challenges the technical capabilities of enterprises. Faced with the unified management requirements of existing databases and incremental databases, Ape Data has launched a heterogeneous database management solution to help enterprises reduce O&M pressure and reduce the risk of failure.
The data center department of joint-stock banks and securities companies
The size of the database
Hundreds of database instances
Technical team
Within 10 people, the division of labor is extremely clear (DBA)
Business characteristics
The business is cyclical and the availability requirements are high
Business support centers for China Telecom, China Mobile, and China Unicom
The size of the database
Hundreds of database instances
Technical team
Within 10 people, the professional division of labor is relatively clear (SRE)
Business characteristics
The user base is huge, and the amount of data is high
Information departments of governments and institutions at all levels
The size of the database
Dozens of database instances
Technical team
Within 5 people, the professional division of labor is relatively vague (there are part-time R&D jobs)
Business characteristics
The requirements for data security are high, and the requirements for information innovation are strong
The science and technology departments of large enterprises such as energy, manufacturing, transportation, etc
The size of the database
Thousands of database instances
Technical team
Dozens of people, the professional division of labor is relatively vague (there are part-time R&D jobs)
Business characteristics
The business is complex and deployed in multiple locations
To solve the problem of database operation and maintenance control, there are generally the following technical solutions
Enterprises can purchase man-days to meet their database O&M requirements. The services include architecture consulting, data backup, performance tuning, data migration, system inspection, etc. For domestic database products, enterprises generally purchase remote services or on-site services from the original factory; For overseas business databases, enterprises usually purchase third-party services.
Enterprises purchase O&M management tools provided by database vendors. In general, the original tool supports only one type of database product, and has complete database deployment, backup and restoration, monitoring and alarming, database and table management, performance optimization, data migration, daily inspection, and other functions.
The company independently develops a database operation and maintenance management system. Self-developed systems generally support a variety of database products, with database management, cluster inspection, link monitoring, SQL audit, cross-cluster synchronization and other capabilities, and integrate various internal systems to meet the needs of personalized management.
Enterprises purchase database O&M management products that are not provided by the original database manufacturer. Such products generally support a variety of database products, and usually focus on standardized function implementation and intelligent user experience.
Procurement of database O&M services | Purchase database original factory O&M management tools | Self-developed database O&M management system | Purchase third-party database management software | ||
Core Requirements | Database type | 中 A small number of databases do not buy services | 弱 Generally, only one type of database is supported | 强 Generally, multiple databases are supported, but niche databases are not included | 强 Generally, multiple databases are supported, even niche databases are included |
O&M functions | 弱 Many functions can't be done manually; Scripts lack R&D process validation | 强 In-depth support for original factory databases | 中 It can cover basic lifecycle management, backup and restoration, and monitoring and alarm functions | 中 It can cover basic lifecycle management, backup and restoration, monitoring and alarm functions, and some vendors provide complex batch O&M capabilities | |
Adaptation integration | -- | 弱 Generally, only monitoring-related APIs are provided | 强 Deep integration | 中 A large number of standard API interfaces are provided | |
Technical route | Technologically forward-looking | -- | 弱 Widespread adoption of outdated technology stacks | 中 Widespread adoption of a mature technology stack | 强 Prevalent adoption of mature or innovative technology stacks |
O&M costs | Procurement (development) costs | -- | 低 Most of the cost is included in the kernel license and is reflected in the case of gifts | 高 Retain a larger system development and testing team | 中 Retain a smaller system R&D and testing team |
O&M costs | 高 There are no system operation and maintenance costs, and you need to pay a high cost for manual services | 高 There are no system operation and maintenance costs, and you need to pay a high cost for manual services | 中 There are system operation and maintenance costs, and there is a need to support lower costs for manual services | 低 There are no system operation and maintenance costs, and there is a need to support lower costs for manual services |
The unified management solution of cloud ape data heterogeneous database supports mainstream databases such as Oracle, SQL Server, MySQL, PostgreSQL, MongoDB, Redis, Dameng, Jincang, and OceanBase, which can detect database hidden dangers in advance, quickly locate problems and accurate root causes, and provide optimization suggestions to help users quickly solve faults and performance bottlenecks. In the future, this solution will support more types of databases and provide core functions such as automatic deployment, monitoring and alarming, backup and restoration, and auto scaling.
Supports multiple database types, such as Oracle, SQL Server, MySQL, PostgreSQL, MongoDB, Redis, Dameng, Jincang, and OceanBase, to achieve unified monitoring, O&M, and management of multiple engines, greatly reducing O&M workload.
It not only supports the management of the existing database deployed by the user, but also supports the incremental database cluster to meet all the business needs of the user for the database and realize the integrated management of the stock and incremental clusters.
Intuitively display the correspondence between user and database permissions, so that administrators can quickly understand each user's access and operation permissions to database resources, discover potential security risks in a timely manner, improve management efficiency, and reduce risks such as data leakage or misoperation caused by improper permission configuration.
In-depth database kernel function collection capabilities, which can quickly locate database performance problems in one minute; Accurate mathematical models replace the traditional SQL execution plan analysis experience, which greatly reduces the threshold for database performance analysis. Automatically provide optimization suggestions and recommend the optimal index within one minute, quickly solve database problems and improve business stability.
Integrate the user privatization model and provide intelligent O&M assistant to implement intelligent O&M, diagnosis, analysis, and database visualization of database clusters, simplifying O&M work and improving O&M efficiency.
20+ database support Unified management of multiple engines
| 1 minute problem location AI-powered O&M
| Full lifecycle management Integration of unified management and management
|
