|
|
mod_ndb 1.0 is here
Mod_ndb is an Apache module that provides a Web Services API for MySQL Cluster. It creates a direct connection from an Apache Web server to the NDB data nodes in a MySQL Cluster (bypassing mysqld, and eliminating the need to create or parse SQL queries at run-time). This allows you to query and modify a database over HTTP using GET, POST, and DELETE requests, and fetch results in a variety of formats, including JSON results that can go 'direct to the browser' in an Ajax application. Mod_ndb is also scriptable, using Apache's subrequest API, so that complex multi-table transactions or joins (even including sort-merge join plans that are currently not possible in MySQL) can be easily created in PHP or Perl.
Changes since 1.0 rc
Release 1.0 includes the following changes since 1.0-rc:
- (r465) The t.sql utility in the test suite would hang ( "test.list" was not supplied).
- (r480) Fix error exit in "configure" to indicate which option was bad.
- (r485) Fix to runner.awk in the test suite -- awk substrings start at 1, not 0.
- (r491) Fix undefined symbol with Apache 1.3 ( issue #56 )
What's coming in mod_ndb 1.1?
- Support for multiple TEXT or BLOB columns in a result
- Support for the server side of the JSONRequest proposal (BUT SEE issue#58)
- Apache 1.3 apxs is no longer required when building mod_ndb for Apache 2.0
NEWS: mod_ndb gets a SQL parser
So far, mod_ndb has been limited by what can be specified in one-line Apache configuration directives. But now it supports "N-SQL," which looks a lot like SQL. It is not any more powerful than the old-style configuration -- it doesn't have an optimizer, it can't do joins, and it requires you to tell it which indexes to use -- but probably does allow for more succinct and intuitive configuration of HTTP endpoints.
Links
- Documentation is hosted on the wiki at MySQL Forge
- The mod_ndb mailing list is hosted on Google Groups
- OlderNews
