MySQL 服务器磁盘空间不足? [英] MySQL Server Runs out of Disk Space?

问题描述

我们公司的 Web 应用程序每天存储数千名访问者的大量数据点，我们预计硬盘很快就会填满.我们的服务器不能支持更多的硬盘驱动器，我们对腾出一些空间来为我们购买几个小时的空间的小技巧不感兴趣.

Our company's web application stores a ton of data points on thousands of visitors a day, and we are anticipating the hard disks will fill up soon. Our server can not support more hard drives, and we are not interested in little tricks to free up some space to buy us a few hours worth of space.

我们如何解决这个问题?数据库很大，超过 200GB，我们的网站需要可用，所以我认为复制它并将其移动到一个新的、更大的服务器对我们来说是一个不错的选择.此外，当那个服务器的磁盘空间不足时会发生什么?

How can we solve this issue? The database is huge, over 200GB, and our website needs to be available, so I don't believe copying it and moving it to a new, larger server is a good option for us. Furthermore, what happens when THAT server runs out of disk space?

大型网站通常会采取哪些措施来解决此问题?

What do large scale web sites normally do to remedy this issue?

谢谢！

推荐答案

您可能想要研究分离成多个数据库服务器作为分片.您可能需要向应用程序添加一些逻辑，以了解在哪里可以找到一组数据以及如何将查询与来自多个分片的数据连接起来.有 <可以帮助您完成此过程的 href="http://www.dbshards.com/" rel="nofollow">第三方应用程序.

You may want to investigate separating into multiple database servers as "shards. You will likely have to add some logic to your application to know where to find a set of data and how to join queries with data that originates from multiple shards. There are third-party applications that can assist you with this process.

这篇关于MySQL 服务器磁盘空间不足?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！