mysql-udf-http 是一款简单的MySQL用户自定义函数,具有http_get()、http_post()、http_put()、http_delete()四个函数,可以在MySQL数据库中利用HTTP协议进行REST相关操作,它的安装方式如下:
tar zxvf mysql-udf-http-1.0.tar.gz
cd mysql-udf-http-1.0/
./configure --prefix=/usr/local/mysql --with-mysql=/usr/local/mysql/bin/mysql_config
make && make install
如果提示缺少libcurl,就安装libcurl
yum install libcurl*
正常的情况mysql-udf-http.so等文件将安装至/usr/local/mysql/lib/plugin下,不知什么原因我的装在了/usr/local/mysql/lib/下,于是加个软链
ln -s /usr/local/mysql/lib/mysql-udf-http.so /usr/local/mysql/lib/plugin/mysql-udf-http.so
安装成功后,进到mysql控制台,注册相关函数
create function http_get returns string soname ‘mysql-udf-http.so’;
create function http_post returns string soname ‘mysql-udf-http.so’;
create function http_put returns string soname ‘mysql-udf-http.so’;
create function http_delete returns string soname ‘mysql-udf-http.so’;
然后在业务表中加入更新操作的触发器
DELIMITER |
DROP TRIGGER IF EXISTS student_update;
CREATE TRIGGER student_update
AFTER UPDATE ON student
FOR EACH ROW BEGIN
SET @tt_re = (SELECT http_get(CONCAT(‘http://172.16.15.177:1625/data/putStudentDate?sid=’, OLD.sid)));
END |
DELIMITER ;
经测试,当学生表中的数据有更新时,mysql会发送get请求至业务系统。
INSERT 触发器
DROP TRIGGER IF EXISTS student_delete
;
DELIMITER ;;
CREATE TRIGGER student_delete
AFTER INSERT ON student
FOR EACH ROW BEGIN
SET @tt_re = (SELECT http_get(CONCAT(‘http://172.16.15.177:1625/data/postStudentDate?sid=’, NEW.sid)));
END
;;
DELIMITER ;
DELETE 触发器
DELIMITER |
DROP TRIGGER IF EXISTS student_delete;
CREATE TRIGGER student_delete
AFTER DELETE ON student
FOR EACH ROW BEGIN
SET @tt_re = (SELECT http_get(CONCAT(‘http://172.16.15.177:1625/data/deleteStudentDate?sid=’, OLD.sid)));
END |
DELIMITER ;
原文链接:https://blog.csdn.net/u011424470/article/details/84192483