I need to create a database system with different tables. I decided to use CockroachDB to do that.
I have a table user with several information about my users, I would like to fragment into several shards, this user table based on an attribute of the table (in my case, the region of the user)
For example, in my user table, I have 5 users, 3 are from Europe and 2 are from Asia. In this case, I would like to have 2 fragmentation (and maybe, to store those fragments in different nodes).
How can I fragment a table in this way with CockroachDB?