Hi, I have a hosting user account on webfaction. My memory limit is 256 M and my disk space limit is 110 GB. For my research project I need to host a huge database (10 to 20 GB) with time-series data and also a xml/json web services API and a php data viewer application. What is your advice about the database setup:
Specifically could you explain to me what is the difference between the shared mySQL database and the "local private mySQL instance" in terms of memory usage. I am asking, because I don't want my big databases to cause adverse effects to other users of webfaction hosting. Thanks, Jiri Kadlec asked 05 Jul '13, 07:41 jirik |
When you use our shared database service for your databases, its memory usage is not counted towards the RAM quota of your hosting plan, and your database queries run in the same kernel control group (cgroup) as all of the other shared database users. When you use a private database instance, the database server is a long-running process which runs via your main user account. The RAM it uses counts towards the RAM quota of your hosting plan, and runs in your account's cgroup. The actual memory usage is dependent on the amount of data that you have in memory at one time. There's no way for us to know what that would be - you'd need to set it up and test it yourself to make that determination. If your main concern is disrupting other users, then I recommend that you use a private database instance, since the kernel would be able to manage your resource utilization separately from other users. answered 05 Jul '13, 13:39 seanf |