Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Best host for mySQL???

Jul 12, 2008 7:19AM PDT

I am a very experienced web programmer with a small, but critical business database. I am currently with IXWebhosting and I HATE them. I am on some shared mysql server and it is always losing connections to my programs and I know it is because they have too many folks doing too much.

I am wondering what hosting companies do mySQL that actually monitor usage and ping people for being hogs...or if there is some solution where I can ONLY have the mySQL database hosted with one company.

I just can't ever seem to get through to the service folks at IX and I am sick of sharing bandwidth to my critical business info with SQL hogging scripts (blogs, message boards, chat, etc...). I have a DB that is under 2MB and it is critcal that I can connect to it 24-7. I actually would not mind to keep the webhosting with IX. I like the control panel and they are actually not that bad...but the mySQL access is piss-poor.

I would be willing to pay up to $30 a month, but that is probably as high as I could go right now.

Any suggestions would be much appreciated.

Discussion is locked

- Collapse -
One more thing...
Jul 12, 2008 7:25AM PDT

Having access to PHPmyAdmin is a must.

- Collapse -
Just sharing.
Jul 12, 2008 7:27AM PDT

I also use MySQL and program it defensively. That is I never leave a connection open that I don't need. I know some programmers that open a connection when the software starts and close it only when the program ends. Here I use the old method of 1,2,3... or open, do something, close. Repeat as necessary.

Your issue has never bit me.
Bob

- Collapse -
Good point about the closing...
Jul 12, 2008 7:48AM PDT

I will look into that as a possible issue. I am pretty sure it is the host though. Everything will work great for weeks and I am not changing script or anything and then Poof! Sometimes i have problems even logging in to PHPmyAdmin...and I know that is a problem at the Host level.

So I am really leaning to ixwebhosting being the culprit here. I am not a fool and I realize you get what you pay for. I just wish I could find a host that made people responsible for bandwidth when dealing with mySQL databases.

- Collapse -
So...
Jul 12, 2008 10:52AM PDT

Who is YOUR host, Bob? Seriously. I need to find a new host.

Everything on the site is running great now...with no changes by me. I am convinced I need a new host. It just runs great sometimes and sometimes kicks out a ton of connection errors...all while performing the exact same functions and load from me each time. I'm totally convinced. It HAS TO BE THE FACT THAT THEY HAVE THOUSANDS OF CLIENTS ON THE SAME SQL SERVER!

I love IXWebhosting for everything else, but they suck for mySQL.

- Collapse -
Currently...
Jul 12, 2008 12:34PM PDT

I use MySQL running automatic tests on factory floors so this is why I thought to share the method I use to keep everything moving along. Since we can't afford any interruptions my code follows the concept I shared and as you can imagine other tricks to avoid downtime.
Bob