Hosting For 4GB Website + 2GB SQL Database
Aug 9, 2008
I have a friend who has a dedicated server right now that uses a good 4GB for all his website content. (not streaming media but just a whole bunch of scripts and etc. well thats what he tells me). And so anyways, his SQL database is about 1-2GB. And he is not too sure about his monthly traffic but its a social networking site with a good amount of users (so its actively used by many users). Would it be necessary for him to have a dedicated server or do you think he could cut costs with a shared hosting account at like host gator or some other shared hosting service like that? I guess my biggest concern is his current database. A lot of shared hosting companies (from what i saw) offer unlimited Mysql Tables do they have size limits? And does a bigger sql database drastically effect the performance of the overall server?
View 14 Replies
ADVERTISEMENT
Oct 26, 2007
We have 2 linux servers directly connected by Gigabyte Ethernet. On a First server (192.168.0.1) we have a website (PHP5, Apache2), on the Second server (192.168.0.2) (CentOS 5 64bit, kernel: 2.6.22.9xe5u) we have MySQL 5.0 Database. A website from a Fist server connects to the database on the Second. The problem is that this system is very slow. We triet to move our website from First server to the Second and it works 50-300 times faster.
This is very strange, because when we print SQL queries of a website we see that some similar queries which are not dependent on a data or where there are very small amount of data, are executing in very different time.
For example:
SELECT t.*, tl.title, tl.content FROM site_tree_public AS t INNER JOIN site_tree_public_localdata AS tl ON t.id=tl.site_tree_public_id WHERE t.hidden='0' AND tl.lang_keyword='eng' ORDER BY parent_id, orderid
0.61763
after refresh 0.00365
another refresh 0.86579
another refresh 0.00302
another refresh 1.22748
Another example:
Four similar queries to four different databases (shemas), on one page load:
SET NAMES utf8 0.00021
SET NAMES utf8 0.00012
SET NAMES utf8 0.00012
SET NAMES utf8 0.20491
When we moved website to the Second server these queries are executing in a good stable time.
Also some following problems were noticed:
1. While connecting to the FTP, server slowed down and sometimes connections were dropped
2. We tried to install Ubuntu unsuccesfully - the network didnt work at all, then we moved to CentOs 5
3. When we first installed CentOs 5 with standart kernel we had experienced problems with network (IP's aliases just didnt work) then we installed newer kernel and the problem was solved.
first server - SM-XE2, SuperMicro 6014H-82, Dual Xeon 3.4 Ghz, 4GB DDR RAM, 2x72GB U320 SCSI RAID1, Dual Intel PRO1000, 1U
second server - SM-XEW, SuperMicro 6015P-8, Dual Xeon 2.0 Ghz (Woodcrest 5130) , 8GB DDR RAM, 2x73GB U320 SCSI RAID1, Dual Intel PRO1000, 1U
So the question is - what do you think about the problem? Did you use such a system - when a website is on one server and the database on the second? And what was the experience? Could it be kernel problems?
we think that it might be problems with kernel that dont work properly with network, please comment this.
View 2 Replies
View Related
Nov 7, 2009
i transfer all customer in new server
and restore all backups
but all website VB appear Database error
although mysql work very good
View 3 Replies
View Related
Apr 19, 2008
have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!
View 14 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
May 18, 2014
When I use website copy function the website files are copied to another domain but the database remains on old site. I use this function to move the website from devel state to the production state. All sites work fine but when i schedule the backups all databases are saved on old domain. How to move the database on production domain?
View 1 Replies
View Related
Aug 31, 2014
Plesk 12 - Domain with no hosting I'm getting error when changing hosting settings to Website Hosting
Error: Some fields are empty or contain an improper value. ('home' = '')
View 3 Replies
View Related
Jan 29, 2015
I have a problem with Parallels Plesk v12.0
Hosting type on website became "No web hosting."
When I try to change hosting type to "Forwarding" it changes ok.
If I change hosting type to "Website hosting", I get message "The hosting type for "website name" was successfully changed.", but hosting plan still stay "No web hosting"....
View 3 Replies
View Related
Jan 10, 2009
Is it possible to buy a dedicated server off eg Dell and host your own website on it from home ie with a www prefix to the url- Do ye know any good tutorial on it. Would 20Mbit bandwidth be enough bandwidth for a fairly busy php ,mysql site? Completely new to this.
View 4 Replies
View Related
Jun 9, 2009
How to check web hosting of any Website and which hosting is more valuable and why?
View 24 Replies
View Related
Aug 19, 2008
I wan't to start a PTC website. Therefore I need a host with a very fast and stable SQL server.
I don't need much space.
Wich one should I take? There are hundreds of them...
View 14 Replies
View Related
Sep 15, 2008
Whats the benefit of putting up your own web hosting server in the company to host your website?
Obviously its going to be more economical and Im sure there are plenty of documentation online on how to do this.
why most people wont go with this approach and rather find a hosting company to do this for them instead.
View 10 Replies
View Related
Sep 20, 2007
Why are all the established and turnkey websites trying to sell you some cheap hosting package and always say there is something like a $8.88 domain renewal fee and all that junk?
I'm just looking for a template to setup, already with content and whatnot and I can't find any, none! Does anyone sell just templates?
View 8 Replies
View Related
Feb 27, 2007
Is there some tool I can use to know the hosting of another website?
View 12 Replies
View Related
Apr 14, 2007
What is involved in hosting a website from a local PC?
I have developed a site on 'localhost' on my PC and am running ISS, I also have a domain name plus forwarding. My internet connecton is broadband and I'm using an ADSL/Ethernet router. How do I connect it up?
View 5 Replies
View Related
Jan 30, 2009
A few days back i had made a post asking about which would the best host for a dating website that me and a couple of friends were planning to start. Thanks alot to everyone for the answers.
However now we have decided to go with a gaming website, as the idea appeals to most of us.
The concept is to have a real time online game running on the server 24X7, people can join any time they want and leave any time they want, the game would still keep progressing. My main concerns with such a site are:
1. Bandwidth : As people will be online for a long time playing the game I am guessing we will need good amount of bandwidth
2. Server CPU : Will we end up eating lot of server CPU as the game engine will be running 24X7 on the server? What kind of implications does this have? I dont see any CPU specific details in the hosting plans i have seen so far.
Please advise on the above two. What kind of hosting should I be looking for? Hosting budget is 30$/month (max).
View 6 Replies
View Related
May 7, 2008
I am re-developing a website that launched 8 yeas ago. When the site launched it was developed in TCL and had an Oracle back end. The site's previous developer is still hosting the site on his server.
Long story short, we are re-developing the site on a new server at a different location. We'd like to re-launch on the old server (to help maintain Google search rankings), but we are developing in .Net and SQL. The old server is Linux. We want to maintain our ranking on Google since we are "Top Ten" on more than 20 great keyword phrases.
If we use a DNS forward from the old IP to the new one, are we going to loose rankings on Google? Obviously yes. But would it be beneficial to help the old developer buy a SQL server so the DNS forward is to a server 2 feet away as opposed to across the country? Does Google treat these equally?
View 0 Replies
View Related
Apr 21, 2008
I have started a new image hosting website and currently i alloted 7 GB Disk Space and 30GB BW. I know it will not be enough after the site get famous. So which host i can go for to be in a safer side with my image hosting website?
View 6 Replies
View Related
Jun 1, 2008
What is the Best hosting for a clan website?
View 8 Replies
View Related
Nov 19, 2007
I believe it's ev1server.net But i'm not sure if it's correct or not. This website is jacking some of my cursors. He/she doesn't even rename the files that he/she takes. It's the exact same filename as the one's I have on my website. Also when you look internally you can see information about the cursors. It says something like created by, animated by etc.
I just want to contact his webhost to remove my cursors.
View 3 Replies
View Related
Jul 2, 2007
A friend of mine and I are developing a new File Hosting website. Growth of data is huge and we'd need a way to welcome million daily users.
What do we need? We have already 4 servers on hand ready to go. We are coding a kind of multi-server script to make our life easier.
What about the specs we'd need for our main server? Do we need a load-balancing system?
And for hardware replacement, is there anyway to get life easier if any hdd (hard drive disk) are broken?
View 1 Replies
View Related
Jan 19, 2008
I am looking for free adult web hosting, as I am doing a site for an escort. It's fine if it has the following for her site:
escortName.someDomain.domainSuffix
Also, need CGI, PHP, MySQL, good amount of web space & bandwidth as she may want a video or two -- besides gallery images -- to be put up, etc.
View 8 Replies
View Related
Mar 31, 2009
I am using GoDaddy to host my two websites using their deluxe linux hosting plan. It allows me to host multiple websites using one account.
Where I have one domain name registered as primary domain and mapped it to root () and the next one is I have created a subfolder named test inside root ( est) and mapped to it.
Now in browser if I put, firstsitename est it shows the second website.
My question is, i) How can i block that? ii) Will this kind of hosting give any problem with SEO?
View 5 Replies
View Related
Apr 21, 2009
I would like to create a website to a customer and provide domain/hosting with the package.
do I need to have a reseller account to do this?
I will charge him one time fee for the design which includes hosting.
do I need to tell him it's for one year after that you are on your own,...
View 7 Replies
View Related
