Mailing List Archive: HA setup of MySQL service using Pacemaker/DRBD

Hi,

I have a working 2 node HA setup running on CentOS 6.5 with a very simple
Apache webserver with replicated index.html using DRBD 8.4. The setup is
configured based on the "Clusters from Scratch" Edition 5 with Fedora 13.

I now with to replace Apache with a MySQL database, or just simply add it.
How can I do so? I'm guessing the following:
1 . Add MySQL service to the cluster with a "crm configure primitive"
command. I'm not sure what the params should be though, e.g. the configfile.
2. Set the same colocation/order rules.
3. Create/initialize a separate DRBD partition for MySQL (or can I reuse
the same partition as Apache assuming I'll never exceed its capacity?)
4. Copy the database/table into the mounted DRBD partition.
5. Configure the cluster for DRBD as per Chapter 7.4 of the guide.

Is this correct? Step by step instructions would be appreciated, I have
some experience in RHEL/CentOS but not in HA nor MySQL.

Thanks!

--
- Goi Sihan
goister@gmail.com

----- Original Message -----
> Hi,
>
> I have a working 2 node HA setup running on CentOS 6.5 with a very simple
> Apache webserver with replicated index.html using DRBD 8.4. The setup is
> configured based on the "Clusters from Scratch" Edition 5 with Fedora 13.
>
> I now with to replace Apache with a MySQL database, or just simply add it.
> How can I do so? I'm guessing the following:
> 1 . Add MySQL service to the cluster with a "crm configure primitive"
> command. I'm not sure what the params should be though, e.g. the configfile.
> 2. Set the same colocation/order rules.
> 3. Create/initialize a separate DRBD partition for MySQL (or can I reuse the
> same partition as Apache assuming I'll never exceed its capacity?)
> 4. Copy the database/table into the mounted DRBD partition.
> 5. Configure the cluster for DRBD as per Chapter 7.4 of the guide.
>
> Is this correct? Step by step instructions would be appreciated, I have some
> experience in RHEL/CentOS but not in HA nor MySQL.

You've got the right idea. I don't have a step by step guide crmsh, but
here's a basic MySQL deploy on shared storage that I test with pcs. I just
mount the shared storage partition to the /var/lib/mysql directory, then start
mysql. From there the database mysql uses exists on shared storage and can follow
the mysql instance wherever it goes in the cluster.

https://github.com/davidvossel/phd/blob/master/scenarios/mariadb-basic.scenario

-- Vossel

> Thanks!
>
> --
> - Goi Sihan
> goister@gmail.com
>
> _______________________________________________
> 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://bugs.clusterlabs.org
>

_______________________________________________
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://bugs.clusterlabs.org