Database Server Questions
Hi all, me and team planning to build web apis service.
i have no experience with this kind of website before, i usually handle website with large traffic not database server.
for starter one of table could be have 1-5 million of rows records and on future maybe have 10 million record. currently we planning use mysql, because im never used nosql / mongodb before. for concurrent process to write to mysql maybe 250-1000. and for query i need executed time average is under 500ms.
my question is what CPU model do you recomend and what backup method do you recomendation, i know its not possible with mysqldump because it will take a much time. and maybe any advice that maybe you ever have experience with this kind of web apis service.