2

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.

Improve this question

1 Answer 1

Reset to default
0

Yes, you can put different node types on the same machine. But... You need to change the configuration of each. Running out of RAM would be really bad for performance.

For a Web application, I see no need for the complexity of NDB Cluster. Virtually all Web usages of MySQL simply use InnoDB.

Before digging into more details, please state your goals. Redundancy? Resiliency? Scale? Key-value store? Other? I don't hear any of those in your Question.

Improve this answer
3
  • Hi Rick, Thanks for your feedback. My main purpose is the Redundancy.
    – Christophe Chirat
    Commented Nov 19, 2016 at 1:23
  • MariaDB with Galera gives you a similar amount of redundancy, but less complexity. I cannot attest to either's fitness for use on EC2.
    – Rick James
    Commented Nov 19, 2016 at 1:34
  • @RickJames I read somewhere that Galera return errors on topology changes, even when a good node cames back from a network problem. Do you know if is this true?
    – alanjds
    Commented Dec 22, 2016 at 14:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.