Tod Harter writes:
> Hi Guys
>
> I've been using MySQL for a few years now, but always on medium sized
> projects. I think the biggest thing I ever did has maybe 200k records in it.
>
> Now all of a sudden I have a client with a requirement for a database that we
> estimate will be in the range of 1 to 4 TERABYTES of data... Now this data is
> largely static (though there will be a few updates and some insertions)
> non-transactional, and needs to be searched on several indexes. Furthermore
> its image data, plus metadata (which the searching is done on).
>
> Anyone have experience with this kind of application? Is MySQL going to
> handle it? What are the upwards limits on scalability? Ideally from a system
> design perspective I'd like to have ALL the data in the database itself and
> in a single set of tables. Unfortunately the images themselves are up to 10
> megs each. Is it even POSSI BLE to use blobs in that context? I know someone
> is going to suggest putting the image data outside the database, but for
> various reasons I consider that a last resort, not the least of which is
> security requirements are so high that running other protocols to access data
> thats outside tables is problematic.
>
> I'd love to hear about other's experience in this area. Thanks ahead of time
> :o).
>
Hi!
A number of our registered customers has database of that size.
But in order to optimise things, I do not think it is wise to store
such huge images in tables.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
