Which database is best for more performance with Magento?
哪个数据库最适合用Magento进行更多的性能测试?
My Magento store using more than 80k products with 2k category.
我的Magento商店使用超过80k的产品，类别为2k。
My Question is :
我的问题是:
1) Is Mysql database will enough to manage my product / category ranges ?
2) Or Shall i use any other database with Magento to keep the site loading fast ?
Any suggestion much appriciation.
任何的建议来到。
2 个解决方案
#1
1
You might also want to give Percona Percona a call. Other MySQL forks are available. I haven't used Percona but they know a lot about tuning InnoDB. Performance improvements over MySQL are moot but read all the answers to this question for some background.
你也可以给Percona Percona打电话。其他MySQL分支可用。我没有使用Percona，但是他们知道很多关于优化InnoDB的知识。对MySQL的性能改进是没有意义的，但是请阅读下面这个问题的所有答案。
Whatever you do, caching is certainly your friend.
无论你做什么，缓存肯定是你的朋友。
Your product set is large but traffic volume and traffic spikes have a big impact on tuning and hardware choice.
您的产品集很大，但是流量和流量峰值对调优和硬件选择有很大的影响。
#2
1
With that many products and categories your shop surely won't perform very fast. But this also depends on your hardware and the amount of Magento StoreViews you will be using. So the question you should ask is: what is the best caching mechanism to keep your frontend fast? There are different approaches like using a combination of Varnish, Redis and nginx.
有了这么多产品和分类，你的商店肯定不会很快的。但这也取决于您的硬件和您将要使用的Magento存储视图的数量。因此，您应该问的问题是:保持前端快速的最佳缓存机制是什么?有不同的方法，如使用清漆，红色和nginx的组合。
#1
1
You might also want to give Percona Percona a call. Other MySQL forks are available. I haven't used Percona but they know a lot about tuning InnoDB. Performance improvements over MySQL are moot but read all the answers to this question for some background.
你也可以给Percona Percona打电话。其他MySQL分支可用。我没有使用Percona，但是他们知道很多关于优化InnoDB的知识。对MySQL的性能改进是没有意义的，但是请阅读下面这个问题的所有答案。
Whatever you do, caching is certainly your friend.
无论你做什么，缓存肯定是你的朋友。
Your product set is large but traffic volume and traffic spikes have a big impact on tuning and hardware choice.
您的产品集很大，但是流量和流量峰值对调优和硬件选择有很大的影响。
#2
1
With that many products and categories your shop surely won't perform very fast. But this also depends on your hardware and the amount of Magento StoreViews you will be using. So the question you should ask is: what is the best caching mechanism to keep your frontend fast? There are different approaches like using a combination of Varnish, Redis and nginx.
有了这么多产品和分类，你的商店肯定不会很快的。但这也取决于您的硬件和您将要使用的Magento存储视图的数量。因此，您应该问的问题是:保持前端快速的最佳缓存机制是什么?有不同的方法，如使用清漆，红色和nginx的组合。