I ventured into the world of NoSQL database and as great as they are the lack of true ACID compliance has been a nightmare resulting in a lot of bad data so I am looking into relational databases.
I am very new into this, but have been looking into MariaDB and Percona clusters with Galera. I see a basic setup is 3 nodes, all which can be read/written to, and all contain identical data in each node.
My question is what happens if I need to scale horizontally:
- slow write/reads
- disk i/o issues
- low memory
- How can I scale to more machines?
- What is the best practice?
I have not been able to find clear documentation on this.