ZeroMQ for MySQL
+ Table of Contents

ZeroMQ / ØMQ for MySQL

https://github.com/netkiller/mysql-zmq-plugin

Build

git clone https://github.com/netkiller/mysql-zmq-plugin.git
cmake .
make && make install

Install & uninstall

drop function zmq_client;
drop function zmq_publish;

create function zmq_client returns string soname 'libzeromq.so';
create function zmq_publish returns string soname 'libzeromq.so';

mysql> SELECT * FROM `mysql`.`func` LIMIT 1000;
+--------------+-----+--------------+----------+
| name         | ret | dl           | type     |
+--------------+-----+--------------+----------+
| image_crc32  |   0 | image.so     | function |
| image_rename |   0 | image.so     | function |
| image_move   |   0 | image.so     | function |
| image_remove |   0 | image.so     | function |
| image_check  |   0 | image.so     | function |
| fifo_write   |   0 | fifo.so      | function |
| fifo_read    |   0 | fifo.so      | function |
| fifo_remove  |   0 | fifo.so      | function |
| fifo_create  |   0 | fifo.so      | function |
| zmq_publish  |   0 | libzeromq.so | function |
| zmq_client   |   0 | libzeromq.so | function |
+--------------+-----+--------------+----------+
11 rows in set (0.00 sec)

Example

mysql> select zmq_client('tcp://localhost:5555','Hello world!');
+---------------------------------------------------+
| zmq_client('tcp://localhost:5555','Hello world!') |
+---------------------------------------------------+
| Hello world! OK                                   |
+---------------------------------------------------+
1 row in set (0.01 sec)

mysql> select zmq_client('tcp://localhost:5555',mobile) from demo;
+-------------------------------------------+
| zmq_client('tcp://localhost:5555',mobile) |
+-------------------------------------------+
| 13113668891 OK                            |
| 13113668892 OK                            |
| 13113668893 OK                            |
| 13322993040 OK                            |
| 13588997745 OK                            |
+-------------------------------------------+
5 rows in set (0.03 sec)

Comments: 3

Add a New Comment

Written: 07 Jan 2014 08:27
Revised: 09 Jun 2017 19:09

If you found this page useful, please rate it up so others will find it.

rating: +1+x

Edit this page | Tags | Print

See also

Show summary of event category

Who's watching this page?

m1rku5m1rku5
bebopagogobebopagogo
wezhangwezhang
malomalo
MandarChoureMandarChoure
Jay LorenzoJay Lorenzo
bbqchickenrobotbbqchickenrobot
bvargabvarga
vvickersvvickers
mjaspersemjasperse
Fernando J QuinteroFernando J Quintero
Tarun JangraTarun Jangra
finbuenofinbueno
JohnAppsJohnApps
john-wajohn-wa
gford1000gford1000
yuqiaoyuqiao
jolneyjolney
GeorgeFinecottGeorgeFinecott
Daniel MooreDaniel Moore

... and more

Watch: site | category | page