如何处理MySQL繁重的流量? [英] How to handle MySQL heavy traffic?

问题描述

拥有一个拥有90,000个帐户的MySQL站点，您需要将流量分成两到三台服务器，如何做到这一点，该站点在MySQL上运行.该站点对数据库的查询很多，插入"而不是选择".如何将流量分成几台服务器，并在可能的情况下如何优化数据库(以减少链接数)?

Having a MySQL site with 90,000 accounts, you need to split traffic into two or three servers, how to do this, the site runs on MySQL. The site has many queries to the database, more Insert than select. How to split this traffic into several servers, and if possible optimize the database (to reduce the number of links)?

我还要补充一点，我这次不想更改数据库以更好地使用例如MemSQL，因为我不知道它以及当前的发展.将来我有这样的打算.

I will add that I do not want to change the database for this time to better e.g MemSQL because I do not know about it and the current development. In the future I have such an intention.

推荐答案

您的解决方案是使用数据库虚拟化，您可以为此使用PAR弹性软件.

Your solution is to use database virtualization, you can use PAR elastic software for this.

许多人认为必须使用NoSQL数据库来提高数据摄取率.这根本不是真的.

Many consider it essential to use a NoSQL database for high data ingestion rates. This is simply not true.

虽然确实存在，但云中的单个MySQL服务器无法高速获取数据；小批量插入时，通常每秒不超过几千行，而使用较大批量时，通常每秒不超过几万行.但是，来自 ParElastic 的数据库虚拟化软件能够将MySQL服务器扩展到成千上万个，甚至可以扩展到每秒 1,000,000(一百万)行

While it is true that a single MySQL server in the cloud cannot ingest data at high rates; often no more than a few thousand rows a second when inserting in small batches, or tens of thousands of rows a second using a larger batch size. However, database virtualization software from ParElastic is able to scale MySQL servers to hundreds of thousands and even more than 1,000,000 (one million) rows per second.

这篇关于如何处理MySQL繁重的流量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！