SQLite 数据库和网格托管
我正在考虑将我的网站从 GoDaddy 共享托管帐户转移到 Media Temple 网格托管帐户，以应对流量变化。然而，我首先对网格托管设置有一些担忧。
我的网站按每个用户存储大量个人数据（每个用户可能 3-4MB）。按照这个速度，我担心很快就会超过 1GB MySQL 限制。为了解决这个问题，我为每个用户创建了分布式 SQLite 数据库来存储大型数据对象。到目前为止效果非常好。 SQLite 超级快速且简单。
我知道在网格托管环境中读取和写入文件是不同的。我需要知道这个设置是否会导致严重的问题。这些数据库的流量不会（也不会）很高。它们对于用户来说是个人的，并且只能同时接触两个位置（一个最多每小时更新一次数据，一个或多个按需读取）。
我想保留这个设置，因为在 MySQL 数据库上获取额外的空间（超过 4GB）似乎是一个真正的麻烦点。
网格托管会给我带来严重的问题吗？谢谢。
I'm considering moving my site from a GoDaddy shared hosting account to a Media Temple grid hosting account in anticipation of traffic. However, I first have some concerns with the grid hosting setup.
My site stores a large personal set of data on a per-user basis (possibly 3-4MB per user). At this rate I was worried about blowing over a 1GB MySQL limit in no time. To deal with this I created distributed SQLite databases per user to store large data objects. It's worked wonderfully so far. SQLite is super fast and simple.
I know that reading from and writing to files is different in a Grid Hosting environment. I need to know if this setup is going to cause serious problems. These databases are not (and will not be) highly trafficked. They are personal to the user and will only be touched maybe two locations at the same time (one updating the data hourly at the most, and one or more reading on demand).
I'd like to keep this setup as getting additional space (beyond 4GB) on a MySQL database seems to be a real trouble point.
Will Grid Hosting cause me serious problems? Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
只是想更新这一点以供其他人了解...
我联系了 Media Temple（实际上是通过 Twitter）。他们在几分钟内回复并告诉我 SQLite 实际上不是通过他们的网格托管服务安装的。如果您在他们的知识库中查看它，它会显示在他们的 phpinfo() 中，但实际上不起作用。
看起来如果我需要更多的托管能力，我现在会选择虚拟专用。
Just wanted to update on this for everyone else's knowledge...
I contacted Media Temple (through Twitter, actually). They responded within minutes and informed me that SQLite is actually not installed through their Grid Hosting service. It shows up in their phpinfo() if you view it in their Knowledge Base, but it does not actually work.
Looks like I'll be going with a for a Virtual Dedicated for now if I need more hosting power.
这很有趣，因为我在 Grid 上的 php 应用程序中使用了 sqlite3 数据库。工作正常。
That's funny, cause I use a sqlite3 db in my php app on Grid. Works fine.