4 ms·
MySQL to Redis in One Step
- lemcoe9 14y agoThis does not seem like a good idea. Redis does not serve the same use-cases that MySQL aims to.
- famousactress 14y agoIsn't that a supremely plausible reason for wanting to move data from one to the other? If everything was working out just great in MySQL there'd probably be no reason to move it :)
- twerquie 14y agoThe point of the post is how to efficiently port data from MySQL to Redis once you have decided to make the switch. It's not making any recommendations on when or why to use Redis.
- ipedrazas 14y agoI guess this is exactly the point of moving some data out of the MySQL, right? Different use-cases, different systems.
- firefoxman1 14y agoDoes anyone else wish that Redis had a disk-based version? Other key/value stores like Riak are nice, but I want the simplicity, commands, and raw data types of Redis in a version that could handle terabytes of data. But maybe I'm the only one that wants that.
- meritt 14y agohttp://redis.io/topics/virtual-memory http://redis.io/topics/virtual-memory It used to exist but has since then be deprecated. You can read Salvatore's thoughts on this exact topic here: https://groups.google.com/forum/#!msg/redis-db/IiJU0COilYc/Q5efrbbiZu8J https://groups.google.com/forum/#!msg/redis-db/IiJU0COilYc/Q...
- deleted 14y ago[deleted]
- deleted 14y ago[deleted]
- babuskov 14y agoI believe this could all be done with a single CONCAT. Looks like author is unaware that you can CONCAT(param1, param2, param3, ..., paramN)
- meritt 14y agoIt could also be done without a sub-table either select concat("*4\r\n$4\r\nHSET\r\n$15\r\nevents_all_time\r\n$", length(action), "\r\n", action, "\r\n$", length(`count`), "\r\n", `count`, "\r") from events_all_time
- twerquie 14y agoGood point, I removed the nested CONCATs for clarity. Thanks!