We have a high frequency data feed from a supplier which we need to parse and store in a relevant location (MySQL, Redis NoSQL).
The collection and parsing must be performed in PHP, for long term data, this should be stored in MySQL as the frequency that this data will be requested will be low. For the short term, and live data, this must be stored in Redis for super high frequency read/writes.?
We want to PUSH all new updates from the Redis store out to the users of our Website so that they are updated with the new information as soon as possible.?
We are completely open to different approaches on this, and we can supply samples of the XML feed and more if you get in touch.? ?
More info happily supplied on request.