We have very important data stored in MySQL database. 200 million records per year. we have now 5 years of such data. What we need is to have a good option to store them and retrieve them via API very fast. Note that, The table which contains this data also needs to join with other tables in order to get the correct results for reports we have.
A good data warehouse technique is expected to suggest and help us set up it.
Looking forward for your response.