Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

I have created a website that I know that its database size will increase rapidly. It will become terabytes and by the way I don't want to get a expensive server at first. What is I'm concerned about:

  1. If my cheep server is not enough, how do I move gigabytes of database to another server (considering that meanwhile the website will be in maintenance mode)

  2. Is there any ways (any services) that I can have unlimited database size without worrying about database size and moving it?

PS: I'm using SQL server.

share|improve this question
add comment

2 Answers 2

up vote 2 down vote accepted

If you're talking about dedicated servers, then it won't be such a big problem to transfer the database.

You can use SSH in order to transfer it directly from one server to another, without even downloading it. Then you can import it in a new database from the command line pretty fast.

If you don't want to worry about storage and performances, then go for cloud hosting. There you can upgrade/downgrade your server on the run and even set up dedicated servers for your database only ( which is a really good idea ).

share|improve this answer
    
As I'm really new to cloud servers, how can I set up dedicated servers for database? –  Ashkan Mobayen Khiabani Sep 12 '13 at 19:40
1  
You can try it with Amazon. There are a lot of tutorials related to this, but I gotta tell you it's not easy and you should hire a professional if you're not very good with servers. –  Alex Dumitru Sep 12 '13 at 19:43
add comment

A popular GUI for MySQL database management is phpMyAdmin, which also (obviously) requires PHP to be installed on the server. This program is simply a GUI for MySQL and makes management much more intuitive for those who are not familiar with command line. You can download databases, even in a compressed format, and then upload them again through phpMyAdmin on a different server. phpMyAdmin is very popular and used by nearly all shared hosting companies.

As far as storage goes, I've never used Amazon, but normally there is a price/GB/month for storage. A database ranging in the TB size may require dedicated database servers depending on access requirements. Rackspace has a service called Cloud Sites that gives unlimited storage and databases, but it starts at $150/month.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.