[Pacemaker] mysql m/s failover: 'Could not find first log file name in binary log index file'

[Raoul Bhatia [IPAX]]

On 04/19/2011 10:38 AM, Marek Marczykowski wrote:
> On 04/19/11 10:29, Raoul Bhatia [IPAX] wrote:
>> On 04/19/2011 10:20 AM, Marek Marczykowski wrote:
>>> On 04/19/11 10:01, Raoul Bhatia [IPAX] wrote:
>>>> what i can currently think of:
>>>>
>>>> 1. run a cronjob which periodically analyzes the binlogs and will update
>>>> the node's log-file and log-pos attributes if there are empty binlogs;
>>>> (that's the best method, i think)
>>>>
>>>> 2. restore the purged binlogs from a backup, hack the mysql-bin.index
>>>> file to re-include them, and hope that they will not be purged upon
>>>> replication restart?
>>>>
>>>>
>>>> any input on this?
>>>
>>> I've similar problem... I think the first solution is better - after 7
>>> days log-file and log-pos can be cleared to use "FIRST" as start point.
>>
>> in your opintion, is it possible to fix this via the ocf ra or does it
>> have to be a separate cronjob?
> 
> I haven't idea how to do it in ra. There is no easy way to look what
> binlogs are on the other node. Maybe some tricks storing that info on
> monitor action, but this is ugly and makes ra depending on monitor
> action enabled...
> The easiest solutions are the best :)

hi marek,

so i'm trying to modify the cib to do change master to replicate
from mysql-bin.000031:0

1. i set standby for wdb01
2. i modify the cib via crm:
> node wdb01 \
>         attributes service="wdb" \
>         attributes standby="on" wdb02-log-file-wdb-mysql="mysql-bin.000031" wdb02-log-pos-wdb-mysql="0"

3. i set online for wdb01

however, this does not work.

upon set_master, the ra checks the current slave information
and finds the (incorrect) mysql-bin.000015:24386.

thus, set_master "keeps" this configuration and returns
(mysql ra line 529ff):

> Apr 19 10:46:28 wdb01 mysql-repl[25279]: INFO: Changing MySQL configuration to replicate from wdb02.
> Apr 19 10:46:28 wdb01 mysql-repl[25279]: INFO: Kept master pos for wdb02 : mysql-bin.000015:24386
> Apr 19 10:46:28 wdb01 mysql-repl[25279]: INFO: Changing MySQL configuration to replicate from wdb02.
> Apr 19 10:46:28 wdb01 mysql-repl[25279]: INFO: Kept master pos for wdb02 : mysql-bin.000015:24386


how would you try to restart the replication?

cheers,
raoul
-- 
____________________________________________________________________
DI (FH) Raoul Bhatia M.Sc.          email.          r.bhatia at ipax.at
Technischer Leiter

IPAX - Aloy Bhatia Hava OG          web.          http://www.ipax.at
Barawitzkagasse 10/2/2/11           email.            office at ipax.at
1190 Wien                           tel.               +43 1 3670030
FN 277995t HG Wien                  fax.            +43 1 3670030 15
____________________________________________________________________