Which hosting provider do you use for PHP?

[778778]

Hi,

I did not know where to put this question, it seems that here are lots of people that know PHP, so you may know which hosting providers are the best.

My question is:
Which hosting provider do you use for PHP?


I expect that my website will have max 50 users at a time. I am currently using the Godaddy economy plan - I am currently developing the website on it using the previewdns feature. (it gives a temp address of website:

http://www.hostname.com.previewdns.com)

However, the MySQL database is accessed through phpMyAdmin and it is really slow. Go daddy does not allow me to use another MySQL client.

I have read something about bluehost.com that they are recommended and at the same time read a lot of complains from people having their websites "thrown out".

What is your experience on the hosting provider? (I've heard it is the best to host it myself, but I may do it in a later stage if my business grows)

BR,
Nick

 

[Ante0]

I'm using Hosting24.com, I like it.
People have complained about having downtime alot, but I haven't noticed anything like that...
I'm using the Gold plan, which is ~$10 a month with unlimited bandwidth (up and down) unlimited space... Well, it's good for smaller companies.
If you have a big site (lots of users) you should look into something else, or host it yourself.

 

[spamjim]

You should also ask this in a MySQL forum.

If you are looking at discount shared hosting, you are bound to find plenty of people recommending a host and just as many people recommending against that host. That's just the nature of shared hosting.

To get around using phpMyAdmin, consider a program that tunnels to your database. I use SQLyog Enterprise. You simply load a PHP file on your server to act as the gateway. The program connects to this PHP file and you have a nifty GUI to your mysql data.

http://www.webyog.com/

 

[spamjim]

To keep my last post form being a commercial, it looks like Navicat (.com) offers HTTP tunneling as well in a free/lite verison.

 

[Stretchwickster]

I've been using Site5 shared hosting for some time now, and have generally been very impressed.

However, the MySQL database is accessed through phpMyAdmin and it is really slow. Go daddy does not allow me to use another MySQL client.

I downloaded some Windows tools from

http://dev.mysql.com/downloads/gui-tools/5.0.html

for accessing MySQL databases remotely, and I frequently use the MySQL Query Browser tool. They're the best I've come across thus far, which is no surprise really because they're produced by MySQL AB. I went down this route because I got a bit fed up with phpMyAdmin.

Clive

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer." (Paul Ehrlich)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096

 

[Mike Lewis]

Clive,

Those tools you mentioned sound like something I've been looking for.

Just to make sure I understand .... Do these tools run on a local Windows machine, and allow you to query or administer a MySQL database hosted on a remote Linux machine? If so, that could be just what I need.

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[Stretchwickster]

Yes, I run them on a local Windows machine, and by utilising them I can query & administer a MySQL database hosted on a remote Linux machine.

Clive

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer." (Paul Ehrlich)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096

 

[spamjim]

allow you to query or administer a MySQL database hosted on a remote Linux machine?

You are seeking 'HTTP tunneling' with a host that does not allow direct mysql access. The only tunneling you can do with MySQL GUI Tools is 'SSH tunneling'. A host that does not offer direct access probably does not offer SSH either.

 

[778778]

So Spamjim, what you say is:

1) the MySQL tunnelling is one approach, but it may not work will hosts that do not enable SSH tunneling.

2) Although the SSH tunneling is not enabled, the approach with

http://www.webyog.com

(and navicat.com) should work, since they put a PHP script on the server.

I will test the webyog soon, thanks a lot for the recommendation. And of course, you are welcome to continue sharing your opinion on the hosting providers

Cheers,
Nick

 

[spamjim]

You should test Navicat first as it is free. The webyog SQLyog community edition (free) does not offer HTTP tunneling. You'd have to purchase the Enterprise edition to get that. There is also a commercial version of Navicat that adds more features.

http://www.google.com/search?q=godaddy+mysql+http+tunnel

shows others in your same situation. This is not an uncommon issue. There may be other MySQL clients that offer HTTP tunneling. MySQLFront.de (another commercial app) appears to offer HTTP tunneling as well.

All I can say about hosting is to avoid any shared hosting company owned by Endurance (enduranceinternational.com). These are: AccountSupport, BizLand, BlueDomino, DomainHost, eHost, EntryHost, FatCow, FreeYellow, HostCentric, HostYourSite, HyperMart, ImOutDoors, iPowerWeb, iPower, NetWorksHosting, PowWeb, PureHost, ReadyHosting, USAnetHosting, VirtualAve, and Xeran. Endurance shares the same hosting platform for the companies it owns. Their MySQL service has been terrible for the past several years and they are still working on it. Also be watchful for Endurance to buy whatever you think is safe right now. They'll tear it up.

 

[jpadie]

some hosts allow remote access to mysql databases from a known IP address or remote host. Bluehost.com is one such provider and although I have not deployed any live sites there, i have some dev stuff on their servers and have not been disappointed. When I purchased some shared hosting they were charging USD180 for two years supply. storage was something mad like 200GB too.

i don't monitor uptime on these servers but I have never noticed downtime. ssh access is available and although they don't officially 'support' svn and trac there are relatively simple ways of installing these packages in userspace.

overall it sounds like bluehost.com would meet the OP's requirements and i would tentatively recommend them. I'm sure other hosts will also support remote mysql access, too.

 

[Stretchwickster]

some hosts allow remote access to mysql databases from a known IP address or remote host

That's the way Site5 works too. I use their account interface to add IP addresses that are permitted to access MySQL databases remotely.

Clive

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer." (Paul Ehrlich)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096