Hi All,
I need you help. I need to design a very big data base, around 900GB or more of information but I never had design or manage this magnitude of information before. I really appreciate if you can point me to documentation to how can do this properly or you can help me with some experiance you have doing this.
I wasn't going to chime in, but after reading some replies I feel I have to.
Bottom line - you need to give more details.
The design of the database will not depend greatly on the amount of data inside it, unless there are operations/calculations to be done on/with it. Most people talk number of rows / tables / read|write operations / joins / etc. when talking database design, instead of size - as with proper indexes, the size can affect things very little.
For example - if you're "designing" a database to store 20GB raw movie files - then you might want to rethink storing the gigs of data inside the database, then suddenly you aren't working with a "large" database at all.
So, if you can't give more details - you're going to have to search on your own. Otherwise, you might want to speak up with some more info so you can get better recommendations.
My only suggestion with the information you've given - is basically what Bastien said - multiple big iron and big fast hard disks / SAN. Other than that, I can only suggest that you design it well :)
P.S.
- I wanted to toss in a troll reply about trying SQLLite, since it "comes with PHP!" - but that's mean
P.P.S.
- I was also tempted to link to a "great tutorial on this" - an arbitrary resume writing tutorial, as a mean spiteful joke about being in over your head - but that's just too mean. It all depends on the system requirements, your budget, and your time.
cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
