前言
Redis脚本采用crontab机制,1min触发一次。该需求痛点在于当MySQL发生CURD操作时,Redis需做同样操作。这其中诸如Redis进行update时待修改数据未知等问题点众多~
几种思路选型
field,field_old格式
CREATE TABLE `xxx` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'something|someone|someday',
`label_name` varchar(45) NOT NULL DEFAULT '' COMMENT 'something|someone|someday',
`label_name_old` varchar(45) NOT NULL DEFAULT '' COMMENT 'something|someone|someday',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'something|someone|someday',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'something|someone|someday',
PRIMARY KEY (`id`),
KEY `idx_create_time` (`create_time`),
KEY `idx_update