How to properly migrate table structures to redis?

Question

MySQL

Tell me how to properly organize the storage structure in redis.
For example, now there is such a table in the mysql database

_________________
| id  |    author   |
-------------------
|  1  |     ivan     |
-------------------

connection

______________________
| id | author_id | text |
-------------------------
| 1  |  1             | bla |

could you tell me how to make such an example in radish? thank.

Answer 1

Alternatively, you can make two sets - authors and publications - to store the keys. And by key, store the content, for example, in json format.

SET author1 '{"name":"ivan"}'
SET publication1 '{"author_id":"author1","text":"bla"}'
SADD authors 'author1'
SADD publications_author1 'publication1'

You need to understand that you certainly lose performance when de-normalizing a relational database, but if the data volumes are small, then this may be acceptable.

Answer 2

What prevents to use a muscle from a node?