Microservice Patterns and Best Practices

State mutation

Suppose we have a table responsible for administering the access level of a user. The table is composed as follows:

ID	user_name	status	user_manager
1	John Doe	admin	Manager1

 

As we look at the preceding table, we see that the user John Doe is an administrator and this status was applied by Manager1. After a period of time, it was found that John Doe could never have been the admin of the application and an UPDATE is performed on this row in the table:

UPDATE status_user set status='normal_user', user_manager='Manage2' WHERE ID=1; 

This change results in some modifications in line with ID = 1:

ID	user_name	status	user_manager
1	John Doe	normal_user	Manager2

 

In this case,