[Linux-HA] MySQL Script Master/Slave

[Adrian Chapela]

Excuse me, but I didn't read this mail until now!!
> Hi,
>
> On Wed, Feb 20, 2008 at 11:19:24AM +0100, Adrian Chapela wrote:
>   
>> Hello,
>>
>> I have created a "homemade" mysql master/slave script and now I am testing 
>> it. For now I think it is OK. I still continue testing it and for me I 
>> think it is OK.
>>
>> The script control the state of servers with semaphore files because the 
>> two servers are in Master/Master config but only one can be considered as 
>> master.
>>     
>
> Master/Master config is not multistate, so a regular resource
> should suffice here. Or perhaps I didn't understand this
> correctly.
>
>   
>> I have Mysql circular replication. With this configuration recovery 
>> is more simple.
>>
>> If you want to test it, you can download from:
>> http://code.adrianchapela.net/heartbeat/mysql_slave_master
>>     
>
> Using status files can be tricky. Better to put them in
> $HA_RSCTMP (/var/run/heartbeat/rsctmp) because this directory is
> cleaned on heartbeat start.
>   
Yes I know but I can't do better for now... :D. This directory could be 
a better option to write status files. Have you some other idea to gets 
status control ?

>   
>> A small readme file with a simple example rule:
>> http://code.adrianchapela.net/heartbeat/mysql_slave_master.README
>>     
>
> >From the readme:
>
> 	This script has a attrd variable wich can set two values.
>
> 	Value 0: when the instance isn't a master
>
> 	Value 1: when the instance is a master.
>
> The question is which instance? Or, more precisely, if there's
> only one variable of a boolean kind, then you can determine if
> there's a master but not which node is the master.
>   
This value is used by heartbeat constraints . With this value you only 
know if the node is a master or not but only in the same machine.
> If you want to contribute the script, please talk to Alan.
>   
Yes I want but I hink this script is very poor now, not ??
> Thanks,
>
> Dejan
>
>   
>> Best regards.
>> _______________________________________________
>> Linux-HA mailing list
>> Linux-HA at lists.linux-ha.org
>> http://lists.linux-ha.org/mailman/listinfo/linux-ha
>> See also: http://linux-ha.org/ReportingProblems
>>     
> _______________________________________________
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>
>