Will MySQL be able to handle this type of data warehouse database? We will make sure that the hardware can handle...
either database. We will store 90 days worth or data and we currently partition the data by day. We roll over the data at the 91st day so we can have the most current day. We do not have any MySQL expertise in-house. In the future we will like to insert the data real-time. Today we use temporary tables and do not let our customers see the current day's data.
Dig Deeper on Enterprise applications for Linux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.