blocks|key|900376|text|忽略整个NoSQL与SQL的争论，我认为最好的方法是将它们结合起来。换句话说，将MySQL用于系统的某些部分(复杂的查找、事务)，将redis用于其他部分(性能、计数器等)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|900377|根据我的经验，性能问题与可伸缩性有关(大量用户...)最终会迫使您添加某种类型的缓存来从MySQL服务器中移除负载，而redis/memcached在这方面非常擅长。|900378|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Ignoring the whole NoSQL vs SQL debate, I think the best approach is to combine them. In other words, use MySQL for for some parts of the system (complex lookups, transactions) and redis for others (performance, counters etc). 

In my experience, performance issues related to scalability (lots of users...) eventually forces you to add some kind of cache to remove load from the MySQL server and redis/memcached is very good at that.

blocks|key|1115225|text|MySql+-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1115226|1)结构化数据2)+ACID+3)繁重的事务和查找。|1115227|瑞迪斯-|1115228|1)非结构化数据2)简单快速的查找。对于会话的eg+-+token+3)使用它作为缓存层。|1115229|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

MySql - 

1) Structured data
2) ACID 
3) Heavy transactions and lookups.

Redis -

1) Non structured data
2) Simple and quick lookups. for eg - token of a session
3) use it for caching layer.

blocks|key|1115291|text|根据官方网站的介绍，Redis是一个开源(BSD许可)的内存数据结构存储，用作数据库、缓存和消息代理。实际上，Redis是一个高级的键值存储。它真的是超级快，具有惊人的高吞吐量，因为它每秒可以执行大约110000个集合，大约每秒81000个GET。它还支持存储一组非常丰富的数据类型。事实上，Redis每次都会将数据保存在内存中，但也会持久存储在磁盘数据库中。因此，它带来了一个权衡:惊人的速度与数据集的大小限制(根据内存)。在本文中，为了与MySQL进行比较，我们将使用Redis作为缓存引擎。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1115292|点击此处阅读：Redis+vs+MySQL+Benchmarks|offset|length|1115293|entityMap|0|LINK|mutability|MUTABLE|url|https://fullstackgeek.blogspot.com/2019/04/redis-vs-mysql-benchmark.html^0|0|7|P|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

According to the official website, Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache and message broker. Actually, Redis is an advanced key-value store. It is literally super fast with amazingly high throughput as it can perform approximately 110000 SETs per second, about 81000 GETs per second. It also supports a very rich set of data types to store. As a matter of fact, Redis keeps the data in-memory every time but also persistent on-disk database. So, it comes with a trade-off: Amazing speed with the size limit on datasets (as per memory). In this article, to have some benchmarks in comparison to MySQL, we would be using Redis as a caching engine only.

Read Here: <a href="https://fullstackgeek.blogspot.com/2019/04/redis-vs-mysql-benchmark.html" rel="nofollow noreferrer">Redis vs MySQL Benchmarks</a>

I've been looking at Redis. It looks very interesting. But from a practical perspective, in what cases would it be better to use Redis over MySQL?

When to use Redis instead of MySQL for PHP applications?

结构化数据

消息代理

数据结构

数据库

服务器

MySQL

Redis

NoSQL

我一直在找雷迪斯。它看起来很有趣。但是从实际的角度来看，在什么情况下使用Redis比使用MySQL更好呢？

问什么时候为PHP应用程序使用Redis代替MySQL？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问什么时候为PHP应用程序使用Redis代替MySQL？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问什么时候为PHP应用程序使用Redis代替MySQL？
EN