Hi,

Please post to the linux-ha lists for questions about use and
configuration.

On Fri, Apr 13, 2007 at 11:04:32AM +0200, Viesti Luca wrote:
>  
> I have need to create a mysql centralized cluster whith 3 different
> mysql.
> One mysql for devel istance
> One mysql for test istance and the last for the production.
> Now i have installed the version 2.08 of heartbeat on a sles9 SP3.
> 
>  
> Can i specify different binary for start end stop mysql when i use the
> mysql agent?
> 
> 
> 
> I think that i use the OCF agent and after specify 3 different
> OCF-resource-name (mysql-dev,..,mysql-prod)
> 
> Can someone help me to configure OCF?
> 
> 
> I have found the error in the mysql start/stop script agent 
> 
> 
> ------- ORIGINAL ------
> mysql_status() {
>         if [ ! -e $OCF_RESKEY_pid ]; then
>                 ocf_log debug "MySQL is not running"
>                 return $OCF_NOT_RUNNING;
>         fi
> 
>         pid=`cat $OCF_RESKEY_pid`;
>         if [ -d /proc -a -d /proc/1 ]; then

This is Linuxism. I don't see why it's needed at all.

> 
> This don't work fine 
> 
>    >             [ "u$pid" != "u" -a -d /proc/$pid ]
>    >     else
>    >             kill -0 $pid >/dev/null 2>&1
>    >     fi
>    >
>    >     if $?; then

This won't work.

>    >             return $OCF_SUCCESS;
>         else
>                 ocf_log debug "MySQL not running: removing old PID file"
>                 rm -f $OCF_RESKEY_pid
>                 return $OCF_NOT_RUNNING;
>         fi
> }
> --------------------------------
> 
> 
> I fix this in
> 
> 
> mysql_status() {
>         if [ ! -e $OCF_RESKEY_pid ]; then
>                 ocf_log debug "MySQL is not running"
>                 return $OCF_NOT_RUNNING;
>         fi
> 
>         pid=`cat $OCF_RESKEY_pid`;
>         if [ -d /proc -a -d /proc/1 ]; then
>                 [ "u$pid" != "u" -a -d /proc/$pid ]
>         else
>                 kill -0 $pid >/dev/null 2>&1
>         fi
> 
>         if $?; then
>                 return $OCF_SUCCESS;
>         else
>                 ocf_log debug "MySQL not running: removing old PID file"
>                 rm -f $OCF_RESKEY_pid
>                 return $OCF_NOT_RUNNING;
>         fi
> }

I don't see what you fixed and you didn't say in which way it
doesn't work. Could you produce a patch, please?

> 
> The information contained in this electronic message and any attachments (the
> "Message")  is intended for one or more specific individuals or entities, and
> may be confidential, proprietary,  privileged  or otherwise protected by law. 
> If you are  not the intended recipient, please notify the sender immediately,
> delete this Message and do not  disclose, distribute, or copy it to any third
> party or  otherwise use this Message.  Electronic  messages are not secure or
> error free  and can  contain viruses or may be delayed, and the sender is not
> liable for  any  of  these  occurrences. The  sender  reserves  the  right to
> monitor, record and retain electronic messages.
> 
> Le informazioni  contenute  in  questo messaggio e gli eventuali allegati (il
> "Messaggio")  si  intendono  inviate a uno o  piu' specifici  destinatari. Il 
> contenuto  del  Messaggio  puo'  essere  confidenziale,  riservato e comunque
> protetto  dalla  legge applicabile. Se non siete i destinatari del Messaggio,
> siete  pregati  di  informare  immediatamente il  mittente, cancellate questo
> Messaggio, non rivelatelo,  non distribuitelo  ne' inoltratelo a  terzi,  non
> copiatelo ne' fatene alcun uso. I messaggi  di  posta  elettronica  non  sono
> sicuri  e sono soggetti ad alterazioni, possono essere trasmettitori di Virus 
> informatici  o  soggetti  a  ritardi  nella  distribuzione.  Il  mittente del 
> Messaggio  non  puo' essere in alcun modo considerato responsabile per queste
> evenienze. Il  mittente  si  riserva  il  diritto  di  archiviare, ritenere e
> controllare i messaggi di posta elettronica.
> _______________________________________________________
> Linux-HA-Dev: [EMAIL PROTECTED]
> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
> Home Page: http://linux-ha.org/

-- 
Dejan
_______________________________________________________
Linux-HA-Dev: [EMAIL PROTECTED]
http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
Home Page: http://linux-ha.org/

Reply via email to