Cloud Database Tenant Migration for Shared-Dedicated Rebalancing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Cloud database instances often face issues of underutilization or overutilization of computing resources, leading to inefficiencies and increased costs, as organizations may reserve more resources than needed or fail to allocate resources optimally, impacting productivity and operational efficiency.
Innovation Solution
A system that monitors operational data of cloud database instances and migrates underutilized dedicated instances to shared instances, releasing resources, and migrates overutilized shared instances to dedicated instances, optimizing resource allocation through automatic threshold-based decisions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If dedicated cloud database instances are reserved for organizations, then reliability and performance isolation are improved, but resource utilization deteriorates due to underutilization
Solution Approach 1:
The system dynamically monitors resource utilization metrics of dedicated database instances and automatically migrates tenants between dedicated and shared instances based on real-time conditions. This dynamic adjustment allows the system to maintain performance isolation when needed while maximizing resource utilization during low-demand periods, resolving the contradiction between reliability and resource efficiency.
Solution Approach 2:
The system changes the operational parameters of database instances by transitioning tenants between different instance types (dedicated to shared or vice versa) based on utilization thresholds. This parameter change enables the system to adapt resource allocation to actual demand, improving both performance isolation and resource utilization at different times.
2Productivity
If cloud database instances are migrated to optimize resource allocation, then resource utilization is improved, but system complexity increases due to automated monitoring and migration mechanisms
Solution Approach 1:
The system implements self-service automation where the database management system automatically monitors its own resource utilization, makes migration decisions based on predefined thresholds, and executes migrations without manual intervention. This self-service approach improves resource allocation efficiency while managing system complexity through automated decision-making rather than human management.
Solution Approach 2:
The system continuously monitors resource utilization metrics and uses this feedback to automatically trigger migration operations when thresholds are exceeded. This closed-loop feedback mechanism optimizes resource allocation dynamically while keeping the system manageable through rule-based automation rather than complex manual processes.
3Loss of energy
If shared cloud database instances are used to maximize resource utilization, then resource efficiency is improved, but performance and reliability deteriorate due to resource contention
Solution Approach 1:
The system dynamically adjusts the sharing level of database instances by automatically migrating tenants between shared and dedicated instances based on real-time resource utilization monitoring. When shared instances show signs of resource contention, the system automatically migrates affected tenants to dedicated instances, maintaining performance consistency while maximizing resource efficiency during low-contention periods.
Data Source
Figure 1
Figure 2
Figure 3A
AI summary
The present disclosure provides techniques and solutions for more efficiently managing computing resources used for cloud database instances. Operational data for shared cloud database instances and dedicated database instances can be monitored, including on a continuous basis. The operational data can be compared with one or more thresholds. If the operational data indicates that an entity assigned to a dedicated cloud database instance is underutilizing its assigned resources, it can be migrated to become a tenant of a shared cloud database instance. If the resources of a shared cloud database instance are overutilized, a tenant can be migrated to a dedicated cloud database instance. Migration can include copying data from the original cloud database instance to a migration target cloud database instance. After migration, computing resources can be released that were assigned to the dedicated cloud database instance or to a particular tenant of the shared cloud database instance.