[Linux-ha-dev] Updated, extended RA: mysql

[Florian Haas]

Hello,

a little while back, Marian Marinov made an excellent contribution in
the form of proof-of-concept code that extends the mysql resource agent
with additional functionality. This includes built-in support for MySQL
replication, the ability to run the RA as a clone, and also as a
master/slave resource where Pacemaker essentially does most of the work
for configuring and monitoring replication.

This enables you to run MySQL in a high-availability configuration where
data is replicated by MySQL replication. In addition, you can of course
use MySQL high availability with DRBD, as always.

Background information and a live demo for the various options of
running MySQL with Pacemaker are included in a webinar we presented the
week before last, and which my blog links to:
http://wp.me/p4XzQ-6E

The modified RA has lived in its own branch for some time now, and
following last week's 1.0.3 release I have now merged it into the
default branch. While not part of an official release, you may download
the updated resource agent from here:
http://hg.linux-ha.org/agents/raw-file/tip/heartbeat/mysql

Its recent revision history is here:
http://hg.linux-ha.org/agents/log/tip/heartbeat/mysql

Please don't be misled by the fact that most commit messages are from
myself; essentially everything is based on Marian's work in some shape
or form, with lots of helpful suggestions from Dejan and Lars Ellenberg.
Huge thanks to Marian for his contribution.

The resource agent will come with an updated and much extended man page
for the 1.0.4 release, and additional how-to information will live at
http://www.linux-ha.org/wiki/mysql_(resource_agent) -- please bear with
us as we add content.

Cheers,
Florian



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 261 bytes
Desc: OpenPGP digital signature
Url : http://lists.linux-ha.org/pipermail/linux-ha-dev/attachments/20100420/5a9b761e/attachment.pgp