Hi,
Ruzsinszky Attila wrote:
Hi,
And now (officially) RHCS can also use Pacemaker
http://theclusterguy.clusterlabs.org/post/1551292286
Nice.
Yeah, like I said, Master-Master and Pacemaker without a proper resource
agent will cause issues.
Yes.
big problems. Now let me explain this, a 2-node Multi-Master MySQL setup
means setting up every node as both Master and Slave, node 1's Master
replicates asynchronously to node 2's Slave and node 2's Master replicates
asynchronously to node 1's Slave. The replication channels between the two
are not redundant, nor do they recover from failure automatically and you
have to manually set the auto-increment-increment and auto-increment-offset
so that you don't have primary key collisions.
Clear.
each server. Looking at how DRBD handles these kinds of things is one way to
go about it, but ... it's a huge task and there are a lot of things that can
go terribly wrong.
:-(
So again, for the third time, the problem is not the Multi-Master setup, nor
it is Pacemaker, it's just a very specific use case for which a resource
agent wasn't written.
OK.
So now almost the only one possibilities is DRBD+MySQL?
Afaik, yes, I'm hoping someone will step in and say otherwise, but to
the best of my knowledge, the only implementation between MySQL and
Pacemaker is represented by the mysql and mysql-proxy resource agents
http://www.linux-ha.org/wiki/Resource_Agents
The mysql RA controls a single MySQL instance and the rest of the HA
setup is done via DRBD Master-Slave resources.
Regards,
Dan
TIA,
Ruzsi
_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
--
Dan FRINCU
Systems Engineer
CCNA, RHCE
Streamwide Romania
_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
