Producer/consumer system using database (MySql), is this feasible?

Posted by johnrl on Stack Overflow See other posts from Stack Overflow or by johnrl
Published on 2010-03-15T17:36:52Z Indexed on 2010/03/15 17:39 UTC
Read the original article Hit count: 391

Filed under:
|
|
|
|

Hi all. I need to use something to coordinate my system with several consumers/producers each running on different machines with different operating systems. I have been researching on using MySql to do this, but it seems ridiculously difficult.

My requirements are simple: I want to be able to add or remove consumers/producers at any time and thus they should not depend on each other at all. Naturally a database would separate the two nicely.

I have been looking at Q4M message queuing plugin for MySql but it seems complicated to use: I have to recompile it every time I upgrade MySql (can this really be true?) because when I try to install it on Ubuntu 9.10 with MySql 5.1.37 it says "Can't open shared library 'libqueue_engine.so' (errno: 0 API version for STORAGE ENGINE plugin is too different)". There is no precompiled version for MySql 5.1.37 apparently. Also what if I want to run MySql on my windows machine, then I can't rely on this plugin as it only seems to run on Linux and OSX??

I really need some input on how to construct my system best possible.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database