----- 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 > gois...@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