Re: do i need to set up mysql cluster for mysql-ha to work?
Fernando Ipar <[email protected]> Wed, 23 Mar 2005 20:06:40 -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"> Exactly. <br> <br> Right now, the script only handles the slave takeover when the master fails. <br> <br> I wasn't clear with the 'autimatic fixed master integration' thing :). <br> <br> By 'fixed master' I mean a replacement for the failed master that caused the slave to takeover (meaning that you solve whatever problem caused the master to fail, so it's now 'fixed'). <br> By 'automatic integration' I mean having this server integrate back into the cluster and begin working again as master, automatically. <br> <br> However, using mysql >= 4.x, you can easily do this like this: (this is what's being scripted right now, and what will go into the next release after testing)<br> - configure the fixed machine to work as slave to the 'new master' (the slave that did the takeover)<br> - STOP THE 'new master'. This is important because we're going to update the original master with the changes that took place during the repair period, and we don't want any more changes to happen in the meantime. <br> - do a LOAD DATA FROM MASTER on the fixed box<br> - configure it as master<br> - configure the slave again as slave to the fixed box<br> - (hopefully) get it all working :)<br> <br> I'm sorry if my words were confusing, I have some trouble putting my ideas into text. Fortunately, it's easier to put them down as code ;). <br> <br> Regards, <br> Fernando. <br> <br> <br> <br> Xinhuan Zheng wrote: <blockquote cite="[email protected]" type="cite"> <pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]"><[email protected]></a> wrote: </pre> <blockquote type="cite"> <pre wrap="">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: </pre> <blockquote type="cite"> <pre wrap="">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 </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 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 <a class="moz-txt-link-freetext" href="http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click">http://ads.osdn.com/?ad_id=6883&alloc_id=15149&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 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 <a class="moz-txt-link-freetext" href="http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click">http://ads.osdn.com/?ad_id=6883&alloc_id=15149&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 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