<p dir="ltr">Hi Andrew,<br>
Thanks for your advise. </p>
<p dir="ltr">Regards,<br>
Shameer</p>
<div class="gmail_quote">On 16 Jan 2015 10:16, "Andrew Beekhof" <<a href="mailto:andrew@beekhof.net">andrew@beekhof.net</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
> On 13 Jan 2015, at 7:05 am, Shameer Babu <<a href="mailto:shameerbabukm@gmail.com">shameerbabukm@gmail.com</a>> wrote:<br>
><br>
> Hi Andrew,<br>
><br>
> >>>>>>>>Could you be a bit more specific about "didn't work" ?<br>
><br>
> I have installed MariaDB and tried to add the resource mysql (simply created resource) using the simple command "pcs resource create MysQL ocf:heartbeat:mysql" . I know this is incomplete and removed those resource.<br>
><br>
> Please see my existing cluster status:<br>
> -------------------------------------------------------------------------------------------<br>
> PCS Status:<br>
> ---------------------------------------------------------------------------------------<br>
> Every 2.0s: pcs status Mon Jan 12 14:56:38 2015<br>
><br>
> Cluster name: MyCluster<br>
> Last updated: Mon Jan 12 14:56:38 2015<br>
> Last change: Mon Jan 12 14:56:25 2015 via cibadmin on webserver-01<br>
> Stack: corosync<br>
> Current DC: webserver-02 (2) - partition with quorum<br>
> Version: 1.1.10-32.el7_0.1-368c726<br>
> 2 Nodes configured<br>
> 2 Resources configured<br>
><br>
><br>
> Online: [ webserver-01 webserver-02 ]<br>
><br>
> Full list of resources:<br>
><br>
> ClusterIP (ocf::heartbeat:IPaddr2): Started webserver-01<br>
><br>
> PCSD Status:<br>
> webserver-01: Online<br>
> webserver-02: Online<br>
><br>
> Daemon Status:<br>
> corosync: active/disabled<br>
> pacemaker: active/disabled<br>
> pcsd: active/disabled<br>
> ------------------------------------------------------------------------------------------------------------<br>
> DRBD status in webserver-01: (This may be used to setup MySQL)<br>
> ---------------------------------------------<br>
> [root@webserver-01 ~]# cat /proc/drbd<br>
> version: 8.4.5 (api:1/proto:86-101)<br>
> GIT-hash: 1d360bde0e095d495786eaeb2a1ac76888e4db96 build by mockbuild@, 2014-08-17 22:54:26<br>
><br>
> 2: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r-----<br>
> ns:0 nr:12288 dw:12288 dr:728 al:0 bm:0 lo:0 pe:0 ua:0 ap:0 ep:1 wo:f oos:0<br>
> ----------------------------------------------------------------------------------------------------------------------<br>
> Databases:<br>
> ----------------------------------<br>
> MariaDB is installed on both nodes<br>
><br>
> [root@webserver-01 ~]# mysql -V<br>
> mysql Ver 15.1 Distrib 5.5.40-MariaDB, for Linux (x86_64) using readline 5.1<br>
> --------------------------------------------------------------------------------------------------------------------<br>
><br>
> My aim is to create MySQL/MariaDB cluster using pacemaker DRBD on CentOS7.<br>
> Could you please guide me on this or provide any related articles ?<br>
<br>
For starters you need to put drbd under control of the cluster.<br>
The you can colocate mysql with drbd:Master<br>
<br>
><br>
> Regards,<br>
> Shameer<br>
><br>
><br>
> On Mon, Jan 12, 2015 at 6:20 AM, Andrew Beekhof <<a href="mailto:andrew@beekhof.net">andrew@beekhof.net</a>> wrote:<br>
><br>
> > On 11 Jan 2015, at 5:39 pm, Shameer Babu <<a href="mailto:shameerbabukm@gmail.com">shameerbabukm@gmail.com</a>> wrote:<br>
> ><br>
> > Hi,<br>
> ><br>
> > I have configured Apache cluster by referring you document <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a> and it was good and working. Now I would like to configure a simple MySQL cluster using pacemaker,corosync,DRBD and Pcs in CentOS 7. I was trying add the mysql resource but didn't work.<br>
><br>
> Could you be a bit more specific about "didn't work" ?<br>
><br>
> > In CentOS 7 the database is MariaDB. I would like to configure the resource mysql/mariadb for two nodes. Can any body help me on this?<br>
> ><br>
> > I have configured the following till now:<br>
> ><br>
> > 1. Installed pcs,mariadb,pacemaker,corosync and DRBD<br>
> > 2. Configured the resource Virtual IP and it is working fine<br>
> > 3. Configured DRBD to sync files in both nodes and /dev/drbd1 is ready to use<br>
> ><br>
> > Please help me to configure the resource maraidb/mysql for my cluster<br>
> ><br>
> > Regards,<br>
> > Shameer<br>
> > _______________________________________________<br>
> > Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> > <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
> ><br>
> > Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
> > Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
> > Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
><br>
><br>
> _______________________________________________<br>
> Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
> Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
> Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
><br>
> _______________________________________________<br>
> Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
> <a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
><br>
> Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
> Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
> Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
<br>
<br>
_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
</blockquote></div>