> On 13 Jan 2015, at 7:05 am, Shameer Babu <shameerbab...@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@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@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 <and...@beekhof.net> wrote: > > > On 11 Jan 2015, at 5:39 pm, Shameer Babu <shameerbab...@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@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 > > _______________________________________________ > 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
