I am planning on doing an internet connected temperature monitor (among other data) at multiple locations. At two of the locations I want to use a Raspberry Pi to display the information. The information at all locations will be gathered by a network connected Arduino.
My question is, would it be smarter to store the data on a shared hosting provider, in say a MySQL database? Or store the data locally on the network at one of the locations' raspberry pi?
I do not think I want to bog down a raspberry pi too much with php and MySQL, but at the same time I know shared hosting is not the most reliable. I was also considering storing the information in a Google drive spreadsheet and use the API to gather the data.
I would like to keep costs down on this project so what would be the most reliable option/smartest solution?