Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Where to store and back up database for small enterprises

 
Syed Islam
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello I just wondered if someone could give me some advice on how database storage and backing up is done in small enterprises? I know how to create an SQLdump with MySQL.

My questions are...
1) I have never used web hosting companies to deploy a web app and don't know where to start. I know that I have to choose a hosting company that supports MySQL but how much data can they actually hold?
2) Where should I save backups be saved to? The cloud? In personal projects, I'm used to saving it somewhere on the computer.

Is there anything else I should be aware of?
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should probably look through the offerings of a few hosting companies, so that you get an idea of is contained in typical packages. http://www.coderanch.com/how-to/java/ServletsFaq#hosting lists quite a few.

The key to backups is regularity (maybe nightly), and offsite, meaning you'd transfer it to some other place than where the DB is located. At that point I'd probably consider getting a dedicated machine instead of a shared hosting setup.
 
Syed Islam
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the link.

How would the dedicated machine thing work? Could you elaborate on that please?

I wanted to create a reporting program for a small company (4-5 people)
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
With a dedicated machine you wouldn't have to worry about other people running things on your machine (which might be CPU intensive, and so slow down your stuff), and security would be less of a headache (since nobody but you has access to the machine). It is naturally more expensive than a shared server where the cost is split between several users. If You have sensitive data in that reporting app, I would advise not to put that in a shared environment.

For example, if you look at the offerings of DailyRazor, a private Tomcat on a shared machine starts at $10 per month, whereas a VPS solution is at least $60 per month.
 
Campbell Ritchie
Sheriff
Posts: 51447
87
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Question too difficult for “beginning”. Let's try moving it to the databases fora.
 
Syed Islam
Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I forgot to mention I'm seriously considering writing this in PHP instead.

BTW the database won't be massive. It will probably grow by a couple hundred megabytes each year.

Okay I guess this answers most of my questions though so thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic