{"id":105469,"date":"2010-09-12T00:00:00","date_gmt":"2010-09-12T00:00:00","guid":{"rendered":"https:\/\/www.deberes.net\/tesis\/sin-categoria\/high-performance-and-high-available-database-replication\/"},"modified":"2010-09-12T00:00:00","modified_gmt":"2010-09-12T00:00:00","slug":"high-performance-and-high-available-database-replication","status":"publish","type":"post","link":"https:\/\/www.deberes.net\/tesis\/bases-de-datos\/high-performance-and-high-available-database-replication\/","title":{"rendered":"High performance and high available database replication"},"content":{"rendered":"

Tesis doctoral de Dami\u00e1n Serrano Garc\u00eda <\/strong><\/h2>\n

Information systems have evolved from small servers to complex architectures that enable these systems to operate most of the time as possible (high availability) and provide service to a number of customers that increases everyday (scalability). That is translated into offering a 24×7 service (24 hours a day, 7 days a week). databases are a widely used solution for efficient data storage. However, a database by itself does not provide high availability since it is a single point of failure. Database replication provides high availability. Having more than one data copies (replicas) at different nodes, if one or more nodes fail, the rest continue offering the service. Moreover, a replicated database can provide also scalability if it can exploit the processing capacity of all nodes. This ph.D. Thesis focuses on high performance and high available replicated databases. traditional solutions to database replication deal with full replication (each node stores a copy of all data). Full replication offers limited scalability, even from a theoretical point of view [jpak03]. the limits come from maintaining consistency between replicas. That is, when a data is modified, it must be done in all its replicas. This thesis has made a theoretical study of the potential scalability of partially replicated databases, where each node stores only part of the data and compares it against the scalability of full replication. It has been been also proposed, implemented and empirically evaluated different partial replication protocols. using partial replication it might happen that given a query, there could be no node able to execute it since the query accesses data that is not stored together. If that happens, the query is executed in multiple nodes and the execution time is increased because nodes executing it need to exchange messages. This thesis proposes the use of optimization techniques to reduce the message exchange ratio. Specifically, it presents, implements and evaluates an autonomic reconfiguration mechanism that determines the data distribution minimizing the query execution across multiple nodes. finally, this thesis proposes and evaluates a recovery protocol [bhg87] for partially replicated databases that allows to reincorporate failed nodes. Traditionally, recovery implies to stop the system in order to transfer data to the node that rejoins the system. This inactivity period does not fulfills the requirements of high availability. Therefore, this thesis has proposes an online recovery protocol, i.E., without stopping the replicated database.<\/p>\n

 <\/p>\n

Datos acad\u00e9micos de la tesis doctoral \u00abHigh performance and high available database replication<\/strong>\u00ab<\/h3>\n
    \n
  • T\u00edtulo de la tesis:<\/strong>\u00a0 High performance and high available database replication <\/li>\n
  • Autor:<\/strong>\u00a0 Dami\u00e1n Serrano Garc\u00eda <\/li>\n
  • Universidad:<\/strong>\u00a0 Polit\u00e9cnica de Madrid<\/li>\n
  • Fecha de lectura de la tesis:<\/strong>\u00a0 09\/12\/2010<\/li>\n<\/ul>\n

     <\/p>\n

    Direcci\u00f3n y tribunal<\/h3>\n
      \n
    • Director de la tesis<\/strong>\n
        \n
      • Marta Pati\u00f1o Mart\u00ednez<\/li>\n<\/ul>\n<\/li>\n
      • Tribunal<\/strong>\n
          \n
        • Presidente del tribunal: sergio Ar\u00e9valo vi\u00f1uales <\/li>\n
        • Francisco daniel Mu\u00f1oz escoi (vocal)<\/li>\n
        • mikel Larrea alava (vocal)<\/li>\n
        • sara Bouchenak (vocal)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

           <\/p>\n","protected":false},"excerpt":{"rendered":"

          Tesis doctoral de Dami\u00e1n Serrano Garc\u00eda Information systems have evolved from small servers to complex architectures that enable these systems […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[6314,13880,16008],"tags":[212700,40248,57073,121135,192681,31238],"class_list":["post-105469","post","type-post","status-publish","format-standard","hentry","category-bases-de-datos","category-informatica","category-politecnica-de-madrid","tag-damian-serrano-garcia","tag-francisco-daniel-munoz-escoi","tag-marta-patino-Martinez","tag-mikel-larrea-alava","tag-sara-bouchenak","tag-sergio-arevalo-vinuales"],"_links":{"self":[{"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/posts\/105469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/comments?post=105469"}],"version-history":[{"count":0,"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/posts\/105469\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/media?parent=105469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/categories?post=105469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.deberes.net\/tesis\/wp-json\/wp\/v2\/tags?post=105469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}