Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Service level agreement-aware migration for multitenant database platforms

a database platform and multi-tenant technology, applied in the field of database migration, can solve the problems of tenant data copying to another machine, migration incurs its own cost, and sla violations, and achieves the effect of direct cost of copying tenant data to another machin

Inactive Publication Date: 2013-04-04
NEC LAB AMERICA
View PDF4 Cites 91 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

The patent describes a method for migrating data from a multi-tenant database to another database. The method involves building an analytical model for each migration method based on the database characteristics, predicting the performance of the migration methods based on the model, and selecting the best migration method based on the predicted migration speeds and service level agreement violation severity. The technical effect of this method is to optimize migration speed and minimize service level agreement violations, resulting in a more efficient and reliable migration process.

Problems solved by technology

If a tenant's resource demands exceed the free capacity on a given server, other tenants on the server may be negatively impacted, causing SLA violations.
Migration incurs its own costs, however.
There is a direct cost of copying the tenant's data to another machine, as well as penalties due to SLA violations during system downtime and human-related costs.
Such a solution is not practical for migrating large amounts of data, where large downtimes will be incurred.
Existing live migration solutions for database systems fail to take into account the costs that such a migration may cause to a provider.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Service level agreement-aware migration for multitenant database platforms
  • Service level agreement-aware migration for multitenant database platforms
  • Service level agreement-aware migration for multitenant database platforms

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021]A practical migration solution for multitenant database systems according to the present principles includes a minimum of downtime, controlled tenant interference, and automatic management. To achieve this, the present principles employ backup tools to perform a zero-downtime live backup of a database. Further more, “migration slack” is employed, referring to resources which can be used for migration without seriously impacting existing workloads. By taking query latency into account and monitoring system performance in real-time, system performance can be guaranteed according to tenant service level agreements (SLAs) even during the live migration.

[0022]The present principles achieve live migration by using existing hot backup functionality present in database systems. Because most contemporary database systems have such hot backup functions, the present principles may be employed without changes to existing database engines and operating systems. Within the bounds of SLA gua...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

A method for migration from a multitenant database is shown that includes building an analytical model for each of a set of migration methods based on database characteristics; predicting performance of the set of migration methods using the respective analytical model with respect to tenant service level agreements (SLAs) and current and predicted tenant workloads, where the prediction includes a migration speed and an SLA violation severity; and selecting a best migration method from the set of migration methods according to the respective predicted migration speeds and SLA violation severities.

Description

RELATED APPLICATION INFORMATION[0001]This application claims priority to provisional application Ser. No. 61 / 542,994 filed on Oct. 4, 2011, incorporated herein by reference. This application further claims priority to provisional application Ser. No. 61 / 543,012 filed on Oct. 4, 2011, incorporated herein by reference.[0002]This application is related to application serial no. TBD, Attorney Docket Number 11047B (449-254) entitled “LATENCY-AWARE LIVE MIGRATION FOR MULTITENANT DATABASE PLATFORMS,” filed concurrently herewith and incorporated herein by reference.BACKGROUND[0003]1. Technical Field[0004]The present invention relates to database migration and, in particular, to the migration of multitenant database platforms in such a way as to preserve tenant service level agreements.[0005]2. Description of the Related Art[0006]Modern cloud platforms are designed with the aim of compactly servicing many users on a large number of machines. To increase resource utilization in the presence o...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F9/455
CPCG06F9/5088G06F17/303G06F9/455G06F16/214
Inventor BARKER, SEANCHI, YUNMOON, HYUN JINHACIGUMUS, VAHIT HAKAN
Owner NEC LAB AMERICA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com