Good day all
I was asked to research the MMM multi master setup and viability
for a specific environment in order to assist with load balancing and
high availability.
I do however have some questions and hope that someone out there
have had enough experience to assist me with this as I am starting to
think that the option is not viable for their requirements.
my questions:
1. From what I understand the setup requires a
management server (3rd machine) which will be used to monitor and manage
the two database nodes and the replication.
- Am I correct in thinking that this will have
to be almost the same specs seeing that it will be receiving the sam
amount of traffic which the single master would have received
originally?
- I may be wrong here but that is what my
understanding is from how MMM works, however they specify it does not
need to be state of the art (confusing).
2. Master-master replication will mean that the data
needs to be replicated to both machines everytime thus it may be viable
for high availability but in terms of load balancing / performance it
will degrade the performance. Am I correct?
3. I have also gone through about 6 websites now for the
installation procedures and thus far all of them have different
installation documentation... is there someone with a link or resource
for a reliable installation (RHEL 5/mysql 5.1.5_x64)
I would also be glad for any other suggestions,
warnings, etc... in this regard.
My personal feeling from the research thus far is that
the current master/slave setup will be the best option for performance
as that has been their main concern recently and during a system failure
it is rather quick and easy enough to get the slave running as the
master.
I do not have as much experience on this yet so I would
really appreciate assistance.
Regards
Machiel
