How to design data storage with the ability to roll back the data version?

Question

PHP

Hello! Information about products is stored in redis, there are several keys for one product. There is a need to store several versions of product databases so that you can switch between them at the same time (rollback). What is the best way to store these multiple versions of product databases? But what if the task is the same, but the information is also stored in mysql (one table, where the terms are the goods, the columns are its properties).

Answer 1

To get an answer, you need to correctly ask the question: You did it!

What is the best way to store these multiple versions of product databases?

Multiple bases!

Answer 2

For example, when updating a product, first write your product and version number to another table tovar_backup,
and store the latest version and its number in the product table itself.