当前位置: 软件>C/C++软件
MySQL ZeroMQ Plugin
本文导语: mysql-zmq-plugin ZeroMQ / ØMQ for MySQL Build 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 'libze...
mysql-zmq-plugin
ZeroMQ / ØMQ for MySQL
Buildcmake . make && make installInstall & 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)Test 编译zeromq server 测试程序
cd test cmake . make ./server在mysql终端中运行测试SQL
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)
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。