Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need guideline to setup DBMS(MYSQL or SQL Server 2008). The database size is expected upto 80-100GB in next few months. One main table will contain textual content like essays. Can MySQL handle such big size database and can full text search really work for me for such big database. Should I consider MySQL or any other?

Thanks

share|improve this question
    
you could consider Solr, which is useful for storing and searching text documents. can be clustered among multiple machines. –  Neil McGuigan Apr 17 '13 at 18:59
add comment

migrated from stackoverflow.com Apr 8 '13 at 0:08

This question came from our site for professional and enthusiast programmers.

2 Answers

Can MySQL handle such big size database and can full text search really work for me for such big database

What is big?

SERIOUSLY.

Let's have a look at modern hardware. Databases typcially are large when they are larger than the available RAM.

100gb - hm.

128gb memory was not particularly large last year.

Get a decent modern XEON, put 256GB memory into it.

Just checking - supermicro.com, website has a "featured motherboard". "Supports up to 256 GB DDR3 ECC". Ok, 128gb won't be that expensive.

I have a 64gb database server here that is 5 years old. I have a desktop server that has 64gb memory (micro atx board). Last time I checked, lower mid range servers (two sockets) go to 512gb memory.

That means that by all accounts, 100gb is not large.

share|improve this answer
add comment

There are a number of variables that go into database performance. However, MySQL is up to the task you describe given adequate hardware.

I agree with the comment about Solr. It's a great tool.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.