Data MySQL can support

Does MySQL support data upto 500,000 TB? If not, which database support upto that amount of data? Where can I find information about data support size of Database?
wangsasoftAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johanntagleCommented:
500,000 TB???  I don't know the answer, but I'm curious why you need to know.  According to http://www.focus.com/fyi/10-largest-databases-in-the-world/, the biggest so far 2.8 Petabytes, or "just" 2,800 TB.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the question needs to be clarified on 500'000 TB for 1 single table? or for the hole db?

in short: the size of the largest table is limited by the OS' filesystem, and not so much by the db engine you use.
after that, you will have considerations on the primary keys etc ...

so, if you create 1000'000 tables with 500 MB each, or 500'000 tables with 1 TB each (or some other variants), it would work with MySQL as well as any other db system, in general.

however, I concur with above remark: 500'000 TB? for storing what?
because that is also part of the question: is it text or binary? what would be the biggest size for a single "blob" part?
0
wangsasoftAuthor Commented:
Thanks for your reply. Anyway, I got the project from Thai Government and the project specification indicated that I have to use the DBMS that can store up to 500,000 TB! I just want some proven to show to the project owner that MySQL can store up to 500,000 TB even it's not happen in the real life. Or if MySQL can't, can MS-SQL or Oracle can handle that or no!

How do u think the way to prove to my customer regarding this?

Thanks
Withoon
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
to prove this, you first would need to have the hardware for this, and the os installed for it.
then, you need to have some specs on what the database needs to store, so that you can build a schema for it, and based on the schema, fill up those 500K TB on a real machine (with sample data) and see if this works.
if then, you can still run queries etc, you have the proof.

note: 500K TB of data means you need at least 2-3 times of the disk space, for indexes, backups etc ...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wangsasoftAuthor Commented:
Thank angelIII for your advice. So what you mean MySQL can handle upto 500K TB, right? No limitation on its capacity. The limitation is hardware only.
0
johanntagleCommented:
In theory MySQL should be able to handle it, but you will need to employ many techniques to make it reach that.  I don't see any way you can do this without using things like partitioning, sharding, clustering, etc.  You might want to have a MySQL support company such as Percona or, of course, Oracle's MySQL group, to back you up.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.