{"id":2985,"date":"2014-11-03T03:59:12","date_gmt":"2014-11-03T08:59:12","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2985"},"modified":"2014-11-03T03:59:12","modified_gmt":"2014-11-03T08:59:12","slug":"osquery-is-neat","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/11\/03\/osquery-is-neat","title":{"rendered":"osquery is neat"},"content":{"rendered":"

Facebook recently made opensource, osquery<\/a>. It gives you operating system data via SQL queries! Its very neat, and you can test this even on MacOSX (it works on that platform & Linux). It is by far the project with the most advanced functionality, linked here in this post.<\/p>\n

I noticed that rather quickly, there was a PostgreSQL project, called pgosquery<\/a>, based on Foreign Data Wrappers<\/a>\u00a0with a similar idea. (apparently it was written in less than 15 minutes; so a much lower learning curve than the regular MySQL storage engine interface)<\/p>\n

I immediately thought about an older MySQL project, by Chip Turner<\/a> (then at Google, now at Facebook), called mysql-filesystem-engine<\/a>. This idea was kicking around in 2008. I was intrigued by hearing about this at a talk (probably at the MySQL Conference & Expo); it\u2019s a pity no one took this further.<\/p>\n

On a similar tangent, did you also know that there is the option to use MySQL as storage via FUSE (see: mysqlfs<\/a>)? An article<\/a> by Ben Martin shows some practical examples.<\/p>\n

At its heyday, MySQL had many storage engines (maybe around 50). Wikipedia has an incomplete list<\/a>. I see some engines on that list, and think that some of these folk are also creating MongoDB backends \u2013 competition. At MariaDB we are probably shipping the most storage engines<\/a> of any MySQL-based distribution, however I think we could be doing an even better job at working with upstream vendors, and figuring out how to support & augment business around it.<\/p>\n

Share this:<\/h3>