Hosting MySql elsewhere

[bedazzledaz]

Tweet

I have run out of MySQL databases on my hosting account (only allowed 15), now I'm just wondering if it is possible to get a new hosting account that has unlimited databases and be able to connect to them from webpages built on my original hosting.

I'm sure it's an easy answer for some of you?

Thanks
Darren

[Cheapdvds]

cant u just add some more tables to the databases u have?

[ep90]

Yes, you can do this you just use the IP address of the new MYSQL server. Depending on where this is hosted you may intoduce a delay as one server gets the data from the other over the internet.

[Jack Russell]

I have run out of MySQL databases on my hosting account (only allowed 15), now I'm just wondering if it is possible to get a new hosting account that has unlimited databases and be able to connect to them from webpages built on my original hosting.

I'm sure it's an easy answer for some of you?

Thanks
Darren

Hello Darren,

You can have a look at our cpanel hosting packages at UK Shared Cpanel Hosting | PHP MySQL Linux Web Hosting

You can create as many databases you wish and host unlimited domains.

[bedazzledaz]

The databases are for different sites so i'm not sure adding tables to the existing ones is an option.

Thanks for the info, if it's going to cause some delays then I think i'd rather just change the domains across to be on the same servers.

Cheers :tup

[jonsimmonds]

Depending on the scripts used, you can have multiple sites using the same mysql db. eg I have a few wordpress blogs all using the same db, they each have the same mysql user/pass but each blog has a different table prefix

e.g

site one has the prefix site1_
site two has the prefix site2_

Unless the sites were really busy I can't see any issues with going down this route.

While you can have mysql on a different server, if it is not in the same data centre then you will be adding delays to page load time.

As you said you could just move some sites to a different account, which has its own benefits as if one hosting account was to have server issues, not all of your sites would be affected.

[bedazzledaz]

Ah I wasn't aware you could do that, I wouldn't even know how to to be honest either as hosting a few wordpress sites on one database would be a good solution

[affiliatemarketingltd]

if y0our looking for a very cheap solution just to have unlimited mysqlk databases use hostgator .. i pay about $7 ( about £3 ) a month for the baby reseller but the cheaper packages may offer the same

Web Hosting, Reseller Hosting, and Dedicated Website Hosting w/ cPanel - HostGator

[bedazzledaz]

I looked at Hostgator yesterday and was amazed as the pricing, and almost signed up the the business hosting as it was just $12.95/month.

I'll need to do some review research to see who's decent enough.

Does anyone know anything about UK2.net's hosting, reliability etc, their prices seem very good too

[affiliatemarketingltd]

hostgator are awesome
and the fact they are in the states hasnt affected my rankings for sites such as king size beds ( im # 1 )

[Cheapdvds]

Depending on the scripts used, you can have multiple sites using the same mysql db. eg I have a few wordpress blogs all using the same db, they each have the same mysql user/pass but each blog has a different table prefix

e.g

site one has the prefix site1_
site two has the prefix site2_

Unless the sites were really busy I can't see any issues with going down this route.

While you can have mysql on a different server, if it is not in the same data centre then you will be adding delays to page load time.

As you said you could just move some sites to a different account, which has its own benefits as if one hosting account was to have server issues, not all of your sites would be affected.

this is what i meant

[trevHCS]

Generally the web server and MySQL server can be 12,000 miles apart if you wanted, but you'd need to be able to set access rights on the MySQL dbases in the form of the web server IP just so it knows that's legit. Plus check with the DB server hosting company that they allow external connections.

Easier solution is simply to move the sites to a host without the limits, or upgrade your package. I guess you could also buy a second package and use that exclusively for dbases depending what's cheaper (make sure the web sites and dbases are on the same machine).

Of course you could also just go all out and get a dedicated server then it's only disk space limiting you. Or if you wanna be fancy, have a web server and a MySQL server of your own. Or a server farm with clustered MySQL servers....or....


As for hosts - yeah UK2 are cheap, but don't expect any significant support and do expect to have a lot of problems trying to move away! Also not sure what exactly they allow you to do in this line.

Also I'd avoid Fasthosts just for reliability and essentially anyone cheap if this is a business web site as you do want it to stay upright ideally.

Trev

[affiliatemarketingltd]

Also I'd avoid anyone cheap if this is a business web site as you do want it to stay upright ideally.

normally would agree but hostgator are very cheap ( just because of the sheer size of them )
and their support is great & ive never had a site down .. ( although i have through my own stupid cock up ) but nothing their fault

[leaddo]

I would also recommend HostGator very highly. Cheap, yes, but their service has been extremely reliable for the four years I have been with them.
:tup

[bedazzledaz]

Cheers Guys, I'm with 1&1 at the moment and have never had a problem but I don't really fancy doubling my monthly fee just for extra databases when so many other hosts have unlimited for less than I pay already.

Hostgator could be worth a punt at those prices anyway :tup