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.bha...@ipax.at Technischer Leiter IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at Barawitzkagasse 10/2/2/11 email. off...@ipax.at 1190 Wien tel. +43 1 3670030 FN 277995t HG Wien fax. +43 1 3670030 15 ____________________________________________________________________ _______________________________________________ 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://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker