Opinion XO Shared Hosting With MySQL
Mar 27, 2008Does 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 RepliesDoes 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 RepliesLets say you're a customer looking for web hosting, but do have technical experience - you know, you develop your own websites, you've had experience in this sort of thing before.
What if you came across a provider who seemed to offer a good service, they're high quality, they can host your website on their brilliant setup etc... but they do not provide any e-mail accounts with your hosting?
We're developing our own shared hosting setup, our own control panel too. Regardless of the control panel though, we wouldn't feel comfortable hosting peoples e-mail. We have plenty of experience in every other aspect of general shared hosting - but not looking after e-mail accounts nor the associated software.
To be honest I don't think that many shared hosting providers truely handle e-mail properly, and that job should really be left to the professionals.
We could of course guide customers or potential customers on why we won't offer e-mail accounts (i.e. not wanting to offer something we know we can't provide to a high enough standard) and instruct them on how to setup e-mail with another provider (such as Google, who will do this for free with limitations).
The alternative to the above is that we mask in a third party to look after e-mail, i.e. resell someone elses e-mail services as part of our hosting packages. The third party would require API access to setup/remove accounts..
What do you think? Are we just acting stupid trying to provide web hosting without e-mail hosting included? I noticed a while back Dreamhost encouraged their customers to use an alternative e-mail provider!
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 RelatedMySQL 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'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."
Is this common at other shared hosts?
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 RelatedOur company uses ProductCart made by Early Impact (www.earlyimpact.com) for our shopping cart system. People on Early Impact's forums have recommended JoltDigital.com for web hosting for ProductCart.
Has anyone else used/is using JoltDigital.com or know of someone who does?
In your opinion, how are they as a hosting company: Customer support Uptime/reliability Feature reliability (ie- database management, scripting & server languages, etc.) Easy to use...
What is your opinion about hostgator.com for hosting site?
What is your opinion about hostgator.com for hosting site? is it good from small to big sites?
I'm trying to find at least three web hosting companies to choose from to host a Joomla websites on a shared server. Would consider dedicated if the deal was right. I have a friend of mine who wants to create a church website, and is looking for the best deal. I use Netfirms which I have never had an issue with, but I didn't want to be bias, and would like give him other options to choose from.
Is there a good WebHosting Review site, I could check out, or maybe someone could recommend their top three. I reading threw the forums here and I noticed there are not that many complaints with Hostgator. Again, I just want to see if there was anything out there better.
This question gets asked a lot in our Helpdesk and I figured I would post our knowledgebase article here to help anyone else wondering the Pros and Cons of Unlimited Domain Shared Hosting vs. Reseller Hosting. If anyone has anything else to add, I appreciate any feedback on how we can improve our KB article.
----------------------------------------------------------------------
Given the present state of shared hosting, many clients may ask "Why would I need a Reseller account if I can host unlimited Addon and Parked domains within a single shared hosting account?". There is certainly enough Disk Space and Bandwidth provided in many of today's hosting packages, so why bother to purchase a Reseller account?
Many don't realize the drawbacks of hosting large numbers of domains within a single hosting account until they've already packed tens of them onto a single package.
So how do you know whether a Reseller account or Shared Hosting account is right for you? The answer is in how you plan to provide access to others and how "mission-critical" the sites are. You should consider the following factors when deciding on hosting a large number of domains:
1. Who will be managing these sites?
2. How important is site security between sites?
3. Will these domains need dedicated SSLs?
4. How resource intensive will these sites be (RAM, CPU, MySQL)?
In a nutshell, Reseller plans are for those who wish to host websites for other sub-clients and a shared hosting package is for a single individual managing multiple personal domains. We'll go over the 4 points above in greater detail.
1. Who will be managing these site?
If you personally own multiple domains and wish to host them within the same hosting space, you can easily do so with an Addon or Parked domain. An addon domain will allow you to host a new domain within a subdirectory of your hosting space. A parked domain will allow you to have multiple domain names point to the same content. Since addon domains reside within the same user space as your main domain, you can manage all of your domains with a single login. You can see the problem if you want to provide another user with access. Since all accounts are managed with a single set of login credentials, if you give another user access to their addon domain you are also giving them access to your main domain. If you have vital information stored on your main domain and you are hosting another domain as an addon domain for someone else, you cannot provide them access to their hosting without compromising the integrity of your main domain.
When hosting sites as a Reseller, your clients in turn will want access to their account and will want exclusive rights to their disk space and server resources. With a Reseller account, each sub-account you create gets its own username, password, and isolated user space on the server. Individual clients of yours have access to their user space and their user space alone. In addition to the isolation with regards to access concerns, each account also gets their own cPanel access. All of the same great features that you use to manage your sites can also be given to your clients. Next time client Y wants to add an email account, you don't have to do it for them for fear of giving them access to your cPanel, you can simply give them their login details and they can manage their own email accounts.
2. How important is site security between sites?
This is along the same lines as point 1. This is not necessarily related to who you are hosting for, but what content you are hosting. Imagine that you are a webmaster and you are hosting your own personal site-in-a-box community forums (such as PHPBB or vBulliten) on your main domain and a company website for a paying client on an addon domain. It is not uncommon for popular scripts to have security flaws in older versions. Script authors will often update security flaws in later versions of their software. For this reason, it is very important to keep scripts up to date on your site. But let's assume you forget to update your scripts for a couple of months and an unscrupulous individual takes advantage of a well known security hole. Using this exploit, they gain access to your forums and any subdirectories. Since you are hosting another domain as an addon, they now have access to this domain's content as well. A site defacement on this company's site may not bode well for you when they are considering you for web master services in the future.
If these two domains had been separate into two individual users (i.e. two subaccounts created through a Reseller), their content would've been inherently isolated server side by Linux's user management. Sure, your forums still would've been affected by the security hole, but the break-in would've been isolated to your site alone.
Going back to our example, let's say that instead of a corporate website as an addon domain you are hosting an image gallery site for all of your cats. In this case, it may not be a big deal if a compromise in your main domain spreads to your addon domain. After all, they are both owned by you and you're only losing some time and effort to restore these sites from your local backups (which I'm sure you've actively maintained ). But then again, you are losing time and time is money. If these sites had been separated into individual users, again, you'd only have to restore one site's content.
The idea here is isolation. Reseller plans provide you with the peace of mind to know that if one of your users doesn't keep up with their site's content as actively as they should, their actions won't negatively impact the content hosted on other domains. If you and those you host in your addons are diligent webmasters, maybe this point won't have much bearing on your decision. Only you can say for sure.
3. Will these domains need SSLs?
As of this writing, SSL certificates must have a dedicated IP address to be installed. If you are hosting multiple domains on the same shared hosting package, you can still install an SSL (or purchase a dedicated IP address and install one) but you are limited to exactly one SSL on your account. If you are hosting multiple domains on the same package (and consequently the same IP), you must choose which domains gets to have the dedicated SSL.
Sub accounts of Resellers can each be placed onto separate IP addresses and, as a result, can each have their own dedicated SSL installed.
Of course, both shared accounts and Resellers' sub accounts can use the server's shared SSL free of charge. However, some clients prefer to see their domain in the URL bar when they visit https.
4. How resource intensive will these sites be (RAM, CPU, MySQL)?
We've already established that disk space and bandwidth will be no problem. But what about CPU, RAM, and MySQL resources?
It's important to be aware of the resource needs of your website. As administrators, we have to make sure all users "play nice" on the server. We can't have user X eating all of the CPU cycles computing pi to the trillionth decimal place while you are trying to serve web pages to your loyal visitors. We have to monitor the actions of all of our users and in the event someone is stepping beyond the bounds of acceptable resource consumption, we have to take action. In most cases, this entails disabling the abusive script, but in extreme cases we have to suspend the abusive user account to prevent other domains from encountering performance degradation on their sites.
If you are hosting 100 domains as addon domains, all serving nothing but static HTML pages, maybe you will stay off the radar.
But considering most sites are more complicated than static HTML, you may want to be aware of how many sites you host as addons and what content they serve. If you're hosting the latest and greatest Joomla modules, with up to date news feeds, integrated forums modules, polls, blog posts, etc your site can certainly require a degree of CPU to serve your pages. Now imagine you have 5 or 10 of these sites all hosted as addon domains. The resources these sites need to generate their content can quickly add up and before you know it you've got a friendly email from Acenet, Inc. in your inbox wondering why your user is consuming 2 of the 8 CPU cores on the server. That may be an exaggeration, but you get the idea. In the event your resource usage becomes so excessive that we have to suspend your user, now all of your sites are down instead of whichever one may be the direct cause of the spike in CPU, RAM, or MySQL consumption.
If each of these had been separate Reseller accounts, the offending account could've been suspended temporarily while we work through the cause, leaving the rest of your domains live and kicking.
The conclusion here is that you need to be aware of the needs of your sites in a general sense. Hosting unlimited domains within a shared hosting space is certainly a nice feature. For those webmasters who have multiple presences on the web, it's very convenient to be able to manage all of their personal domains from a single control panel. For those entrepreneurs who are hosting multiple domains for other individuals, the features and security associated with a Reseller plan and the inherent isolation of Linux users is a must have.
----------------------------------------------------------------------
I'have a problem with my aps setup on sanbox.When i create on customer ccp when i click finish i have this error. I must only test.
Error: Instance of application with id 124 and version '1-4' can not be provided: There is no resource of class 'Shared hosting Apache' with provisioning attributes 'Web Cluster' in subscription with id 1.:There is no resource of class 'Physical hosting (IIS)' with provisioning attributes 'Web Cluster' in subscription with id 1..If i add the shared hosting apache resourse i get this error : There are no "apache" services that satisfy given attributes: "Web Cluster".
What is the standard number on maximum mysql connection on most shared host providers and which one give the highest number.
View 11 Replies View RelatedI know there are a million "looking for cheap shared hosting" threads. Hopefully my particular values/interests justify a new one.
I'm a (mostly PHP/MySQL/CMS) web developer, using Dreamhost for years (perhaps DH was better back then) to host staging/development sites for clients (once I've developed a client site, I usually make them get their own host somewhere more reliable), as well as for low-traffic sites, transferring files, etc.
What I don't like about Dreamhost:
a) SLOW. my guess is this is 25% web server overselling, and 75% MySQL server overselling. My simple sites are tolerably slow - including lightweight php/mysql sites (textpattern CMS, etc.) - BUT my Drupal and Silverstripe and ZenCart experiments are intollerable (5+ second page loads).
b) funny ownership policies - I can't (easily) create a client FTP user that is restricted to one of my subfolders. Each user = exclusive file/folder ownership.
c) not much else. I seem to get a-little-too-frequent DNS problems/outages, and used to get a-little-too-frequent server lock-ups... but I don't expect perfection from a cheap host. And of course I send my mail through google apps, I wouldn't trust a cheap host with my mail.
What I like about Dreamhost:
a) the control panel functionality. Yes, it's ugly, but god it does a lot of nice stuff that cPanel doesn't (and frankly, cPanel is usually ugly too).
b) the usual: a very low price for unlimited domains, unlimited mySQL, and huge storage.
So, who is my next low-cost host?
a) Interested in MySQL performance/protection - perhaps hosts that put MySQL [and mail] on separate servers, like DH, but don't overload them!?! Do I need to worry about this?
b) I wouldn't mind moving to a reseller account
c) I'd like a progressive control panel; I have clients on medialayer - who use directadmin (nice) - but their pricing structure is a bit tight on domains/db/storage. [As an aside, medialayer provides excellent shared hosting performance/value/support, if you don't need a lot of domains/db/storage]
d) I'd like to stay in the $10-20ish a month range
I am developing a website for a client of mine (the client is a close friend and know's that he is getting a newbie). This site will be larger (project wise) than anything that I have ever done (everything I have done in the past has been FrontPage). We will be using several third party applications that need to run on the server as well as our own custom developed applications. We do not yet know how much access to the server's deeper structures we will need for all of the applications that we want loaded on our server to run. Things we have in mind: oscommerce, mysql, php5, apache, linux, vbulletin, blogger, phpbb, adserver, ect... Would these things run ok on a shared host and would I have full authority to configure them without needing full access to the server? Or will I need access to the entire server (dedicated server) in order to have full customization capabilities? I guess all I am trying to figure out at this point is will shared hosting for a large project limit our abilities to use 3rd party apps, or do most 3rd party application designers build their stuff to work in a shared hosting environment anyway? If we need to get a dedicated server we will, but if we can get away with shared hosting for a while (especially during development when the site will not be generating revenue) it would be nice to avoid the price of a dedicated server. Many thanks for your comments, insight, and expertise! Also, if anyone can sight some common scenarios that may require a dedicated server over a shared hosting plan, that may help me to understand what the limitations of a shared hosting plan vs. a deicated or virtual dedicated server are.
View 2 Replies View RelatedHere is my dilemma, thanks to a thread in these forums I was directed to a hosting website called pc-core.net and I was interested in using them, because it does not appear that they oversell at all. My question is regarding the fact that they have the shared hosting for $12/month with ~5gb of disk space and 50gb of transfer. I then just looked at reseller hosting for the heck of it, and noticed i could get a reseller hosting account with 45gb storage and 450gb of bandwidth for $10/month. Even though I wont be selling hosting, or anything like that, can I use a reseller hosting account like a normal shared hosting account?...just with more space and bandwidth?
View 3 Replies View RelatedI'm new to the VPS scene, so could someone tell me the difference between VPS and say shared hosting or dedicated hosting? Actually I really like to know what a Virtual Private Server actually is.. I know shared hosting is typically a single account on a server with several hundred other accounts which is used primarily for the sole purpose of hosting websites, and I know that dedicated hosting is functionally the same as colo except that you rent the server, instead of having your own purchased server plugged into some network. So what is VPS?
View 3 Replies View RelatedDo website builders generally go with shared hosting or dedicated server? I mean, if they work on several websites would they get a dedicated server instead of shared? From what I understand through reading shared hosting is basically if you only have one website. So one with multiple websites would go with a dedicated server?
View 12 Replies View RelatedI would like to know the different between the shared hosting and reseller hosting?
View 7 Replies View RelatedJust wondering if mysql load balancing is possible in a shared environment.
Example:
I have 3 shared accounts. On one server, I have the write and the 2nd and 3rd server I have the read (select). Or vice versa .. Would it be possible to create a php script to perform this function?
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this.
I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to:
1. execute:
GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa';
[url]
2. Stop mysql server and Add in my.cnf:
[mysqld]
log-bin=mysql-bin
server-id=1
slave-compressed=1
binlog-do-db=user_main
start server[url]
3. execute:
SHOW MASTER STATUS;
we need values of colomns File and Position from output of above command[url]
So my questions are:
Is there any security risk?
Is there significant extra resource usage?
Is this even done on shared environments?
I just come across one.com which is offering free domain and webhost with the setup fee of $ 13.80 ...
[url]
one.com was previously known as B-One
just like to know your reviews about this site ..
I switched to HostGator because they had PDO drivers enabled on shared hosting plans with PHP 5 & MySql 5. The problem is that every time they update PHP (4 times in 8 months now) they don’t include PDO in the build and its takes day to get past level 1 support and get it fixed.
So I’m looking for a “Reliable” host. I had a hard time when I switched to HG finding shared hosting plans with PDO enabled.
Their plans are pretty reasonable. Anybody here have any opinions on them (positive and negative?)
View 14 Replies View RelatedHas any of you ever had any experience with Gigenoc.
They have some nice plans for reseller hosting.
Do you recommend? Their reliability, etc?
I have come across this vps/virtual-grid solution, which at a first glance seems something like a vmvare esx infrastructure: thegridlayer.com does not provide very detailed information but for the little I understood they guarantee you almost 100% uptime because if your vps hardware fails it will be moved to a new node in minutes withouth any intervention. The grid structure also seems to easen scaling.
I am yet to understand what kind of virtualization they offer, but they claim the ability to build your own kernel, so it would seem a complete one.
Prices are quite cheap too: 59$ for a 512mb ram, 80gb disk, 2TB/bw virtual machine... Unfortunately they only seem to run a single prehistoric centos 4.4 distribution, but if you really can compile your own kernel and do all the tweakings would not be a big deal.
I am getting ready to order my server through a reputable company and am new to the colo thing and would like to here from some others letting me know if this server will be plenty for what I want. I have been using a dedicated server with Liquid Web for the past two years. The server I have with them has the following:
Processor: Dual Opteron 242
Memory: 2GB DDR Registered ECC
Hd1: Dual 120GB IDE / Hardware Raid 1
Hd2: 120GB IDE Backup Drive
RemoteBackup: 50GB Remote Backup
The server I am ordering is listed below. This has more memory and hard drive space then my current dedicated server. I am pretty sure that the 2 dual Xeon Woodcrest 5150’s will blow away the 2 dual Opteron 242’s. Am I correct in assuming this?
I would like an opinion on with this is a good server or is it to muck or to little. My train of thought when building and ordering this server was to build one that had plenty of memory and storage along with a good processor that I would not have to worry about for a while. I am thinking of changing my hard drives to 250G hard drives. So was this a good build for my train of thought?
2 dual Intel Xeon Woodcrest 5150 socket 771, 4x 2.66Ghz/2M L2 cores
Supermicro X7DVL-E dual socket 771 server board, Intel 5000V chipset
8G (4x 2G) ECC FB-DIMM DDR2-533, 2x open
2x Western Digital 160-Gig SATA-II RAID Edition, 7200rpm, 16M Buffer
2x Western Digital 160-Gig SATA-II, 7200rpm, 16M Buffer
on-board Intel ICH7R 4-port SATA controller
on-board Intel dual-port gigabit NICs
on-board ATI ES1000 Video, 16M
24x slim CD-ROM, no floppy drive
SuperMicro SC813MT-420B 1U Rack-mount Chassis, Black
4x Hot-swap HDD Carriers & 1x4 SATA Backplane
supermicro 1U 420w Power Supply
1U Mounting Rails/Brackets Kit included
Anyone has an opinion about the following processor:
CPU Intel Xeon Quad Core 3210
I have 2 dedicated servers and one VPS with liquidweb. Lately I am facing quite an issue with support and I think I am posting 2nd time about liquidweb support.
Its all about my VPS, which use to hold 45 clients consumming around 50 % disk space and around 30 % bandwidth.
On 3rd of April VPS started to shoot emails about services failure and continuously went for 2 days. Then on finally 5th April, it went down. So I reported this to liquidweb support by creating a ticket(I created the ticket by shooting an email to support@liquidweb.com not by logging into PIMS). I got an reply in around 1 hr 20 mins that server is up. So i checked it and yes it was up, but with lots of issues. Still were getting service failure emails as they are failing and above all my root password stopped working. So couldn't login into WHM that time.
I reported this back on 6th April. No reply on 6th of April. On 7th april, I sent a reminder about the issue. They repiled by asking for my last 4 digits of credit card for verification purpose (Designatation of that person was written Web Designer) . Now when I ordered this using paypal, there is no question of last 4 digits of credit card. So I politely replied them back within 4 hours that I have used paypal for ordering the VPS.
They didn't reply back on 7th, not on 8th. Finally on 9th, when I lost few customers because I can't login into WHM, I wrote a bit stringly worded post in that support ticket.
To quote myself.....
"OPPS!!!....This has been a tremendous lack of response from you guys. It seems
that you don't have support guys anymore. I have lost few customers
because I can't login into my WHM. And it seems that you have changed my
root password and now not letting me know about this.
Suddenly one web designer is replying my ticket.
Whats is happening there?
Let me know my root password immediately.
Thanks
Krish"
Now after posting this reply, I decided to call them. So within 30 mins of this post I called them. Jason, a system admin replied and we talked politely about the issue. He accepted over phone that it was big mess.
Why big mess?????...because when he restored my old password and I logged into WHM....I don't see any account left . All data lost...everything gone as it appeared there is nothing left.
So he took up the issue of restoring account. He claimed that server was rooted. Now how come after so many days and communications they discovered my server was rooted?
Then he started restoring accounts....all accounts came back but with a loss of around whopping 80% loss of data. Most of customers started complaining about loss of emails and data. On 10th again I reported them about such loss and mysql which was not working. They fixed the mysql issue, but no database was left.
Then I got busy on 11th, could not follow it up as I should have been doing. But still as I was waiting replies from my customer about how much is the loss (I was telling them that we should be able to get them back from backup).
So I reported back to support on 11th as follows...I quote myself...
"I am waiting for reply from them. I noticed one thing. That the content is not
restored properly...as there are only 13% of space used right..which should be
around 50%."
On 12th I got following reply...I quote...