[Pacemaker] mysql resource can't start

[emmanuel segura]

Hello Li

Maybe you have all resource in unmanaged state, because you set
maintenance-mode="true"


2013/5/9 Li, Chen <chen.li at intel.com>

> For addition,
> I have already tried to start resource in crm shell.
> Nothing happened, and there is no log in mysql.
>
> Thanks.
> -Chen
>
>
>
> 在 2013-5-9，17:10，"Li, Chen" <chen.li at intel.com<mailto:chen.li at intel.com>>
> 写道：
>
> Hi list,
>
> I’m a new user to pacemaker.
> I’m trying to using pacemaker to set up a HA for mysql in active/slave
> mode.
> My configuration is:
>
> node api01
> node api02
> primitive p_drbd_mysql ocf:linbit:drbd \
>         params drbd_resource="mysql" \
>         op start interval="0" timeout="90s" \
>         op stop interval="0" timeout="180s" \
>         op promote interval="0" timeout="180s" \
>         op demote interval="0" timeout="180s" \
>         op monitor interval="30s" role="Slave" \
>         op monitor interval="29s" role="Master"
> primitive p_fs_mysql ocf:heartbeat:Filesystem \
>         params device="/dev/drbd/by-res/mysql" directory="/var/lib/mysql"
> fstype="ext4" options="relatime" \
>         op start interval="0" timeout="60s" \
>         op stop interval="0" timeout="180s" \
>         op monitor interval="60s" timeout="60s"
> primitive p_ip_mysql ocf:heartbeat:IPaddr2 \
>         params ip="192.168.11.13" cidr_netmask="16" \
>         op monitor interval="30s" \
>         meta is-managed="true"
> primitive p_mysql ocf:heartbeat:mysql \
>         params additional_parameters="--bind-address=192.168.11.13"
> config="/etc/mysql/my.cnf" pid="/var/run/mysqld/mysqld.pid"
> socket="/var/run/mysqld/mysqld.sock" log="/var/log/mysql/mysqld.log" \
>         op monitor interval="20s" timeout="10s" \
>         op start interval="0" timeout="120s" \
>         op stop interval="0" timeout="120s" \
>         meta is-managed="true"
> group g_mysql p_ip_mysql p_fs_mysql p_mysql \
>         meta target-role="Started" is-managed="true"
> ms ms_drbd_mysql p_drbd_mysql \
>         meta notify="true" clone-max="2"
> colocation c_mysql_on_drbd inf: g_mysql ms_drbd_mysql:Master
> order o_drbd_before_mysql inf: ms_drbd_mysql:promote g_mysql:start
> property $id="cib-bootstrap-options" \
>         dc-version="1.1.6-9971ebba4494012a93c03b40a2c58ec0eb60f50c" \
>         cluster-infrastructure="openais" \
>         expected-quorum-votes="2" \
>         stonith-enabled="false" \
>         no-quorum-policy="ignore" \
>         maintenance-mode="true" \
>         last-lrm-refresh="1368118902" \
>         stop-all-resources="false"
>
>
>
> But, the resource p_mysql  never start. And all resource have a
> “unmanaged” mark in status:
>
> crm resource status
> Resource Group: g_mysql
>      p_ip_mysql (ocf::heartbeat:IPaddr2) Started  (unmanaged)
>      p_fs_mysql (ocf::heartbeat:Filesystem) Started  (unmanaged)
>      p_mysql    (ocf::heartbeat:mysql) Stopped  (unmanaged)
> Master/Slave Set: ms_drbd_mysql [p_drbd_mysql] (unmanaged)
>      p_drbd_mysql:0     (ocf::linbit:drbd) Master  (unmanaged)
>      p_drbd_mysql:1     (ocf::linbit:drbd) Slave  (unmanaged)
> Anyone can help me ?
>
>
> Thanks.
> -chen
>
>
>
>
> _______________________________________________
> 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
>



-- 
esta es mi vida e me la vivo hasta que dios quiera
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20130509/91be3bd8/attachment.htm>