Results 1 to 21 of 21
  1. #1

    UNLIMITED Databases? So What

    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.

  2. #2
    I suppose both of them are limited size and dthe number of them as well

  3. #3
    Join Date
    Aug 2009
    Posts
    79
    Database size isn't calculated by cPanel anyway, I can actually have a very large database after all.

  4. #4
    Join Date
    Jul 2009
    Posts
    639
    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

  5. #5
    Join Date
    Oct 2009
    Posts
    48
    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 :-)
    Thanks,
    Nick Joyce

  6. #6
    Join Date
    Oct 2002
    Location
    EU - east side
    Posts
    21,913
    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.

  7. #7
    Join Date
    Sep 2009
    Posts
    375
    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!=)

  8. #8
    Join Date
    Sep 2009
    Location
    Atlanta, GA
    Posts
    78

  9. #9
    Join Date
    May 2009
    Location
    United Kingdom
    Posts
    1,620
    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!

  10. #10
    Join Date
    Apr 2001
    Location
    Paradise
    Posts
    11,868
    Quote Originally Posted by TheOnly92 View Post
    Database size isn't calculated by cPanel anyway, I can actually have a very large database after all.
    Yes is it.
    Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
    LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
    Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
    DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore

  11. #11
    Join Date
    Dec 2002
    Location
    chennai , tamil nadu , IN
    Posts
    1,423
    Most of the hosting providers allow mysql databases to grow as high as the allowed total diskspace itself.
    Chris, Developer/Programmer,
    Php laravel developers,
    Ruby on Rails developers,
    www.chrisranjana.com

  12. #12
    Join Date
    Nov 2003
    Location
    Marylebone, London, UK
    Posts
    526
    if you're developing a site like facebook/myspace from scratch
    you'd probably avoid mysql anyway, if you were to do it properly.

  13. #13
    Join Date
    Oct 2007
    Location
    Reading, UK
    Posts
    601
    Quote Originally Posted by squirrelhost View Post
    if you're developing a site like facebook/myspace from scratch
    you'd probably avoid mysql anyway, if you were to do it properly.
    You're going to need a database... so what would you suggest using? MSSQL? Oracle?

    Just thinking the kind of people that start Facebook like things are generally students so cost is a big issue.
    Toby H
    Infrastructure Consultant
    SolutionFire.co.uk
    cPanel | VMware | XenServer | cPanel | 3PAR | R1soft

  14. #14
    Join Date
    Nov 2003
    Location
    Marylebone, London, UK
    Posts
    526
    if you use a little toy database like mysql, you
    end up with all sort of sharding nonsense like:
    http://bret.appspot.com/entry/how-friendfeed-uses-mysql

    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.

  15. #15
    Join Date
    Aug 2009
    Posts
    79
    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.

  16. #16
    Join Date
    Jul 2009
    Posts
    212
    Another unlimited thread.
    Some hosts really did not limit the number of datdabase.But they do limit the number of connections.
    HostEase Hosting - Professional Web Hosting
    SoftLayer Datacenter and 99.9% Uptime Guarantee
    24/7/365 Technical Support
    Support Center|Call us at (302)-353-4678.

  17. #17
    Join Date
    Oct 2007
    Location
    Reading, UK
    Posts
    601
    Quote Originally Posted by eric_pu View Post
    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.
    Toby H
    Infrastructure Consultant
    SolutionFire.co.uk
    cPanel | VMware | XenServer | cPanel | 3PAR | R1soft

  18. #18
    Join Date
    Jul 2002
    Posts
    39

    what databases would you suggest?

    Quote Originally Posted by squirrelhost View Post
    if you're developing a site like facebook/myspace from scratch
    you'd probably avoid mysql anyway, if you were to do it properly.
    what databases would you suggest for this purpose?
    Thanks - RevDave

  19. #19
    Join Date
    Nov 2003
    Location
    Marylebone, London, UK
    Posts
    526
    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:

    http://www.readwriteweb.com/enterpri...ase-doomed.php

    http://highscalability.com/scaling-d...b-applications

    http://highscalability.com/anti-rdbm...y-value-stores

    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

  20. #20
    Join Date
    Nov 2003
    Location
    Marylebone, London, UK
    Posts
    526
    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..

  21. #21
    Join Date
    Oct 2009
    Posts
    56
    Thanks for share here

Similar Threads

  1. Replies: 0
    Last Post: 06-18-2008, 06:14 PM
  2. Unlimited or Limited DataBases & Domains?
    By augustino in forum Web Hosting
    Replies: 0
    Last Post: 06-15-2006, 11:27 PM
  3. mysql databases - unlimited
    By sonic10 in forum Web Hosting
    Replies: 4
    Last Post: 05-13-2005, 09:01 PM
  4. Unlimited MS SQL databases
    By PipeTen in forum Shared Hosting Offers
    Replies: 1
    Last Post: 02-28-2003, 07:15 AM
  5. Replies: 0
    Last Post: 02-17-2002, 09:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •