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

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

On Wed, 23 Mar 2005 13:23:19 -0200, Fernando Ipar
<[email protected]> wrote:
>  You're welcome. 
>  
>  mysql-ha works by using a shared cluster ip among the two nodes. 
>  The idea is that, in order to make the cluster transparent to clients,
> these connect using the cluster IP, which at system startup, is configured
>  on the master node. 
>  
>  If anything goes wrong on the master and a takeover takes place, the
> cluster IP is configured automatically on the slave, thus, clients can
> continue
>  using the service with no change in their configuration. 
>  
>  The CLUSTER_IP variable defines this IP that's shared between the two
> nodes. 
>  For instance, you could have the master node with ip 192.168.0.10 and the
> slave with 192.168.0.11, and
>  configure CLUSTER_IP to 192.168.0.20. In this case, when configuring the
> clients, you should set them up
>  to connect to 192.168.0.20. 
> 
>  
>  Regards, 
>  Fernando. 
>  
>  
>  Xinhuan Zheng wrote: 
>  Thanks for quick response. mysql-ha is what I'm looking for. I don't
> understand CLUSTER_IP configuration. How does CLUSTER_IP work? Can you
> please explain it briefly to me? thanks again. --xinhuan On Wed, 23 Mar 2005
> 12:26:43 -0200, Fernando Ipar <[email protected]> wrote: 
>  You're refering to MySQL Cluster the product from MySQL AB?. You don't need
> to set it up. In fact, MySQL Cluster provides all the funcionality we aimed
> to provide with mysql-ha, but only for in memory databases. In order to use
> mysql-ha, you just need the set up as you already have done it (master and
> slave). The installation script can set this up for you too, if you just
> have two nodes with mysql installed on them but no further configuration.
> Regards, Fernando. Xinhuan Zheng wrote: 
>  I'm implementing mysql failover. Basically, i have one master and one slave
> set up. I see mysql-ha project and wondering if i need to set up mysql
> cluster in order to make mysql-ha to work? thanks. --xinhuan
> ------------------------------------------------------- This SF.net email is
> sponsored by: 2005 Windows Mobile Application Contest Submit applications
> for Windows Mobile(tm)-based Pocket PCs or Smartphones for the chance to win
> $25,000 and application distribution. Enter today at
> http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click
> _______________________________________________ mysql-ha-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel --
> ---------------------------- Fernando Ipar - Director Seriema Systems Av.
> Italia 6201 601 3724 / 135 www.seriema-systems.com
> -----------------------------
> ------------------------------------------------------- This SF.net email is
> sponsored by: 2005 Windows Mobile Application Contest Submit applications
> for Windows Mobile(tm)-based Pocket PCs or Smartphones for the chance to win
> $25,000 and application distribution. Enter today at
> http://ads.osdn.com/?ad_id=6882&alloc_id=15148&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: 2005 Windows Mobile Application Contest Submit applications
> for Windows Mobile(tm)-based Pocket PCs or Smartphones for the chance to win
> $25,000 and application distribution. Enter today at
> http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click
> _______________________________________________ mysql-ha-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel 
>  
>  
>  -- ---------------------------- Fernando Ipar - Director Seriema Systems
> Av. Italia 6201 601 3724 / 135 www.seriema-systems.com
> -----------------------------
> ------------------------------------------------------- This SF.net email is
> sponsored by: 2005 Windows Mobile Application Contest Submit applications
> for Windows Mobile(tm)-based Pocket PCs or Smartphones for the chance to win
> $25,000 and application distribution. Enter today at
> http://ads.osdn.com/?ad_id=6882&alloc_id=15148&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