{"id":2265,"date":"2012-02-05T06:25:32","date_gmt":"2012-02-05T11:25:32","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2265"},"modified":"2012-02-05T06:30:47","modified_gmt":"2012-02-05T11:30:47","slug":"mysql-cluster-by-ralf-gebhardt","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-cluster-by-ralf-gebhardt","title":{"rendered":"MySQL Cluster by Ralf Gebhardt"},"content":{"rendered":"<p>Ralf Gebhardt of <a href=\"http:\/\/www.skysql.com\/\">SkySQL<\/a>.<\/p>\n<p>Cluster: shared nothing architecture (no single point of failure), synchronous replication between nodes, ACID transactions, row level locking. In-memory storage (some data can be stored on disk, but indexes must be in-memory). Checkpointing to disk for durability. It supports two types of indexes &#8211; ordered T-trees, unique hash indexes. Online operations like adding node groups, software upgrades, table alterations. Quick standard architecture diagram displayed about MySQL Cluster.<\/p>\n<p>Network partitioning protocol is designed to avoid a split brain scenario. Is there at least one node from each node group? If not then this part cannot continue &#8211; graceful shutdown. Are all nodes present from any node group? If so, then this is the only viable cluster &#8211; continue to operate. Ask the arbitrator &#8211; the arbitrator which parts will continue if no arbitrator is available the cluster shuts down.<\/p>\n<p>Durability &#8211; in order for a node to recover fast some data is stored locally. The REDO log is synchronized by global checkpoints (GCP). The DataMemory is synchronized by local checkpoints (LCP).<\/p>\n<p>I agree with Ralf &#8212; almost impossible to talk about NDB in 25 minutes. Its very deep, you&#8217;d need at least three hours to grasp it well.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ralf Gebhardt of SkySQL. Cluster: shared nothing architecture (no single point of failure), synchronous replication between nodes, ACID transactions, row level locking. In-memory storage (some data can be stored on disk, but indexes must be in-memory). Checkpointing to disk for durability. It supports two types of indexes &#8211; ordered T-trees, unique hash indexes. Online operations [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","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":[23],"tags":[1332,115,113,1343,1344],"class_list":["post-2265","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-fosdem","tag-mysql-cluster","tag-ndb","tag-ndbcluster","tag-ralf-gebhardt"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Ax","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2265"}],"version-history":[{"count":4,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2265\/revisions"}],"predecessor-version":[{"id":2271,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2265\/revisions\/2271"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}