[root@server14 local]# mysql
MariaDB [(none)]> show databases;
MariaDB [(none)]> grant all on test.* to redis@'%' identified by 'westos'; ##授权远程用户连接
[root@server12 rhel7]# scp test.sql server14: ##将测试数据复制到mysql主机中
[root@server14 ~]# cat test.sql
[root@server14 ~]# mysql < test.sql ##测试数据导入数据库
测试文件内容
1.4 访问测试
[root@server14 ~]# mysql
MariaDB [(none)]> use test
MariaDB [test]> show tables;
MariaDB [test]> select * from test; ##查看test库中生成的测试内容
[root@server13 ~]# redis-cli
127.0.0.1:6379> get 1
"test1"
127.0.0.1:6379> get 2
"test2"
第一次访问,redis中没有缓存,看不到数据库中相关内容
再次访问,已将mysql中相关内容缓存进redis中,可以访问到
server14
MariaDB [test]> update test set name='westos' where id=1;
server13
127.0.0.1:6379> DEL 1
(integer) 1
[root@server14 ~]# vim test.sql
use test;
ELIMITER $$
CREATE TRIGGER datatoredis AFTER UPDATE ON test FOR EACH ROW BEGIN
SET @RECV=gman_do_background('syncToRedis', json_object(NEW.id as `id`, NEW.name as `name`));
END$$
DELIMITER ;
[root@server14 ~]# mysql < test.sql
[root@server14 ~]# mysql
MariaDB [(none)]> SHOW TRIGGERS FROM test;
MariaDB [(none)]> use test
MariaDB [test]> update test set name='redhat' where id=1;
[root@server13 ~]# redis-cli
127.0.0.1:6379> get 1
"redhat"