Re: do i need to set up mysql cluster for mysql-ha to work?

what do you mean by automatic fixed master integration? I want to
promote a slave automatically and later on when died master is fixed,
let the master temporarily a slave to get all the updates. When this
is done, switch master/slave back to their original role. The
take_over.sh seems not having those functions, right?

On Wed, 23 Mar 2005 16:57:14 -0200, Fernando Ipar
<[email protected]> wrote:
> The takeover is invoked at slave_routine.sh, line 104.
> 
> The takeover script just configures the cluster IP on the slave, so that
> new client requests are processed in this 'new' master (By the way, this
> means that, at the moment of a master failure, clients will experience
> problems like timeouts or connection errors. The lenght of this error
> period can be configured, using the SLAVE_SLEEP_TIME and SSH_PATIENCE
> parameters.
> 
> You can read through the takeover.sh script if you want to know more
> about the takeover process. ARP spoofing is used in cases where the
> master won't release the cluster IP (there's a comment on
> slave_routine.sh briefly explaining one possible scenario for this).
> 
> What we don't have now in the scripts is automatic integration of a
> fixed master. I'm working on this right now for a customer, and once the
> code is deemed stable, a new release will be ready. However, this method
> will only work automatically for MySQL versions 4.x or higher.
> 
> Regards,
> Fernando.
> 
> Xinhuan Zheng wrote:
> 
> >Good explaination. Now i understand how shared ip works. I have
> >another question: it seems to me that the shared ip is taken over by
> >slave, how does master and slave role get switched? In read world, I'd
> >like to switch a died master to slave and promote a slave to a master
> >temporarily and once master is fixed and get all updates from its
> >slave, switch them back.  I don't see all these in the scripts or
> >probably I miss them. Can you please advise? thanks very much.
> >--xinhuan
> >
> >
> 
> --
> ----------------------------
> Fernando Ipar - Director
>      Seriema Systems
>      Av. Italia 6201
>       601 3724 / 135
>   www.seriema-systems.com
> -----------------------------
> 
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
> by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> _______________________________________________
> mysql-ha-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel
>


-------------------------------------------------------
This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Register
by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click