{"id":776,"date":"2007-01-08T15:38:54","date_gmt":"2007-01-08T05:38:54","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2007\/01\/08\/ndb-ndb-the-storage-engine-for-me\/"},"modified":"2013-12-18T08:46:10","modified_gmt":"2013-12-17T22:46:10","slug":"ndb-ndb-the-storage-engine-for-me","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2007\/01\/08\/ndb-ndb-the-storage-engine-for-me\/","title":{"rendered":"NDB! NDB! The storage engine for me!"},"content":{"rendered":"

Today I set up a mysqld connected to my not-quite-HA cluster at home here to replicate from my MythTV database into cluster. The idea behind this is to eat an increasing amount of my own dogfood around the house.<\/p>\n

To do this, I also set up the MySQL Instance Manager to manage the now multiple instances of MySQL Servers on a box here. I found it a pain to do, it should be a lot simpler, but isn’t. At least now things are going okay…. but the feature wish list I have is rather long (perhaps I should hack some stuff up in this “spare time” i’ve been hearing so much about).<\/p>\n

I’m also about 10 minutes (or however long the build takes) off moving one of the data nodes off the machine so it will be a real 2 node system (but I still have to move the management server to a third machine to have any real HA… and I have a PowerPC machine marked for that, I just have to await some patches to make it work :)<\/p>\n

Currently though, my Gallery is being served off this. There are so many more photos I should add, I just haven’t come up with a decent way to interface f-spot and Gallery together – especially when I go back and retouch, delete or tag photos.<\/p>\n","protected":false},"excerpt":{"rendered":"

Today I set up a mysqld connected to my not-quite-HA cluster at home here to replicate from my MythTV database into cluster. The idea behind this is to eat an increasing amount of my own dogfood around the house. To … 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_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":[628,630,54],"class_list":["post-776","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-mythtv","tag-ndb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-cw","jetpack-related-posts":[{"id":846,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/06\/15\/its-here-its-here\/","url_meta":{"origin":776,"position":0},"title":"It’s here! It’s here!","author":"Stewart Smith","date":"2007-06-15","format":false,"excerpt":"So, I hear you ask (ask dagnammit!), what does a MySQL Cluster hacker do when not hacking MySQL Cluster? Well, Today, a box arrived: I eagerly opened the box... eager for what was inside: Hrrm... this does look promising! Quickly I turned it all up the right way: It's here!\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":788,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/02\/07\/timeout-units\/","url_meta":{"origin":776,"position":1},"title":"timeout units","author":"Stewart Smith","date":"2007-02-07","format":false,"excerpt":"Following a discussion on mythtv on #xfs (as you do), and a wondering of \"hrrm... i wonder what unit that timeout is\" with some NDB code I wish to make the following announcement: All timeout values in NDB related APIs will now be given in centijiffies of the server system.\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":1400,"url":"https:\/\/www.flamingspork.com\/blog\/2009\/02\/20\/linuxconfau-2009-wrap-up-incl-open-source-databases-mini-conf-day-0-1\/","url_meta":{"origin":776,"position":2},"title":"linux.conf.au 2009 wrap-up (incl Open Source Databases Mini-conf): Day 0-1","author":"Stewart Smith","date":"2009-02-20","format":false,"excerpt":"It's no secret that I love linux.conf.au. My first was linux.conf.au 2003, in Perth and I've been to every one since (there are at least two people who've been to every single one, including CALU as it was called in 1999). I've been on the board of Linux Australia for\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":1783,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/02\/03\/ndbinfo-with-sql-hits-beta\/","url_meta":{"origin":776,"position":3},"title":"NDB$INFO with SQL hits beta","author":"Stewart Smith","date":"2010-02-03","format":false,"excerpt":"\u00ef\u00bb\u00bfBernhard blogged over at http:\/\/ocklin.blogspot.com\/2010\/02\/mysql-cluster-711-is-there.html that MySQL Cluster 7.1.1 Beta has been released. The big feature (from my point of view) is the SQL interface on top of NDB$INFO. This means there is now full infrastructure from the NDB data nodes right out to SQL in the MySQL Server for\u2026","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":891,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/09\/19\/mysql-cluster-ndb-on-microsoft-windows\/","url_meta":{"origin":776,"position":4},"title":"MySQL Cluster (NDB) on Microsoft Windows","author":"Stewart Smith","date":"2007-09-19","format":false,"excerpt":"Well... there's been some work. Even some in-progress patches. Being involved with this has just perfectly refreshed my memory of why I left the platform. Oh my it's a horrible, horrible platform. Everything from UI to API... ick. Expect something around soon....","rel":"","context":"In "General"","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3899,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/11\/11\/mysql-cluster-on-power8\/","url_meta":{"origin":776,"position":5},"title":"MySQL Cluster on POWER8","author":"Stewart Smith","date":"2014-11-11","format":false,"excerpt":"So, I've written previously on MySQL on POWER, and today is a quick bit of news about MySQL Cluster on POWER - specifically MySQL Cluster 7.3.7. I ran into three main issues in getting some flexAsync benchmark results. One of them was the fact that I wanted to do this\u2026","rel":"","context":"In "code"","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"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\/776","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=776"}],"version-history":[{"count":3,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/776\/revisions"}],"predecessor-version":[{"id":3571,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/776\/revisions\/3571"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}