mysql与zeromq结合_让 ZeroMQ 为 MySQL 提供远程分布式任务处理

5. 插件如何使用

插件有很多种用法，这里仅仅一个例

编译zeromq server 测试程序

cd test

cmake .

make

启动服务进程

./server

发送Hello world!

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)

查看服务器端是否接收到信息。

$ ./server

Received: Hello world!

我们再将上面的例子使用触发器进一步优化

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)

服务器端已经接收到数据库发过来的信息

$ ./server

Received: Hello world!

Received: 13113668891

Received: 13113668892

Received: 13113668893

Received: 13322993040

Received: 13588997745

我们可以拼装json或者序列化数据，发送给远端

mysql> select zmq_client('tcp://localhost:5555',concat('{name:',name,', tel:',mobile,'}')) from demo;

+------------------------------------------------------------------------------+

| zmq_client('tcp://localhost:5555',concat('{name:',name,', tel:',mobile,'}')) |

+------------------------------------------------------------------------------+

| {name:neo, tel:13113668891} OK |

| {name:jam, tel:13113668892} OK |

| {name:leo, tel:13113668893} OK |

| {name:jerry, tel:13322993040} OK |

| {name:tom, tel:13588997745} OK |

+------------------------------------------------------------------------------+

5 rows in set (0.03 sec)

返回数据取决于你服务端怎么编写处理程序，你可以返回true/false等等。

触发器以及事务处理，这里就不演示了