How to configure transfer from libdrizzle to linux?

Question

I am trying to work with constant gear queues. When I try to use libdrizzle like-

gearmand -q libdrizzle --libdrizzle-host=127.0.0.1 --libdrizzle-user=gearman --libdrizzle-password=secret --libdrizzle-db=some_db --libdrizzle-table=gearman_queue --libdrizzle-mysql 

It gives me an error like

 gearmand: unknown option libdrizzle-host 

It is also strange that when I do man gearmand it has no libdrizzle options. What should I do? I want persistent queues in mysql. I tried using gearman_udf_mysql , but that didn't work either. I posted a problem. see Where does mysql save the path for mysql udf files for gearman?

Answer 1

Gearman must be compiled with libdrizzle / mysql support. You can check if it compiled by running the gearmand --help command or in earlier versions of man gearmand .

If libdrizzle / mysql support is available, you will see Drizzle / Mysql options in the help. If this is not the case, you will need to recompile the transfer. The following are the commands to install Gearman 1.1.12 on Ubuntu 12.04 LTS (tested on a clean Vagrant exact64 box):

 vagrant@precise64 :~$ sudo apt-get update vagrant@precise64 :~$ sudo apt-get install libboost-all-dev gperf libevent-dev uuid-dev libmysqld-dev vagrant@precise64 :~$ wget https://launchpad.net/gearmand/1.2/1.1.12/+download/gearmand-1.1.12.tar.gz vagrant@precise64 :~$ tar zxvf gearmand-1.1.12.tar.gz vagrant@precise64 :~$ cd gearmand-1.1.12/ vagrant@precise64 :~/gearmand-1.1.12$ ./configure 

At this point, find the following lines at the end of the ./configure output, which indicates Mysql support:

 * Building with libdrizzle yes * Building with libmysql yes 

Then proceed with the installation:

 vagrant@precise64 :~/gearmand-1.1.12$ make vagrant@precise64 :~/gearmand-1.1.12$ sudo make install 

Gearmand is now configured with libdrizzle and will store jobs in the Mysql database.