Do u want to run an online e-commerce store? create a forum? or develop the next facebook or myspace? If you answered yes to any of th questions then there are very important factors you need to consider before choosing a host.
You have to understand that there's a difference between Database and database size. UNLIMITED database means that you have as many databases as you want, but of what use is an unlimited database if the disk size for the database is just 50MB for example. Don't be deceived by the number of database a web host company is willing to chun out. Do a little research, ask questions. Afterall you might not need an unlimited database afterall.
Agreed, it’s always wise to research and ask questions to a host before signing up. Any particularly reason though you created a thread about this?
█ bihira.com | 10+ Years of Web Hosting Experience!
█ Shared Hosting | Reseller Hosting | 30 Day Money Back Guarantee
█▀█ cPanel | CloudLinux | R1Soft | Softaculous
█▄█ Find us on facebook and follow us on twitter @bihira
All the hosting companies are using this business trick... else they can't survive. If they allow unlimited number of domains or database or anything.. they will limit diskspace or bandwidth. Its a business trick :-)
Don't be deceived by the number of database a web host company is willing to chun out. Do a little research, ask questions.
Sure, that's a good idea, but you'll often find that there's no mention of a database size limit. Most hosts can't even tell you how much would be too much, as it would vary a lot based on your traffic patterns, application used for the site, using or not using caching features etc.
I know that 1and1 and Godaddy have MySQL database size limitations (100MB and 200MB if memory serves me right), but having well defined limits is not exactly the standard. Database size limits are rather common when it comes to MSSQL though.
That's the problem sometimes, its either they are too shy to ask a question or just felt it wasn't needed. Then be surprised with what they sign up for. To the OP, that's a great reminder for customers!=)
Cyber Wurx - Dedicated Server and Co-location Provider since 1997 Data center fully owned and operated with 24/7 ONSITE Support
Remote Reboots, KVM, custom bandwidth alerting system and more! www.cyberwurx.com or [email protected]
Yeah I agree, although in this instance I do not think it's a problem to say unlimited databases, unlimited FTP accounts etc. Unlimited is the best word in this instance.
Although I do not believe in unlimited bandwidth/Disk Space.
█ Zomex ~ Templates & services for web hosting resellers since 2009!
█ #1 Responsive whmcs templates | WHMCS | Wordpress | HTML5 | Settings area
█ Hire us for responsive whmcs integration - enhance your website using the new "Six" template!
figure out your own custom data, and how to split this
redundantly and with failure tolerance across many
servers. roll your own solution, or start with one of
the trendy 'latest things' like riak: http://riak.basho.com/
thinking small, or thinking 'rdbms' just limits you
eventually, so start the proper way.
Last edited by squirrelhost; 11-05-2009 at 11:45 AM.
Document-oriented database is a very new thing. For us developers, we prefer things that exist long enough so we can search for documentations, tutorials and ask experts for advice easily. Although it's good for catching up with cutting-edge technologies, MySQL is still the best cheapest (cheap as in time and money) choice.
Another unlimited thread.
Some hosts really did not limit the number of datdabase.But they do limit the number of connections.
Surely limiting connections is a sensible thing to do, else one use could use the the max connections of MySQL overall, locking all other users out?
I don't really understand the problem with unlimited databases, personally I always found it useful to not be limited - I used to run a forum / blog / wiki a while back and was hosted on Lycos, they charged per database, left, moved to evohosting on the basis of unlimited number of databases being standard on a plan cheaper than the one I was on, few years later here I am working for them!
I know the limit on database size here is 800mb, purely because anything large causes problems with cpanel's backups, but that is per database, not per account. Not sure what our connections limit per user is off the top of my head though.
All that said, never seen any downside to unlimited databases per account, never had anyone complain about the limits either so this whole thread seems a bit of a nonsense to me.
You'd probably use what's nowadays called 'nosql'.
Much like what we did at yahoo 13 years ago (and they
still use the same today) but nowadays using different
protocols and data types etc. json is much newer but
using it doesn't really bring anything new technically
to the table. Old ideas re-vamped for a newer generation.
Someone said it was all a bit new, and it probably is
for some. Check out some recent discussions:
you can shard conventional databases, but you don't need to be
stuck with them and try to plaster over the cracks, if your
application can do better without them. A few people are trying
to re-write mysql itself for better scaling in the cloud: https://launchpad.net/drizzle
Forgot to mention it all depends on what you want to do with
the data. Take an example, you could store property details in
a mysql db, and query this directly for a property search website.
Or you could collate, sort and index the data and create a shm
file which you could query (shm functions), and then select
specific items of data as required from mysql for display.
Or you could create a similar shm file, but with all the
data in it, not just the results of a so-called full-text
search. Or you could store the original data in 'buckets'
striped across multiple filesystems (or not) and have your
own code to query it as you require.
Years ago we'd have said 'how do we do it?', or 'how can we
do it?' But nowadays people are more inclined to say 'where
can I download it?' and 'how can I install it?' etc..