I'm currently working on a mobile app alike Google Maps or Wave, but also including parking. The application its running with MySQL primarily. With at this stage most of our data is loaded by python scripts.
In the desire of having real time data we have been learning about Redis as an option to leverage the publish and subscribe capabilities.
Although, after going through the web there is something still not clear, if we are loading data from python scripts would be required to write for each record into Redis AND MySQL at the same time? or what would be a good choice.
I look to permanently store each record, but for most queries its required to have latest updates, and somehow avoid so much polling.
Redis / New Record Python -> \ MySQL Is this a good practice?