• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

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?
0
wangsasoft
Asked:
wangsasoft
  • 2
  • 2
  • 2
2 Solutions
 
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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
 
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now