[Pacemaker] 2 node failover cluster + MySQL Master-Master replica setup

[Dan Frincu]

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 at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20101112/24800057/attachment-0002.htm>