What database engine is suitable for 10 ^ 10 records?

Question

I plan to use mysql to store my datasets. I have about 10 August (one hundred million) records: ID(int), x(float), y(float), z(float), property(float).

Which database engine is suitable for such InnoDB or MyISAM datasets? Or maybe ndb (I have no idea about scalability or performance)?

I plan to query a static dataset with the following questions:

Choose getRectagularRegion or getPointsInSphere ;

Answer 1

I assume that you are trying to save points in three-dimensional space, and then find all the points within the area.

, 3D- , . .

, , , , " " .

, , , . ...

Answer 2

, . , MyISAM , InnoDB. , MEMORY .