Re: do i need to set up mysql cluster for mysql-ha to work?
Fernando Ipar <[email protected]> Wed, 23 Mar 2005 13:23:19 -0200
| Newsgroups | gmane.comp.db.mysql.high-availability |
|---|---|
| Message-ID | <[email protected]> |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> You're welcome. <br> <br> mysql-ha works by using a shared cluster ip among the two nodes. <br> 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<br> on the master node. <br> <br> 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<br> using the service with no change in their configuration. <br> <br> The CLUSTER_IP variable defines this IP that's shared between the two nodes. <br> For instance, you could have the master node with ip 192.168.0.10 and the slave with 192.168.0.11, and<br> configure CLUSTER_IP to 192.168.0.20. In this case, when configuring the clients, you should set them up<br> to connect to 192.168.0.20. <br> <br> Regards, <br> Fernando. <br> <br> <br> Xinhuan Zheng wrote: <blockquote cite="[email protected]" type="cite"> <pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]"><[email protected]></a> wrote: </pre> <blockquote type="cite"> <pre wrap="">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: </pre> <blockquote type="cite"> <pre wrap="">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 <a class="moz-txt-link-freetext" href="http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click">http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click</a> _______________________________________________ mysql-ha-devel mailing list <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel">https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel</a> </pre> </blockquote> <pre wrap="">-- ---------------------------- Fernando Ipar - Director Seriema Systems Av. Italia 6201 601 3724 / 135 <a class="moz-txt-link-abbreviated" href="http://www.seriema-systems.com">www.seriema-systems.com</a> ----------------------------- ------------------------------------------------------- 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 <a class="moz-txt-link-freetext" href="http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click">http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click</a> _______________________________________________ mysql-ha-devel mailing list <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel">https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel</a> </pre> </blockquote> <pre wrap=""><!----> ------------------------------------------------------- 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 <a class="moz-txt-link-freetext" href="http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click">http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click</a> _______________________________________________ mysql-ha-devel mailing list <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel">https://lists.sourceforge.net/lists/listinfo/mysql-ha-devel</a> </pre> </blockquote> <br> <br> <pre class="moz-signature" cols="72">-- ---------------------------- Fernando Ipar - Director Seriema Systems Av. Italia 6201 601 3724 / 135 <a class="moz-txt-link-abbreviated" href="http://www.seriema-systems.com">www.seriema-systems.com</a> ----------------------------- </pre> </body> </html> ------------------------------------------------------- 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