News for hackers. Stuff that matters.
Re:Using MySql as a bootleg message queue by scompt on Monday May 09, 2011 @09:09AM (#2528563)
Speaking from experience using mysql as a message queue.

Lock contention will be a bitch past a certain number of processes/threads accessing the DB. Also, hopefully your application doesn't crash during the long-running work. If so, your messages are gone forever.

As for a simpler idea, message queues aren't that difficult. Why not just install a proper one to start off with.

Re:Using MySql as a bootleg message queue by pbreit on Monday May 09, 2011 @12:14PM (#2529190)
Do you have any recommendations for something simple?
Re:Using MySql as a bootleg message queue by zedpm on Monday May 09, 2011 @02:08PM (#2529591)
It depends on what your specific needs are with respect to persistence and other aspects of your application. Take a look at http://blogs.digitar.com/jjww/2009/01/rabbits-and-warrens/ and read about RabbitMQ and ZeroMQ to see if either sounds like a solution for your problem.