mysql database with hosting?

MadKad · 06-07-2007, 02:13 AM

Hi

I am not that clever with databases, I was wondering if I could use a database on another host and link my website from the host I have now to that database?

if so can this make any problems?

The host I use is OK and I have been with them along time but they only have 100mb databases, and i want a bigger one, if this can be done can any one recommend a cheap host that is trusting and reliable with a good size mysql database offer?

damien_ls · 06-07-2007, 09:12 AM

It is technically possible to use a database from some other hosting provider. However, this will almost certainly cause your site/scripts to run slowly because you'll introduce additional latency between your webserver and your database server.

The other issue that you may encounter is that most decent hosts will restrict database access to the local server rather than making it open access, since this is a good idea from a security point of view (i.e. less chance of people gaining access to your databases to mess them up).

As a side-note, we don't limit MySQL database size - it's just part of your overall space quota (e.g. you get 1GB for your website, emails, logs, database etc.). This is quite common, so I don't think you'd struggle to find hosts with a similar approach.

MadKad · 06-07-2007, 01:59 PM

ok thanks you two, I am looking into this now

born2win · 06-07-2007, 11:35 PM

I am using this hosting service for my websites. So far I dont have any problem with them.
<spam>
They have few packages and you can select which is suitable for you.

Hahh · 06-08-2007, 12:30 AM

You may consider onthespothosting.net shared hosting plans with unlimited number of databases in them.

charlesgan · 06-08-2007, 06:16 AM

Quote:

Originally Posted by MadKad

Hi

I am not that clever with databases, I was wondering if I could use a database on another host and link my website from the host I have now to that database?

if so can this make any problems?

The host I use is OK and I have been with them along time but they only have 100mb databases, and i want a bigger one, if this can be done can any one recommend a cheap host that is trusting and reliable with a good size mysql database offer?

a website connection to remote database is ok.
in nature the mysql can be remotely connected.
each hoster have their procedure, basically you need to inform support to enable remote access. you need to provide IP ad whitelist.

however some hoster will not allow other server with shared ip to connect to their server. so, there solution will lead to a dedicated IP.

Ahosting.biz · 06-08-2007, 10:54 PM

As rule webhosting company use different servers for Databases and Accounts.

chicgeek · 06-11-2007, 10:08 AM

.amaZe and beliktay, your self-promotional posts have been removed.

You may not recommend your own service outside of the marketplace forums.

alemcherry · 06-14-2007, 03:20 AM

I have tried MSSQL server connection with another host, but that slowed down the page execution very much. It will definitley be slower than local/direct connection in most cases. I wont recommend it, even if the hosts allow connection from outside.

gate2vn · 06-14-2007, 06:41 PM

Database on different server is recommended in a clustering system only, and all they should connect within the same LAN. Otherwise, you will face to network performance issues.