A Multithreaded Job Queue For Ruby (on Rails)

Tags: job queue, load balancing, mysql, ruby on rails
Posted 539 days ago.

I have a Ruby on Rails application with a rapidly growing database of currently 50,000 jobs per day to be executed. Each jobs fetches data over the internet and takes about 1-10 seconds to execute. These tasks are scheduled for specific times and should be executed with as little delay as possible. Read more ... (1380 words) 3 Comments.

A MySQL Abstraction Class For PHP

Tags: database abstraction, mysql, pear, php
Posted 1861 days ago.

Over the time I have been working with PHP, I built a library of useful classes for my projects. I have always wanted to publish this library freely. It will take some time to clean up the code base and comments, but if someone has use for it, then I will be glad to do it.

Duplicate a MySQL Database

Tags: mysql
Posted 1907 days ago.

This shell command will duplicate an existing database:

# mysqladmin create DB_name -u DB_user --password=DB_pass && \
mysqldump -u DB_user --password=DB_pass DB_name | mysql -u DB_user --password=DB_pass -h DB_host DB_name

Replace DB_* with your MySQL settings. Where could this be useful besides making a mirror backup of a database?