MySQL Hosting
Nov 5, 2007
We've got 7 dedicated boxes now providing PHP/MySQL hosting for around 200 clients. I've started to think about the future and how we can get better performance and manageability.
Our dedicated boxes are generally:
AMD Athlon 3800
2 to 4GB
80GB SATA in a RAID mirror
We currently run a mix of PHP4 and PHP5 with MySQL 4 / MySQL 5 on Apache2. We don't run email from these boxes, we don't run DNS. We have some clients with SSL WEB-DAV access via a second instance of Apache. They're all physically in the same rack.
Whilst this all works great (touch wood) and we don't have complaints about performance, I wonder if replicating our setup every 30 or so clients makes sense from a management point of view.
Has anyone ever looked at speccing two MySQL boxes in a master slave config, then running all their clients (x number of web servers) through essentially one box. Management of backups and patches would be a lot easier, as would the security management. I just wonder if I'd also be increasing my risk of failure.
View 3 Replies
ADVERTISEMENT
Oct 29, 2009
I'm developing a web application with a php framework.
Our client asked us to give him frequent updates. This means we should do ftp uploads and mysql updates in the domain, so client can see the progress of the web app.
Is there a better way to do this? Maybe a svn hosting that can provide mySQL, domain, etc. and host the fully function app, and allow at same time commits & updates from our developers' PCs, so we can keep the app always updated online
View 2 Replies
View Related
Apr 17, 2008
I take care of a site that is hosted on a godaddy shared server. The site is built around a highly customized version of oscommerce and is almost completely dynamic. I'd say just about every page includes calls to php and/or mysql. The site gets as many as 100 visitors at a time but averages 25-50. The site is getting slower and slower on average.
At times it is good but sometimes pages take forever to load.
Keep in mind that I have never liked godaddy hosting and would not use them myself.
However, this particular customer seems determined to stay with godaddy and is, typically, willing to eat up all their lies and excuses for bad performance.
Lately they are saying that "optimizing" the database would solve all performance issues.
I've written plenty of php for mysql on many servers and this godaddy server is, by far, the worst from a performance angle. So I just don't see how any database maintenance of any kind could possibly make the site fast.
My advice is don't hinge a good and successful business on $50 a year shared hosting.
Much less godaddy hosting. So I suggested to just try another shared server somewhere else before moving to a dedicated server or vps. But by no means should they consider staying with godaddy.
Am I right or wrong? I feel like I've been lied to by godaddy enough to not believe a single word from the mouth of any level 1 support rep.
To me godaddy is a hosting company with enough credibility to get away with lying.
View 10 Replies
View Related
May 7, 2009
Hey all. I have some legacy web applications that requires MySQL 4.X to function. Too much pain to upgrade. Can any of you recommend a VPS linux hosting provider that you can vouch for, who also support MySQL 4?
I am currently using MediaTemple GS which has MySQL 4 support; however, recent problems have made me want to consider other options. Unfortuantely, MediaTemple DV (thier VPS option) does not have MySQL 4 as an option.
Many thanks.
Harrison
View 6 Replies
View Related
May 7, 2009
I have some legacy web applications that requires MySQL 4.X to function. Too much pain to upgrade. Can any of you recommend a VPS linux hosting provider that you can vouch for, who also support MySQL 4?
I am currently using MediaTemple GS which has MySQL 4 support; however, recent problems have made me want to consider other options. Unfortuantely, MediaTemple DV (thier VPS option) does not have MySQL 4 as an option.
View 7 Replies
View Related
Apr 14, 2008
I'm running a VPS at TekTonic.net and so far I have only one problem. I love TekTonic's services in general, but for some crazy reason, I can't get my MySQL server to work.
I've asked MySQL's support staff, and they haven't found an answer to date. I can do just about anything on my MySQL server EXCEPT add/remove a database, which creates a problem. A BIG problem.
what I'm looking for now is a remote MySQL host that will accept connections from my TekTonic-hosted VPS.
View 7 Replies
View Related
Jun 29, 2007
I have a site which has 67000 visitors per day, and around 200 requests in second. On index page I have around 17querys. Site is hosted at some provaider...
Now I have a problem because site is opening very slouly. Yesterday I put mysql on difrent server then apache, and it was working OK since this morning. I have optimize my pages written in PHP for best performans and put out anything that I could. Mysql is set to take 3000 requests in second.
View 1 Replies
View Related
Mar 10, 2009
Does somebody knows free hosting with PHP, MySQL support? And without banners on the page
View 2 Replies
View Related
May 29, 2007
Does anyone know of any shared hosting plans that don't have any MySQL limitations? Aplus.net and Powweb are trying to shut down my accounts because of this problem, and I can't afford dedicated hosting quite yet.
View 12 Replies
View Related
Feb 8, 2009
I have subscribed an account in Powweb but since the Powweb does not allow MySQL remote access I need to find another hosting that allow MySQL remote access.
Wich hosting with MySQL remote access do you know?
View 3 Replies
View Related
Mar 27, 2008
Does anyone have an opinion on the performance of XO's shared web hosting solution when you're using their built-in MySQL capability with PHP coding?
View 0 Replies
View Related
Apr 11, 2008
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
View 8 Replies
View Related
Sep 28, 2007
I have a website that runs off a mysql database.
The first month it hit in excess of 400 threads.
Would anyone know whats the cheapest alternative to run a a site this size. Would a VPS account handle it?
View 4 Replies
View Related
Sep 10, 2007
MySQL 5.0 supports stored procedures -- but is it safe to allow shared hosting customers to have privileges to create them? If the procedures are global, does that mean that:
a) one customer could write a procedure which accessed another customer's data?
b) any customer could call a procedure created by a different customer?
c) any customer could override an existing mysql function in a way that would affect other customers?
d) any customer could write a function that bound to a system library and crash the entire server instance?
View 8 Replies
View Related
Jan 14, 2009
I'm working with a non-profit and we're looking for an inexpensive hosting but we also need to be able to access MYSQL (port 3306) through the internet.
We use Crystal Reports and need to get to the database directly for reports.
View 12 Replies
View Related
Jun 27, 2008
I'd like to have the ability to offer hosting in two geographical and network diverse locations for both Apache and MySQL. Two entirely different instances, with different everything. ie: high avail to the max. Obviously the MySQL part is harder due to the dynamic nature.
I can appreciate the technical aspects of the question - such as data needing to replicate to 2 locations, dealing with static versus dynamic data, etc. In short, there's a few ways this could be done.
I've not been able to find a guide in my Google searches, but I'm sure this is something that has been setup before.
If you're someone with experience in having had set this up, perhaps it would be easiest if we just speak directly and work something out, either via payment or giving you a dedicated server on my network. My AIM name is IGSOBEHELPER.
Please note that I am hoping to start a technical discussion about this, hence I am not posting the message in the employment section. I hope this is not off topic because of this.
View 0 Replies
View Related
Jun 7, 2008
I'm going to be rolling out a php/mysql driven site soon and I'm pretty much resigned to the fact that the mysql performance dreamhost has given me isn't going to cut it, its probably too oversold. Simple one table one column selects can take 30 seconds or time out depending on how badly the server is being hammered. HTTP requests are usually snappy, but the mysql performance is bogus.
What is a good host for me to launch this site with? Storage wouldn't need to be too terribly high, at least initially. I'm tempted by MediaTemple's slick marketing, but I've seen on here that some people have had poor sql performance (contrary to what some personal friends have experienced, so I'm torn). I was reading about downtownhost on here, but their load times seemed slow when I hit a couple domains listed on here that are hosted by them.
This host needs to be located in the US. Honestly, I like dreamhost and their panel, save for the sql sluggishness I'm getting.
View 14 Replies
View Related
Mar 18, 2009
One of my friends uses a popular shared hosting provider, and I was assisting him with a web site issue earlier.
I noticed the following warning in the host's control panel:
"[MySQL databases] may not be used for log evaluation operations, ad clicks, chat systems, banner rotations, or similar applications putting extreme loads on the database under any circumstances."
Is this common at other shared hosts?
View 14 Replies
View Related
Apr 24, 2008
which windows share hosting support apache php mysql?
View 7 Replies
View Related
Jun 5, 2008
I hosted one aardvark topsite @ PluginSpace.com which consist of high traffics (3500+ unique visitors/day). I'm facing max_users_connection for quite number of times and I also have complain to my hosting but I still get no luck, they fix my problem for a short period and the problem appear again after some time.
I rent myself a dedicated server with 320GB Space and 3400GB Bandwith and 2GB RAM. Everytime I manage to get a lot of traffics to my topsite, maybe 100+ online users at a time, tracked by freeonlineusers[dot]com. I'll got these errors. Can anyone tell me what can I do? Can anyone tell me more about how much visitors can a normal dedicated server handle? Is it my script problem or my server problem?
(ERROR WILL POST IN NEXT POST)
can the dedicated server stand many visitors or suppose a normal dedicated server can handle so many visitors or my hosting maintenance is poor?
View 13 Replies
View Related
Mar 17, 2008
Is 40 max_user_connections for MySql typical in a Shared Hosting environment? Or are there Shared Hosts out there that allow more than 40 max_user_connections per account?
View 14 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Jun 16, 2008
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies
View Related
Feb 11, 2008
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
View 2 Replies
View Related
Jan 17, 2008
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies
View Related
Jan 15, 2007
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
View 11 Replies
View Related
Apr 15, 2009
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
View 14 Replies
View Related
Mar 28, 2007
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
View 2 Replies
View Related
Jun 13, 2007
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies
View Related
