www.webdeveloper.com
Results 1 to 11 of 11

Thread: Database options for (very) large databases

  1. #1
    Join Date
    Aug 2007
    Location
    London
    Posts
    410

    Question Database options for (very) large databases

    I was just wondering if anyone could recommend a server platform for use with very large databases. I'm currently rather well versed with MySQL but if anyone knows of any problems with it's performance when it comes to large database sizes then could they let me know? I seem to remember that both Google and Youtube use MySQL don't they?

  2. #2
    Join Date
    Jan 2009
    Posts
    34
    I would look at the SQL Server 2008 clustered on a Windows HPC server.

    Hope this helps,

    Larry Darrah
    MS Architect Evangelist

  3. #3
    Join Date
    Aug 2007
    Location
    London
    Posts
    410
    Thanks. I'd rather not use anything Windows based to be honest, I have a strong aversion to anything to do with M$.
    What about MySQL's handling of a table of say, 10'000 rows? Anyone?

  4. #4
    Join Date
    Nov 2002
    Location
    Baltimore, Maryland
    Posts
    12,278
    Oracle seems to work well and work well with big chunks of data. And SQL Server does have its limitations size-wise.
    “The power of the Web is in its universality. Access by everyone regardless of disability is an essential aspect.”
    —Tim Berners-Lee, W3C Director and inventor of the World Wide Web

  5. #5
    Join Date
    Jan 2007
    Location
    Wisconsin
    Posts
    2,120
    MySQL should perform quite nicely. It's the DBMS of choice for most web apps, big and small. And most of the caveats that apply to MySQL will apply to any other DBMS as well. I recommend taking a look at High Performance MySQL 2nd ed..

  6. #6
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    define "large database" how many concurrent users? how large is the data? how many schemas?

  7. #7
    Join Date
    Aug 2007
    Location
    London
    Posts
    410
    Thanks for the replies, I will definitely take a look at that book, I'll either order a copy or cycle down to my library. As far as the database size goes, it'll be about 10'000 rows, as far as data size, it'll mostly be quite small, probably about five or six columns, with mostly short text (categories, names), there might be one big column of text, but even so that cell won't contain more than about 300 words.
    I'm not sure about concurrent users. It shouldn't be more than say, 500 but that could be a severe underestimate. At this stage I'm not sure.

  8. #8
    Join Date
    Feb 2003
    Posts
    2,745
    That is nowhere near what I'd call large. MySQL will handle it fine

  9. #9
    Join Date
    Aug 2007
    Location
    London
    Posts
    410
    Initially I thought it'd be bigger, so I decided to cover my bases, as it were.
    Since I am going to use MySQL, what can I use to search it? I ask this because I'd like to use Sphinx or Lucene (preferably Sphinx) but both use persistent processes (which I gather a lot of hosts dislike). I could use MySQL's built in full-text search but it isn't as quick and efficient, or so I've been led to believe...
    Any advice?

  10. #10
    Join Date
    Jan 2007
    Location
    Wisconsin
    Posts
    2,120
    If you get a VPS or dedicated server you don't have to worry about what your hosting provider thinks about running additional daemons. Sphinx is supposed to do a really great job with fulltext indexing. And it's flexible too. I'd grab myself a VPS (at least) and use that in conjunction with MySQL.

    Though for 10,000 rows (or even 100,000 or 1,000,000), I think MySQL's fulltext search would do fine. I think it's mostly a question of flexibility in search features at the scale you're dealing with.

  11. #11
    Join Date
    Aug 2007
    Location
    London
    Posts
    410
    This is true, I could write my own search functions and add functionality to the MySQL full-text searching but I think it'd get slow if I did that and someone's already done it, in the form of Sphinx, so I'm tempted to just go with that anyway. Thanks for the advice. I think I'll get a VPS, I dedicated server is unnecessary at this point.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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



Recent Articles