I am looking for information that I am not able to find about MySQL cluster.
I have to justify if it is possible to install in a production environment the three types of nodes (MySQL node + Data node + MGMT Node) on the same instance EC2 (AWS)
One of the scenarios is to have two EC2 instances. The three types of nodes are installed on each instance. The MySQL cluster is active / active between the two instances. I believe this configuration is acceptable for Oracle in a development environment. But in a production environment it would not be and I would like to know why because I don't see a single point of failure.
Oracle in its documentation seems recommend 6 servers to have a fully redundant solution. Okay but why technically this requires 6 servers?
The web application that will use MySQL doesn't require a large processing capacity.
Thank you in advance for your precious help.
Nb. I'm not a DBA.