{"id":829,"date":"2007-04-27T05:22:00","date_gmt":"2007-04-26T19:22:00","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2007\/04\/27\/adding-a-pluggable-information-schema-table-to-a-pluggable-engine-in-mysql-51\/"},"modified":"2013-12-18T08:46:44","modified_gmt":"2013-12-17T22:46:44","slug":"adding-a-pluggable-information-schema-table-to-a-pluggable-engine-in-mysql-51","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2007\/04\/27\/adding-a-pluggable-information-schema-table-to-a-pluggable-engine-in-mysql-51\/","title":{"rendered":"adding a pluggable information schema table to a pluggable engine in mysql 5.1"},"content":{"rendered":"<p>Also now up is the patch series in my &#8220;ndb-work&#8221; tree which small patch for adding INFORMATION_SCHEMA.NDB_NODE_STATUS. It&#8217;s nearly useful&#8230; I haven&#8217;t brought in the nice &#8220;id to string&#8221; functions in the management client that make pretty printing nice&#8230; so not quite end user friendly :)<\/p>\n<p>But it&#8217;s a nice patch to learn how to add an INFORMATION_SCHEMA table in a pluggable engine and put some engine specific information in it.<\/p>\n<p>(kudos to the falcon code&#8230; which i looked at on how to do it).<\/p>\n<p>Doesn&#8217;t take long &#8211; this was completed in less than 2hrs while watching and paying attention to sessions&#8230;. so should take next to no time if you actually concentrate on it.<\/p>\n<p>Of course, this totally abuses the purity of the information schema.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Also now up is the patch series in my &#8220;ndb-work&#8221; tree which small patch for adding INFORMATION_SCHEMA.NDB_NODE_STATUS. It&#8217;s nearly useful&#8230; I haven&#8217;t brought in the nice &#8220;id to string&#8221; functions in the management client that make pretty printing nice&#8230; so &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2007\/04\/27\/adding-a-pluggable-information-schema-table-to-a-pluggable-engine-in-mysql-51\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"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_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":[14],"tags":[633,628,54],"class_list":["post-829","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-code","tag-mysql","tag-ndb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-dn","jetpack-related-posts":[{"id":1650,"url":"https:\/\/www.flamingspork.com\/blog\/2009\/05\/27\/pluggable-metadata-stores-or-the-revenge-of-table-discovery\/","url_meta":{"origin":829,"position":0},"title":"Pluggable Metadata stores (or&#8230; 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 &quot;drizzle&quot;","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":762,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/11\/22\/pluggable-ndb\/","url_meta":{"origin":829,"position":1},"title":"pluggable NDB","author":"Stewart Smith","date":"2006-11-22","format":false,"excerpt":"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 shouldn't be dumped (hint: the cluster database used for replication).\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"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":829,"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 &quot;Twitter&quot;","block_context":{"text":"Twitter","link":"https:\/\/www.flamingspork.com\/blog\/category\/from-twitter\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1655,"url":"https:\/\/www.flamingspork.com\/blog\/2009\/06\/09\/drizzle-pluggable-metadatastore-or-no-table-definition-file-on-disk\/","url_meta":{"origin":829,"position":3},"title":"Drizzle pluggable MetadataStore (or: no table definition file on disk)","author":"Stewart Smith","date":"2009-06-09","format":false,"excerpt":"My code is shaping up rather nicely (see https:\/\/code.launchpad.net\/~stewart\/drizzle\/discovery) and I'm planning to submit a merge-request for it later today. I'm about to commit code that implements a MetadataStore for the ARCHIVE engine. This means that for ARCHIVE tables, you only have the .ARZ file on disk. The table definition\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"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":829,"position":4},"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 &quot;mysql&quot;","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":2303,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/03\/16\/fixed-in-drizzle-no-more-gotchas\/","url_meta":{"origin":829,"position":5},"title":"Fixed in Drizzle: No more &#8220;GOTCHA&#8217;s&#8221;","author":"Stewart Smith","date":"2011-03-16","format":false,"excerpt":"\u00a0 At the upcoming MySQL Conference and Expo, I'm going to give a Thursday afternoon (2pm) session entitled Fixed in Drizzle: No more \"GOTCHA's\". I plan to have a lot of fun with this session.. If you go back to the very start of when I started submitting code to\u2026","rel":"","context":"In &quot;drizzle&quot;","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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/829","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=829"}],"version-history":[{"count":4,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/829\/revisions"}],"predecessor-version":[{"id":3583,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/829\/revisions\/3583"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}