We have big shopping and product dealing system. We have faced lots problem with MySQL so after few r&D we planned to use Redis and we start integrating Redis in our system. Following this previously directly hitting the database now we have moved the Redis system
- User shopping cart details
- Affiliates clicks tracking records
- We have product dealing user data.
- other site stats.
I am not only storing the data in Redis system i have written crons which moves Redis data in MySQL data at time intervals. This is the main point i am facing the issues. Bellow points i am looking for solution
- Is their any other ways to dump big data from Redis to MySQL?
- Redis fail our store data in file so is it possible to store that data directly to MySQL database?
- Is Redis have any trigger system using that i can avoid the crons like queue system?