<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi guys,<div>for my prod environment I'm deploying two MySQL servers on two controllers.</div><div>MySQL is configured in active/ active replication…. BUT what I've noticed is that replication often fails because of Quantum foreign keys, when I delete a network for instance:</div><div><blockquote type="cite"> Last_Error: Error 'Cannot delete or update a parent row: a foreign key constraint fails (`quantum`.`ports`, CONSTRAINT `ports_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES `networks` (`id`))' on query. Default database: 'quantum'. Query: 'DELETE FROM networks WHERE networks.id = 'f33591d2-2008-4893-b1bb-51649b745af2'</blockquote><div><br></div>you guys ever face that issue?</div><div>thanks !</div><div><br><div>
<span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; ">--</span><span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; "> </span><br style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div dir="ltr" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><br class="Apple-interchange-newline" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span><img height="74" width="209" id="87b1f72d-1bdf-4775-8a50-9eb472c6c88b" apple-width="yes" apple-height="yes" src="cid:835BC6FF-B62B-42E4-879E-2F92EB97873E"></span><p style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; margin: 0px 0px 10px; font-family: Helvetica, Arial, sans-serif; font-size: 10px; line-height: 11px; color: rgb(153, 153, 153); "><span style="font-weight: bold; "><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">Razique Mahroua</span> / Engineering<br>+336 77 73 23 90/ <a href="mailto:dmadzia@clouditcanada.com" target="_blank" style="color: rgb(238, 152, 15); text-decoration: none; ">razique.mahroua@clouditcanada.com</a></p><p style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; margin: 0px 0px 10px; color: rgb(178, 178, 160); font-family: Helvetica, Arial, sans-serif; font-size: 10px; line-height: 11px; "><span style="font-weight: bold; color: rgb(153, 153, 153); ">Cloud I.T. Canada</span> <span style="color: rgb(153, 153, 153); ">Office: </span><span style="color: rgb(153, 153, 153); ">1-855-200-0320</span> <span style="color: rgb(153, 153, 153); ">/ Fax: </span><span style="color: rgb(153, 153, 153); ">1-866-227-2174</span> <br><span style="color: rgb(153, 153, 153); ">231 Shearson Cres – Suite 109B. Cambridge, ON. N1T 1J5</span><br><a href="http://www.clouditcanada.com/" target="_blank" style="color: rgb(238, 152, 15); text-decoration: none; ">http://www.clouditcanada.com</a></p><p style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; margin: 0px 0px 10px; color: rgb(178, 178, 160); font-family: jaf-facitweb, sans-serif; font-size: 14px; line-height: 20px; "><a href="https://www.facebook.com/pages/Cloud-IT-Canada/227651290711428" target="_blank" style="color: rgb(142, 199, 126); text-decoration: none; "><br class="Apple-interchange-newline" style="color: rgb(142, 199, 126); font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span style="color: rgb(142, 199, 126); font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span><img height="16" width="16" id="02aaa41c-ea65-4499-8253-fe9d6a3c9e16" apple-width="yes" apple-height="yes" src="cid:9B62D457-F7E8-46EE-B0B7-663266A0F42C"></span></span></a><a href="https://www.facebook.com/pages/Cloud-IT-Canada/227651290711428" target="_blank" style="font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(142, 199, 126); text-decoration: none; "><span style="color: rgb(178, 178, 160); font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; "> </span></a><a href="https://twitter.com/CloudIT_Canada" target="_blank" style="font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(142, 199, 126); text-decoration: none; "><span><span><img height="16" width="16" id="84dc1c25-5d5a-410d-a874-a27d4dbcba41" apple-width="yes" apple-height="yes" src="cid:92617296-A1DF-4AEB-B060-D30D68AC285A"></span></span></a><a href="https://twitter.com/CloudIT_Canada" target="_blank" style="font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(142, 199, 126); text-decoration: none; "><span style="color: rgb(178, 178, 160); font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; "> </span></a><a href="https://www.linkedin.com/company/cloud-i-t-canada" target="_blank" style="font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(142, 199, 126); text-decoration: none; "><span><span><img height="16" width="16" id="b9071d67-00d0-436a-8ce1-76d9b8026185" apple-width="yes" apple-height="yes" src="cid:965AAC2A-3B07-48A1-A680-E379FBDA2635"></span></span></a><a href="https://www.linkedin.com/company/cloud-i-t-canada" target="_blank" style="font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(142, 199, 126); text-decoration: none; "><span style="color: rgb(178, 178, 160); font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; "> </span></a><a href="http://myskype.info/clouditcanada" target="_blank" style="font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(142, 199, 126); text-decoration: none; "><span><span><img height="16" width="16" id="81819eec-d1aa-4d2f-81a7-a0608dd840ed" apple-width="yes" apple-height="yes" src="cid:67C65B93-8161-4F1B-9709-47064B866CB0"></span><br class="Apple-interchange-newline" style="color: rgb(142, 199, 126); font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span style="font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(153, 153, 153); font-family: Helvetica, Arial, sans-serif; font-size: 9px; line-height: 11px; display: inline !important; float: none; ">This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, or contain viruses. Anyone who communicates with us by e-mail is deemed to have accepted these risks. Cloud I.T. Canada is not responsible for errors or omissions in this message and denies any responsibility for any damage arising from the use of e-mail. Any opinion and other statement contained in this message and any attachment are solely those of the author and do not necessarily represent those of the company.</span>
</span></a></p></span></div><a href="http://myskype.info/clouditcanada" target="_blank" style="font-family: jaf-facitweb, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: rgb(142, 199, 126); text-decoration: none; ">
</a></div><br></div></body></html>