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
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.
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.
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.
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.
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.
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.
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.
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?
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.
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?
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.
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.
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.
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."
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?
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?
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?
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.
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?
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?
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
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?
