How Can I Design a Large Database?

Asked By Michael C Bates 10 points N/A Posted on - 11/14/2014

I am thinking of designing a very large database that can handle close to a million people. What best policies do I need to consider when designing such a system? Which potential bottlenecks does such a large systems present to designers and coders? How do I resolve the common bottlenecks associated with this kind of project?

• Status: Open
• Question Views: 598
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Tanthle Yak 0 points N/A #190736

How Can I Design a Large Database?

The factors that define the large databases are software, hardware, data volume and throughput. The goal of every database should be efficient and scalable. When you design a large database, database architectures should be chosen in such a way that it does fast operations. An expert DataBase Administrator(DBA) will have experience in scaling the databases.  This  can determine the bottlenecks of a large database. The DBA should address the performance bottlenecks, cloud computing related issues and the availability issues while designing a large database. There must be multiple servers to handle the complexity of the backups. Ensure to include some business plans in your database design such that it helps in backups and prevention from data loss.

 

About Tanthle Yak

Questions
0

Answers
100

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 01/02/2015
• Question Category: MySQL Server