Using PRM on top of Xtradb Cluster

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

Can I use PRM(percona replication manager)on top of Xtradb Cluster as an extra layer of automatic failover.?

Automatic failover in xtradb cluster is not working properly!, I mean if a node reboots(unexpectedly), that node when comes up is failing to join the cluster and manual intervention needed, so thought of using PRM as it can manage the nodes automatically, also can PRM handle multi-master setup…?

2

Yves put PXC support into the ‘mysql_monitor’ Pacemaker agent here: [url]https://github.com/percona/percona-pacemaker-agents/tree/master/agents[/url], but I haven’t tested it. In theory it could do what you describe.

Technically this isn’t “PRM” – just Pacemaker with a PXC-enabled mysql resource agent.

3

Thanks, Will test it out.