{"id":762,"date":"2006-11-22T22:57:02","date_gmt":"2006-11-22T12:57:02","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2006\/11\/22\/pluggable-ndb\/"},"modified":"2009-02-21T13:53:15","modified_gmt":"2009-02-21T03:53:15","slug":"pluggable-ndb","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2006\/11\/22\/pluggable-ndb\/","title":{"rendered":"pluggable NDB"},"content":{"rendered":"

Spoke with Brian<\/a> the other day on what was required to get NDB to be a pluggable engine – and started hacking.<\/p>\n

The tricky bits invole dependencies of things like mysqldump and ndb_restore on some headers to determine what tables shouldn’t be dumped (hint: the cluster database used for replication).<\/p>\n

Also, all those command line parameters and global variables – they’re fun too. It turns out InnoDB and PBXT are also waiting on this. In the meantime, I’ve done a hack that puts config options in a table.<\/p>\n

Currently blocked on getting the embedded server (libmysqld) to build properly – but i now have a sql\/mysqld binary with pluggable NDB. All libtool foo too.<\/p>\n

Hopefully i’ll be able to post soon with a “it works” post<\/p>\n","protected":false},"excerpt":{"rendered":"

Spoke with Brian the other day on what was required to get NDB to be a pluggable engine – and started hacking. The tricky bits invole dependencies of things like mysqldump and ndb_restore on some headers to determine what tables … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_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}},"categories":[1,14],"tags":[54],"class_list":["post-762","post","type-post","status-publish","format-standard","hentry","category-general","category-mysql","tag-ndb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-ci","jetpack-related-posts":[{"id":829,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/04\/27\/adding-a-pluggable-information-schema-table-to-a-pluggable-engine-in-mysql-51\/","url_meta":{"origin":762,"position":0},"title":"adding a pluggable information schema table to a pluggable engine in mysql 5.1","author":"Stewart Smith","date":"2007-04-27","format":false,"excerpt":"Also now up is the patch series in my \"ndb-work\" tree which small patch for adding INFORMATION_SCHEMA.NDB_NODE_STATUS. It's nearly useful... I haven't brought in the nice \"id to string\" functions in the management client that make pretty printing nice... so not quite end user friendly :) But it's a nice\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1650,"url":"https:\/\/www.flamingspork.com\/blog\/2009\/05\/27\/pluggable-metadata-stores-or-the-revenge-of-table-discovery\/","url_meta":{"origin":762,"position":1},"title":"Pluggable Metadata stores (or… the revenge of table discovery)","author":"Stewart Smith","date":"2009-05-27","format":false,"excerpt":"Users of the ARCHIVE or NDB storage engines in MySQL may be aware of a MySQL feature known as \"table discovery\". For ARCHIVE, you can copy the archive data file around between servers and it magically works (you don't need to copy the FRM). For MySQL Cluster (NDB) it works\u2026","rel":"","context":"In "drizzle"","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":955,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/12\/10\/twitter-updates-for-2007-12-10\/","url_meta":{"origin":762,"position":2},"title":"Twitter Updates for 2007-12-10","author":"Stewart Smith","date":"2007-12-10","format":false,"excerpt":"looking at how InnoDB does system variables in the mysql server (it does it the pluggable way). Trying to put this into NDB # @brianaker: we may do... not top of priority list... but I had a patch ages ago that did most of this stuff.. and it wasn't *too*\u2026","rel":"","context":"In "Twitter"","block_context":{"text":"Twitter","link":"https:\/\/www.flamingspork.com\/blog\/category\/from-twitter\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":847,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/06\/19\/my-top-5-wishlist-for-mysql\/","url_meta":{"origin":762,"position":3},"title":"My Top 5 Wishlist for MySQL","author":"Stewart Smith","date":"2007-06-19","format":false,"excerpt":"I'm going and stealing Jay's idea (who stole it off Brian Duff... but his was for Oracle so obviously doesn't count :) So, my five wishes for MySQL Are: 5. Six-monthly release cycles Getting a release out there takes way too long. There's a variety of reasons, but seeing the\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":914,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/11\/09\/mysql-5122-stew2\/","url_meta":{"origin":762,"position":4},"title":"mysql-5.1.22-stew2","author":"Stewart Smith","date":"2007-11-09","format":false,"excerpt":"New: Updated NDB Compressed LCP and BACKUP patches (now with O_DIRECT support) InnoDB patch for Windows that should give ~5x improvement on commits\/sec (Bug31876) Everything in current telco-6.3 tree (ndb ~6.3.5) Lots of NDB improvements and new features over regular 5.1. WL3686 Remove read before update WL2680 NDB Batched Update\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":754,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/10\/26\/mysql-ndb-team-trees-up-on-bkbitsnet\/","url_meta":{"origin":762,"position":5},"title":"mysql NDB team trees up on bkbits.net","author":"Stewart Smith","date":"2006-10-26","format":false,"excerpt":"If you head over here: mysql on bkbits.net you can get a copy of the NDB team trees. This is where we push stuff before it hits the main MySQL trees so that we can get some extra testing in (also for when pulling from the main tree). So you\u2026","rel":"","context":"In "mysql"","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=762"}],"version-history":[{"count":2,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/762\/revisions"}],"predecessor-version":[{"id":1529,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/762\/revisions\/1529"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}