{"id":2276,"date":"2007-05-29T08:48:24","date_gmt":"2007-05-29T07:48:24","guid":{"rendered":"https:\/\/www.fullo.net\/blog\/archives\/2007\/05\/29\/hyperdb\/"},"modified":"2007-05-29T08:48:24","modified_gmt":"2007-05-29T07:48:24","slug":"hyperdb","status":"publish","type":"post","link":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/","title":{"rendered":"HyperDB"},"content":{"rendered":"<p><a href=\"http:\/\/photomatt.net\/2007\/05\/28\/announcing-hyperdb\/\">Matt<\/a> ha aperto una <a href=\"http:\/\/lists.automattic.com\/mailman\/listinfo\/hyperdb\">mailing list<\/a> dove verr\u00e0 discusso HyperDB, il layer DB usato da WordPress.com, e che \u00e8 studiato per garantire massime performance per blog con migliaia di accessi contemporanei.<\/p>\n<p>Attualmente la classe, non ancora rilasciata pubblicamente, supporta:<\/p>\n<ul>\n<li>Replicazione dei dati<\/li>\n<li>Failover<\/li>\n<li>Ridondanza<\/li>\n<li>Gestione di datacenter locali e remoti<\/li>\n<li>Partizionamento dei DB<\/li>\n<li>Utilizzo di tabelle su differenti DB<\/li>\n<li>Profiling e statistiche utilizzo<\/li>\n<li>etc&#8230;<\/li>\n<\/ul>\n<p>Personalmente aspettavo una mossa simile, la vecchia classe <code>wpdb<\/code> non \u00e8 molto ottimizzata ed in alcuni blog si sente pesantemente l&#8217;utilizzo intensivo del DB (soprattutto per quelli ospitati su Aruba dove ci sono delle limitazioni di query\/sec)<\/p>\n<p>ciuaz<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Matt ha aperto una mailing list dove verr\u00e0 discusso HyperDB, il layer DB usato da WordPress.com, e che \u00e8 studiato per garantire massime performance per blog con migliaia di accessi contemporanei. Attualmente la classe, non ancora rilasciata pubblicamente, supporta: Replicazione dei dati Failover Ridondanza Gestione di datacenter locali e remoti Partizionamento dei DB Utilizzo di [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[13,9],"tags":[678,190,679,93],"class_list":["post-2276","post","type-post","status-publish","format-standard","hentry","category-open-source","category-php","tag-db","tag-mysql","tag-sql","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>HyperDB - Fullo<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"HyperDB - Fullo\" \/>\n<meta property=\"og:description\" content=\"Matt ha aperto una mailing list dove verr\u00e0 discusso HyperDB, il layer DB usato da WordPress.com, e che \u00e8 studiato per garantire massime performance per blog con migliaia di accessi contemporanei. Attualmente la classe, non ancora rilasciata pubblicamente, supporta: Replicazione dei dati Failover Ridondanza Gestione di datacenter locali e remoti Partizionamento dei DB Utilizzo di [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/\" \/>\n<meta property=\"og:site_name\" content=\"Fullo\" \/>\n<meta property=\"article:published_time\" content=\"2007-05-29T07:48:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2021\/05\/FB_IMG_1515748807284.jpg?fit=1453%2C1453&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1453\" \/>\n\t<meta property=\"og:image:height\" content=\"1453\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Francesco Fullone\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fullo\" \/>\n<meta name=\"twitter:site\" content=\"@fullo\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Francesco Fullone\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/\"},\"author\":{\"name\":\"Francesco Fullone\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"headline\":\"HyperDB\",\"datePublished\":\"2007-05-29T07:48:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/\"},\"wordCount\":103,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"keywords\":[\"db\",\"mysql\",\"sql\",\"wordpress\"],\"articleSection\":[\"open source\",\"php\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/\",\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/\",\"name\":\"HyperDB - Fullo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#website\"},\"datePublished\":\"2007-05-29T07:48:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2007\\\/05\\\/29\\\/hyperdb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"HyperDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/\",\"name\":\"Fullo\",\"description\":\"nulla e&#039; impossibile per chi non lo deve fare!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\",\"name\":\"Francesco Fullone\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"width\":622,\"height\":622,\"caption\":\"Francesco Fullone\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\"},\"sameAs\":[\"http:\\\/\\\/www.fullo.net\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/fullo\",\"https:\\\/\\\/x.com\\\/fullo\"],\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/author\\\/fullo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"HyperDB - Fullo","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/","og_locale":"it_IT","og_type":"article","og_title":"HyperDB - Fullo","og_description":"Matt ha aperto una mailing list dove verr\u00e0 discusso HyperDB, il layer DB usato da WordPress.com, e che \u00e8 studiato per garantire massime performance per blog con migliaia di accessi contemporanei. Attualmente la classe, non ancora rilasciata pubblicamente, supporta: Replicazione dei dati Failover Ridondanza Gestione di datacenter locali e remoti Partizionamento dei DB Utilizzo di [&hellip;]","og_url":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/","og_site_name":"Fullo","article_published_time":"2007-05-29T07:48:24+00:00","og_image":[{"width":1453,"height":1453,"url":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2021\/05\/FB_IMG_1515748807284.jpg?fit=1453%2C1453&ssl=1","type":"image\/jpeg"}],"author":"Francesco Fullone","twitter_card":"summary_large_image","twitter_creator":"@fullo","twitter_site":"@fullo","twitter_misc":{"Scritto da":"Francesco Fullone","Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/#article","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/"},"author":{"name":"Francesco Fullone","@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"headline":"HyperDB","datePublished":"2007-05-29T07:48:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/"},"wordCount":103,"commentCount":3,"publisher":{"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"keywords":["db","mysql","sql","wordpress"],"articleSection":["open source","php"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/","url":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/","name":"HyperDB - Fullo","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/#website"},"datePublished":"2007-05-29T07:48:24+00:00","breadcrumb":{"@id":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fullo.net\/blog\/2007\/05\/29\/hyperdb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fullo.net\/blog\/"},{"@type":"ListItem","position":2,"name":"HyperDB"}]},{"@type":"WebSite","@id":"https:\/\/www.fullo.net\/blog\/#website","url":"https:\/\/www.fullo.net\/blog\/","name":"Fullo","description":"nulla e&#039; impossibile per chi non lo deve fare!","publisher":{"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fullo.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c","name":"Francesco Fullone","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","url":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","width":622,"height":622,"caption":"Francesco Fullone"},"logo":{"@id":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1"},"sameAs":["http:\/\/www.fullo.net","https:\/\/www.linkedin.com\/in\/fullo","https:\/\/x.com\/fullo"],"url":"https:\/\/www.fullo.net\/blog\/author\/fullo\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s3OSc1-hyperdb","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1676,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/03\/gestire-db-con-i-dataobject\/","url_meta":{"origin":2276,"position":0},"title":"Gestire DB con i DataObject","author":"Francesco Fullone","date":"03\/10\/2005","format":false,"excerpt":"Interessante questo articolo su phpRiot su come utilizzare una classe dataobject generica (e non quella di PEAR) per la gestione dei propri db. Nell'articolo vengono evidenziate passo passo tutte le possibili casistiche di utilizzo e ne viene realizzato il codice. ciuaz","rel":"","context":"In &quot;php&quot;","block_context":{"text":"php","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":310,"url":"https:\/\/www.fullo.net\/blog\/2003\/06\/26\/phplinksdaogen\/","url_meta":{"origin":2276,"position":1},"title":"php::Links(&#8216;daoGen&#8217;)","author":"Francesco Fullone","date":"26\/06\/2003","format":false,"excerpt":"Creare classi per la gestione di database non \u00e8 mai stato pi\u00f9 facile! Grazie a daoGen sar\u00e0 possibile creare e gestire un db in maniera semplice ed efficiente. Lo script, una volta immesse le specifiche del db ci creer\u00e0 4 file: il primo contentente la struttura SQL-compliant delle nostre tabelle,\u2026","rel":"","context":"In &quot;tecnologia&quot;","block_context":{"text":"tecnologia","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1875,"url":"https:\/\/www.fullo.net\/blog\/2006\/02\/16\/oracle-ha-comprato-il-berkeley-db\/","url_meta":{"origin":2276,"position":2},"title":"Oracle ha comprato il Berkeley DB","author":"Francesco Fullone","date":"16\/02\/2006","format":false,"excerpt":"Come avevo scritto qualche giorno fa Oracle \u00e8 affamata di nuove aquisizioni e per confermare la cosa ha comprato SleepyCat. Molti magari non sapranno neanche di chi si tratta ma se proviamo a citare il nome del suo prodotto pi\u00f9 famoso il BerkeleyDB direi che i pi\u00f9 sgraneranno gli occhi.\u2026","rel":"","context":"In &quot;open source&quot;","block_context":{"text":"open source","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/open-source\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1911,"url":"https:\/\/www.fullo.net\/blog\/2006\/04\/03\/slimstat-statistiche-per-wordpress\/","url_meta":{"origin":2276,"position":3},"title":"SlimStat, statistiche per WordPress","author":"Francesco Fullone","date":"03\/04\/2006","format":false,"excerpt":"Finalmente ho trovato un degno successore a ShortStats per Wordpress, ed \u00e8 tutto italiano! Si tratta dell'ottimo SlimStats. Questo plugin permette di importare il vecchio db di shortstats e di gestirlo a pieno. Le features del plugin sono pi\u00f9 o meno le stesse di quelle del suo \"genitore\" inoltre \u00e8\u2026","rel":"","context":"In &quot;php&quot;","block_context":{"text":"php","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2206,"url":"https:\/\/www.fullo.net\/blog\/2007\/02\/05\/php-e-paradox\/","url_meta":{"origin":2276,"position":4},"title":"PHP e Paradox","author":"Francesco Fullone","date":"05\/02\/2007","format":false,"excerpt":"I lavori pi\u00f9 strambi sono anche i pi\u00f9 divertenti, oggi ho recuperato un DB paradox di una decina di anni fa usando PHP, la PECL di Paradox ed una libreria ad hoc per linux. A seguire il piccolo tutorial per accedere ad un db Paradox. Piccola premessa, tutti i test\u2026","rel":"","context":"In &quot;php&quot;","block_context":{"text":"php","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1680,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/05\/sql-designer\/","url_meta":{"origin":2276,"position":5},"title":"SQL Designer","author":"Francesco Fullone","date":"05\/10\/2005","format":false,"excerpt":"SQL Designer \u00e8 un'applicazione ajax enabled che serve a disegnare schemi ER. Con questo script \u00e8 possibile creare nuove tabelle, foreign key, aggiungere e rimuovere campi dalle tabelle come se nulla fosse e con un'interfaccia grafica pulita e molto semplice da usare. Inoltre le relazioni sono controllate e se viene\u2026","rel":"","context":"In &quot;ajax&quot;","block_context":{"text":"ajax","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/ajax\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/2276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/comments?post=2276"}],"version-history":[{"count":0,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/2276\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/media?parent=2276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/categories?post=2276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/tags?post=2276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}