[Pacemaker] Help needed to configure MySQL Cluster using Pacemaker, Corosync, DRBD and PCS

[Shameer Babu]

Hi Andrew,
Thanks for your advise.

Regards,
Shameer
On 16 Jan 2015 10:16, "Andrew Beekhof" <andrew at beekhof.net> wrote:

>
> > On 13 Jan 2015, at 7:05 am, Shameer Babu <shameerbabukm at gmail.com>
> wrote:
> >
> > Hi Andrew,
> >
> > >>>>>>>>Could you be a bit more specific about "didn't work" ?
> >
> > 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.
> >
> > Please see my existing cluster status:
> >
> -------------------------------------------------------------------------------------------
> > PCS Status:
> >
> ---------------------------------------------------------------------------------------
> > Every 2.0s: pcs status                                   Mon Jan 12
> 14:56:38 2015
> >
> > Cluster name: MyCluster
> > Last updated: Mon Jan 12 14:56:38 2015
> > Last change: Mon Jan 12 14:56:25 2015 via cibadmin on webserver-01
> > Stack: corosync
> > Current DC: webserver-02 (2) - partition with quorum
> > Version: 1.1.10-32.el7_0.1-368c726
> > 2 Nodes configured
> > 2 Resources configured
> >
> >
> > Online: [ webserver-01 webserver-02 ]
> >
> > Full list of resources:
> >
> >  ClusterIP      (ocf::heartbeat:IPaddr2):       Started webserver-01
> >
> > PCSD Status:
> >   webserver-01: Online
> >   webserver-02: Online
> >
> > Daemon Status:
> >   corosync: active/disabled
> >   pacemaker: active/disabled
> >   pcsd: active/disabled
> >
> ------------------------------------------------------------------------------------------------------------
> > DRBD status in webserver-01: (This may be used to setup MySQL)
> > ---------------------------------------------
> > [root at webserver-01 ~]# cat /proc/drbd
> > version: 8.4.5 (api:1/proto:86-101)
> > GIT-hash: 1d360bde0e095d495786eaeb2a1ac76888e4db96 build by mockbuild@,
> 2014-08-17 22:54:26
> >
> >  2: cs:Connected ro:Primary/Secondary ds:UpToDate/UpToDate C r-----
> >     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
> >
> ----------------------------------------------------------------------------------------------------------------------
> > Databases:
> > ----------------------------------
> > MariaDB is installed on both nodes
> >
> > [root at webserver-01 ~]# mysql -V
> > mysql  Ver 15.1 Distrib 5.5.40-MariaDB, for Linux (x86_64) using
> readline 5.1
> >
> --------------------------------------------------------------------------------------------------------------------
> >
> > My aim is to create MySQL/MariaDB cluster using pacemaker DRBD on
> CentOS7.
> > Could you please guide me on this or provide any related articles ?
>
> For starters you need to put drbd under control of the cluster.
> The you can colocate mysql with drbd:Master
>
> >
> > Regards,
> > Shameer
> >
> >
> > On Mon, Jan 12, 2015 at 6:20 AM, Andrew Beekhof <andrew at beekhof.net>
> wrote:
> >
> > > On 11 Jan 2015, at 5:39 pm, Shameer Babu <shameerbabukm at gmail.com>
> wrote:
> > >
> > > Hi,
> > >
> > > I have configured Apache cluster by referring you document
> http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf 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.
> >
> > Could you be a bit more specific about "didn't work" ?
> >
> > > 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?
> > >
> > > I have configured the following till now:
> > >
> > > 1. Installed pcs,mariadb,pacemaker,corosync and DRBD
> > > 2. Configured the resource Virtual IP and it is working fine
> > > 3. Configured DRBD to sync files in both nodes and /dev/drbd1 is ready
> to use
> > >
> > > Please help me to configure the resource maraidb/mysql for my cluster
> > >
> > > Regards,
> > > Shameer
> > > _______________________________________________
> > > Pacemaker mailing list: Pacemaker at 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 at 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 at 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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://oss.clusterlabs.org/pipermail/pacemaker/attachments/20150116/32449d9a/attachment.html>