All geek questions in one place

Distributed Database Solution?

Hey. I am going to create a database that can become really huge.

I use standard mysql for most of my things, but this particular problem will run into TB problems and I will want to execute hundreds of queries per second.

Thus, in addition to developing my database schema so that it is not going to be sorted out, as well as the speed of the hard disk, which is my biggest bottleneck and what solution is recommended for this.

Does it make sense to distribute the database across several computers on my intranet so that it can scale using CPU / Ram, etc., and if there is software for this or a database solution for this?

Thanks for any help! I was looking for questions related to this, and could not find anything so bad if it had already been asked.

+3
source share
4 answers

Database scalability is a VERY complex problem; There are many problems that go into the whole process.

-, ; ( ), ? , BLOB, > 4 ? ; , .

, ? , , . , , , -, (, ), ; (, , ), ).

; ? , .

, . , , , . , , , , . ( , , , .)

+1

, . , MySQL , . , , , Oracle, : " ". , , / SQL-, : " , ". , , MySQL.

+1

NewSQL . Clustrix ( MySQL) , - /, .

0
source

Database scalability is a complex problem, and you should consider solutions that can solve it for you. I believe that MySQL can be used as the basis for solving your problem.

Horizontal scalability; the ability to scale the database horizontally (for example, scaling) is a good technique for solving the problem of very large tables and databases.

0
source

Source: https://habr.com/ru/post/1773287/

More articles:


All Articles