docker run --name mysql --restart=always -p 3306:3306 -v /home/dockerfile/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=12345678 -d fuguangly/mysql-http:8.0
基于mysql8.0官方docker镜像制作
主要实现触发器调用http接口。
安装了curlapt-get install curl
mysql安装了mysql-udf-http.so /usr/lib/mysql/plugin/mysql-udf-http.so
mysqld --lower-case-table-names=1默认开启sql忽略表字段大小写
root默认密码：12345678
默认映射3306端口
容器数据目录
/var/lib/mysql
以下是使用说明（从这 https://github.com/y-ken/mysql-udf-http 搬过来的）
创建函数 (ps：！！！首次启动容器需要执行下面的创建语句后才可以发送http请求！！！)
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';
语法
mysql>
SELECT http_get('<url>');
SELECT http_post('<url>', '<data>');
SELECT http_put('<url>', '<data>');
SELECT http_delete('<url>');
示例
mysql>
/* Baidu Mobile Search */
SELECT http_get('http://m.baidu.com/s?word=xoyo&pn=0');
SELECT http_post('http://m.baidu.com/s','word=xoyo&pn=0');
select CONVERT (http_get("https://www.baidu.com") USING utf8) as data;
/* Sina Weibo Open Platform */
SELECT http_get('http://api.t.sina.com.cn/statuses/user_timeline/103500.json?count=1&source=1561596835') AS data;
SELECT http_post('http://your_sina_uid:[email protected]/statuses/update.xml?source=1561596835', 'status=Thins is sina weibo test information');
/* Tokyo Tyrant */
SELECT http_put('http://192.168.8.34:1978/key', 'This is value');
SELECT http_get('http://192.168.8.34:1978/key');
SELECT http_delete('http://192.168.8.34:1978/key');
删除卸载
mysql>
drop function http_get;
drop function http_post;
drop function http_put;
drop function http_delete;
其他详细查看
https://blog.csdn.net/weixin_30381317/article/details/95407079
Content type
Image
Digest
Size
167.1 MB
Last updated
over 5 years ago
docker pull fuguangly/mysql-http:8.0