数据库数据同步至redis

最新推荐文章于 2024-08-15 11:46:38 发布

weixin_43315211

最新推荐文章于 2024-08-15 11:46:38 发布

阅读量778

点赞数

分类专栏： redis 文章标签： redis 数据库数据同步

本文链接：https://blog.csdn.net/weixin_43315211/article/details/97112416

版权

redis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

主程序：

mysql -uroot -ppasswd -h 192.168.108.140 test --skip-column-names --raw < ~/linuxmysql.sql | $REDIS_HOME/src/redis-cli -h 192.168.108.126 -p 6369 --pipe

mysql执行程序1

SELECT CONCAT(
"*8\r\n",
'$', LENGTH(redis_cmd), '\r\n',redis_cmd, '\r\n','$', LENGTH(redis_key), '\r\n',redis_key, '\r\n',
'$', LENGTH(hkey1), '\r\n',hkey1, '\r\n','$', LENGTH(hval1), '\r\n', hval1, '\r\n'
'$', LENGTH(hkey2), '\r\n',hkey2, '\r\n','$', LENGTH(hval2), '\r\n', hval2, '\r\n'
'$', LENGTH(hkey3), '\r\n',hkey3, '\r\n','$', LENGTH(hval3), '\r\n', hval3, '\r')
FROM (
SELECT
'HMSET' AS redis_cmd, CONCAT('id:',id) AS redis_key,
'id' AS hkey1,id  AS hval1,
'name' AS hkey2,name AS hval2,
'age' AS hkey3,age AS hval3
 FROM redis
 ) AS t

mysql程序2

SELECT CONCAT(redis_cmd,' ',redis_key,' ',hkey1,' ',hval1,' ',hkey2,' ',hval2) FROM (
SELECT
'HMSET' AS redis_cmd, concat('car:',id) AS redis_key,
'id' AS hkey1,id  AS hval1,
'name' AS hkey2,name AS hval2
 FROM car limit 10000) as t