What criteria to use when looking for the right host (5.)

Well, let’s cover the last few of the more valuable features you should be thinking about when trying to estimate what you will consider important once you start your hosting search. I think, that all of you really like those sites with  “memory” . They know what you like, who you are and what you want. This miracle could be done by “simple” cookies file, but it also could be the work of a Database. Where I am absolutely sure a database is at work is when trying to run a blog, CMS [e.g. Joomla!] or your own database utilizing web site. And as you might already think, this last article will start with databases.

I would rate this feature as one of the more important ones, as it’s not that important, that you don’t have 3000 e- mail account’s , but it’s definitely very important. If you are not able to create a database of your “dreams” for your web site your whole project is destined  to failure. It will not operate without it and thus it’s more important than email accounts

The database

Hosting companies do offer you the option to have a web site with a database support. This database thing is very important if you plan to deploy a web site with visitor registrations, clients orders, or a site which would publish some kind of content and would utilize for example a software like WordPress, Joomla!, e107.org etc.

There are no so an yoptions in the world of database and most of the time you will be offered three options:

• MySQL [on Linux plans, maybe on Windows]
• MS SQL [only on Windows]
• Postrge/SQL [Linux...]

And they all have something the other one does not have, or has implemented in some other way. It’s software and it’s produced by different companies and thus they can’t be too similar

All you should care about is to make sure you know what type of database system your web site will need to be operational as there is nothing worse, than buying something to just find out, that your site can’t even run with this kind of software

Database – size, administration, numbers

As said so many times before – the number of databases and the rules governing their usage differ from company to company and thus I can’t give you any “this is the one solution used by all” thing here I can tell you, that most of the time you will be given the right [option] to have somewhere between 10- 30 databases created. The problem is, that companies tend to restrict the size of one single database [e.g. 1and1's used to limit 1DB to 200MB's], or all your databases share the amount of disk space allotted to your account and thus limiting the amount of data you can store on your server.

The usual way of administering your database is trough a web interface, but I can ‘t say it’s the only one. You’ll maybe run across another option as well

Conclusion & opinion

You should always know what number of databases you will need and what size they could rise to. You as well need to know what type of database you will need as different vendors sell slightly different implementations of the same standard

[ad#Adsense360]

It might not seem as a very crucial thing, but believe me you want to be sure your site will be able to operate well. I have not come across to many hosting companies offering other DB system then those mentioned. In fact I have not seen any others at all, although there are far more DB’s than those three… .

I would rate this feature as one of the more important ones, as it’s not that important, that you don’t have 3000 e- mail account’s , but it’s definitely very important. If you are not able to create a database of your “dreams” for your web site your whole project is destined  to failure. It will not operate without it and thus it’s more important than email accounts

Some examples:

• WordPress, Joomla!, e107.org, Drupal other CMS’s = MySQL [most of the time the database of choice ]

To remember:

• number of db’s you need
• size your db’s will need
• db type your site will be able to be run with

No related posts.