Message API beta release

Thursday, April 6. 2006

Message API beta release

The Spread Toolkit is one of my favorite Open Source projects. Spread lets you send multicast group messages between applications. It provides reliable, ordered, asynchronous message delivery, and it's efficient, works on large wide-area networks, and can survive and recover from network failures.

What kind of things could you do if a MySQL server could send and receive messages using Spread? I started a new project, the MySQL Message API, to find out. For a few ideas to get started with: if you want to notify a bunch of application servers whenever a particular table changes, you can write a simple trigger to send them all a message. Or if you have lots of different specialized database servers powering your 30-million-user social networking site, you might want to send messages from one server process them (with stored procedure code) on another.

The Message API is a set of MySQL UDFs that enable you to join message groups and to send and receive messages. The first beta release is available now on MySQL Forge. I have been working with the code and testing it pretty extensively for the last three months -- but only on Mac OS X and FreeBSD. I wouldn't be surprised to hear about problems compiling and linking the code on Linux, Solaris, and other platforms, so I'm especially hoping to get some feedback about those.

Posted by John David Duncan at 12:10 | Comments (4) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Hi!

I think a saw a few posts concerning Spread in the nearby past.

I just took a look, and I must say it looks promising. Are there any plans for building a layer that can do something with the content of messages?

Roland

#1 Roland Bouman (Homepage) on 2006-04-06 15:22 (Reply)

Yes, I think the layer that handles the content of messages is probably best written in SQL. It seems so far like the best path is for me to provide sample stored procedure code, and let people modify the samples to suit their particular table structures.

#1.1 J.D. Duncan on 2006-04-06 16:24 (Reply)

Sorry to ask, but am I right concluding that the code you provided is nix-only?

#2 Roland Bouman (Homepage) on 2006-04-13 16:29 (Reply)

Spread runs on Windows, and MySQL runs on Windows, so the Message API code should definitely be able to run on Windows, too. However, I personally don't have a Windows development or test machine or any experience with Windows development. I would be happy if someone could contribute some expertise in this area.

#2.1 J.D. Duncan on 2006-04-13 17:06 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Enclosing asterisks marks text as bold (word), underscore are made via _word_. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information? Subscribe to this entry