Selective Database Instance Migration for High Availability
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional database migration technologies create significant availability gaps during migration, affecting all databases even if only one requires migration, leading to increased downtime and reduced flexibility.
Innovation Solution
The system identifies and migrates user databases from one instance to another on an individual or service group basis, allowing for selective migration without affecting all databases, using modules to identify instances, user databases, and service groups, and performing steps like binding virtual network addresses and updating system databases.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional migration technologies are used to migrate databases, then database availability is maintained during migration, but significant availability gaps occur and all databases are affected even if only one requires migration
Solution Approach 1:
The patent segments the database migration process by instance rather than migrating all databases simultaneously. The system identifies and migrates only the specific instance containing the failed database, while other instances continue operating normally. This segmentation eliminates the availability gap that affects all databases in traditional migration approaches.
Solution Approach 2:
The patent extracts the migration operation from the entire database system and applies it only to the specific failed instance. By taking out the migration task from the global context and isolating it to the affected instance, the system maintains availability for all other databases while performing migration on the failed one.
2Reliability
If all databases are migrated to another instance, then high availability is provided, but unnecessary migrations occur for databases that do not require migration
Solution Approach 1:
The patent applies local quality by providing different treatment to different database instances based on their specific needs. The system identifies which instance contains the failed database and applies migration only to that specific instance, while leaving other instances unchanged. This targeted approach eliminates unnecessary migrations and improves overall migration efficiency.
Solution Approach 2:
The patent performs partial action by migrating only the necessary instance rather than all instances. The system identifies the specific instance requiring migration and performs the migration operation only on that instance, avoiding the excessive action of migrating all databases when only one is affected.
3Adaptability or versatility
If traditional migration is performed, then database migration is achieved, but flexibility is reduced due to affecting all databases
Solution Approach 1:
The patent segments the database system into multiple independent instances, allowing selective migration of individual instances. This segmentation provides flexibility to migrate only the affected instance without impacting others, enabling adaptable response to different failure scenarios while maintaining clear instance boundaries.
Data Source
AI summary
A computer-implemented method for providing high availability to instance-bound databases may include (1) identifying a first instance of a database server, the first instance hosting a plurality of databases, (2) identifying a second instance of the database server, (3) identifying at least one user database within the plurality of databases to fail over, and (4) migrating the user database to the second instance without migrating every database in the plurality of databases to the second instance. Various other methods, systems, and computer-readable media are also disclosed.