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

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