如何监听mysql数据同步到搜索引擎ElasticSearch

最新推荐文章于 2024-07-31 18:00:00 发布

风写意

最新推荐文章于 2024-07-31 18:00:00 发布

阅读量258

点赞数

分类专栏： java elasticsearch 文章标签： mysql 触发器数据库 elasticsearch java

本文链接：https://blog.csdn.net/weixin_43465669/article/details/103067856

版权

java 同时被 2 个专栏收录

10 篇文章 0 订阅

订阅专栏

elasticsearch

1 篇文章 0 订阅

订阅专栏

binlog文件法

触发器

CREATE TABLE `student_score` (
  `id` bigint(60) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `score` decimal(10,1) NOT NULL,
  `code` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

CREATE TABLE `student_score_trigger` (
  `coutent` varchar(255) DEFAULT NULL,
  `student_score_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `score` decimal(10,1) DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `is_delete` int(11) DEFAULT '0' COMMENT '0未删除1已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

新增触发器
CREATE TRIGGER `student_score_trigger` AFTER INSERT ON `student_score` FOR EACH ROW INSERT INTO student_score_trigger(coutent,student_score_id,name,score,code,subject) VALUES('学生成绩表插入了一条记录',new.id,new.name,new.score,new.code,new.subject);
修改触发器
CREATE TRIGGER `student_score_trigger_update` AFTER UPDATE ON `student_score` FOR EACH ROW INSERT INTO student_score_trigger(coutent,student_score_id,name,score,code,subject) VALUES('学生成绩表更新了一条记录',new.id,new.name,new.score,new.code,new.subject);
删除触发器
CREATE TRIGGER `student_score_trigger_delete` AFTER DELETE ON `student_score` FOR EACH ROW INSERT INTO student_score_trigger (
	coutent,
	student_score_id,
	NAME,
	score,
	CODE,
	SUBJECT
)
VALUES
	(
		'学生成绩表删除了一条记录',
		old.id,
		null,
		null,
		null,
		null
	);