I am building a cluster with nodes on elixir and I am considering using mnesia as a distributed database. The plan is the nodes to send messages among each other with RabbitMQ (AMQP library). In the future more nodes will join the cluster, but the biggest concern is that they are different parties and do not trust each other.
My question is: if a new node joins, runs
iex and just decides to drop a shared table or delete records, does anything stop it from doing that?
sync_transaction for CRUD operations I know that all the other nodes should approve the transaction in order to be completed. But that is not the case when a node can freely decide what to do by running commands in the terminal.
If there is no way of preventing that, are there any alternatives of mnesia for this scenario?