How much RAM and CPU core (@ 1ghz) do I need so my server can handle like 1000 requests per second (which 900 of them are read and 100 are write)?
I have a table with maximum 1000 rows of data (under 100 mb).
And any tip about storage and or bandwidth?
Are you planning to deploy everything on one machine? There isn’t going to be a magic number for this so there will be some experimentation needed but I would probably start with at least 4GB of memory and test from there.
For storage you would typically want to make sure you have an SSD and the space will depend on usage but a lot them can scale as needed as well.
Are you sure?
I’m talking about 1000 req/sec!
Currently with baserow.io server I always got server error and it get down. (And I’m not talking about 20 requests throttle, but whole server down).
And I’m sure baserow.io use lot more than 4 gb RAM.
That is where testing comes in, there will likely be more to it than just server resources like tweaking OS tcp/ip settings, the database under it and a bunch of other things.
I would really start with 4GB, do the testing and see where the fault comes from (resources, the container, the database under it, reverse proxy if any) then plan from there.
There is also the deployment method, if you are running reach component on different machines to allow for easier scaling then you would need to think about connectivity links and how they interact. If you have everything on one machine you will also need to think about the other services use the resources.