哪种 MQ 实现适合
我必须在现场实现消息队列,在数据库中执行 20K/天的写入操作。我们愿意引入消息队列来减轻这些写入操作的负担。我对消息队列的实现不太了解。如果我们只在一台服务器上实现它会有帮助吗?或者建议一些更好的实施。
还有哪种 MQ 技术有用?我们是 php 商店与 Apache
I have to implement Message Queue on site which do 20K/Day write operation in Database. We are willing to introduce message queues to take load off these write operations. I dont know much about Message Queue Implementation. If we implement it on one server only will it be helpful? or suggest some better impentation.
Also which MQ technology would be useful? We are php Shop with Apache
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
有很多可供选择(到目前为止还没有人提到 rabbitmq),但是如果您每天只处理 20,000 笔交易,那么使用消息队列,特别是在单个服务器上,并不是解决问题的正确方法。
There's lots to choose from (nobody's mentioned rabbitmq so far) however if you are really only processing 20,000 transactions a day then using message queueing, particularly on a single server is not the right way to solve the problem.
所以分解一下,听起来你也有一些 MySQL 问题。
也许我们可以在您设置队列之前帮助您首先优化堆栈的这一部分?特别是因为我还不确定您的应用程序如何使用 MySQL 以及您计划如何或在何处对项目进行排队以从潜在的写锁中卸载。
几天前我刚刚回答了一个类似的问题:
让我知道这是否有帮助,或者我们如何进一步提供帮助。
So breaking it down, it sounds like you also have some MySQL issues.
Maybe we can help you optimize this part of the stack first before you setup a queue? Especially because I'm not yet sure how your application uses MySQL and how or where you plan to queue items to offload from a potential write-lock.
I just answered a similar question a few days ago:
Let me know if this helps or how we can help further.