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

[0010]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 serv...

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 ...

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 Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap