Tag: database
ActiveMQ + Ruby Stomp Client: How to process elements one by one
30 Oct2008

Few months ago I’ve switched one of our internal projects from doing synchronous database saves of analytics data to an asynchronous processing using starling + a pool of workers. This was the day when I really understood the power of specialized queue servers. I was using database (mostly, MySQL) for this kind of tasks for years and sometimes (especially under a highly concurrent load) it worked not so fast… Few times I worked with some queue servers, but those were either some small tasks or I didn’t have a time to really get the idea, that specialized queue servers were created just to do these tasks quickly and efficiently.

All this time (few months now) I was using starling noticed really bad thing in how it works: if workers die (really die, or lock on something for a long time, or just start lagging) and queue start growing, the thing could kill your server and you won’t be able to do something about it – it just eats all your memory and this is it. Since then I’ve started looking for a better solution for our queuing, the technology was too cool to give up. I’ve tried 5 or 6 different popular solutions and all of them sucked… They ALL had the same problem – if your queue grows, this is your problem and not queue broker’s :-/ The last solution I’ve tested was ActiveMQ and either I wasn’t able to push it to its limits or it is really so cool, but looks like it does not have this memory problem. So, we’ve started using it recently.

In this small post I’d like to describe a few things that took me pretty long to figure out in ruby Stomp client: how to make queues persistent (really!) and how to process elements one by one with clients’ acknowledgments.
Read the rest of this entry


[lang_en]Tuning and Optimizing Red Hat Enterprise Linux for Oracle 9i and 10g Databases[/lang_en][lang_ru]Настройка и оптимизация Red Hat Enterprise Linux для баз данных Oracle 9i и 10g[/lang_ru]
1 Mar2006

[lang_en]

Werner Puschitz wrote really great article about RHEL optimization for latest versions of Oracle Database Server. As I think, this is the most complete reference about linux optimizations for Oracle and it must to be in bookmarks of any Linux Administrator because who knows, which job we will get tomorrow and maybe, todays ISP admin will get Enterprise DBA position? 😉

[/lang_en]
[lang_ru]

Werner Puschitz написал отличную статью на тему оптимизации RHEL для использования последних версий Oracle Database Server. Мне кажется, что это одно из самых полных руководств по оптимизации Linux для Oracle, и ссылка на него просто обязана находиться в закладках у любого Linux-администратора, так как кто знает, какую работу мы получим завтра? И вполне может случиться такое, что сегодняшний админ ISP завтра получит место Enterprise DBA в зарубежной компании :-).

[/lang_ru]