<div dir="ltr">Hi!<div><br></div><div>Answer to question 1: </div><div>I think what is happening here is that you have a mirrored mysql so when you go hit side a / b and turn off side a mysql the request can be routed to the side a central which has no mysql access? Check logs on the designate process to see if requests is hitting it.</div><div><br></div><div>Your 2nd question I think you should use haproxy on each node to do healthchecks here to determine what node is up and simply have designate connect to localhost via haproxy. We do this for our deployment already but in a 3 node percona cluster, but it should work the same.</div><div><br></div><div>Also note that for Percona it's advised to use a 3 node cluster to avoid splitbrains.</div><div><br></div><div>Btw, you can contact us @ # openstack-dns on the freenode network</div><div>Regards</div><div>Endre</div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-03-13 12:24 GMT+01:00 Nobumasa Yukutomi <span dir="ltr"><<a href="mailto:yukutomi@m.ieice.org" target="_blank">yukutomi@m.ieice.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all,<br>
<br>
I'm Nobumasa Yukutomi. I'm working on Designate since last year.<br>
<br>
We are using Designate for '20141003' Git Hub repository of Icehouse.<br>
<br>
We have built Designate with mysql(Percona) cluster shown below.<br>
<br>
<br>
designate.conf designate.conf<br>
IP:xxx.xx.x.x IP:yyy.yy.y.y<br>
A-side B-side<br>
----------------- -----------------<br>
| designate-api | | designate-api |<br>
----------------- -----------------<br>
| |<br>
----------------- cluster -----------------<br>
| rabbitMQ |---------------| rabbitMQ |<br>
----------------- -----------------<br>
| |<br>
-------------------- --------------------<br>
| designate-central | | designate-central |<br>
-------------------- --------------------<br>
| |<br>
|IP:xxx.xx.x.x |IP:yyy.yy.y.y<br>
------------------ cluster ------------------<br>
| mysql(Percona) |--------------| mysql(Percona) |<br>
------------------ ------------------<br>
| |<br>
| |<br>
----------------- -----------------<br>
| PowerDNS | | PowerDNS |<br>
----------------- -----------------<br>
<br>
Let's assume some situation that mysql cluster encounters some problem. So<br>
let's stop B-side mysql.<br>
<br>
The A-side mysql(active) itself continues running. But designate-api<br>
services of both sides stop working, even if the process of designate-api<br>
continues running on both sides. User gets returned Error500(internal<br>
server error) from designate-api.<br>
<br>
Here are more details.<br>
<br>
1. Listing domains<br>
For example, if a user access designate-api of A-side, designate-central<br>
accesses to both sides of mysql and the user experiences to succeed and<br>
fail to list domains every other time.<br>
<br>
2. Listing records<br>
Also, listing records fails 100% in both sides when a user accesses to<br>
designate-api of either A-side or B-side.<br>
<br>
And here are my questions.<br>
<br>
Question 1<br>
In designate.conf of A-side, the destination of mysql is<br>
A-side IP: xxx.xx.xx<br>
<br>
In designate.conf of B-side, the destination to mysql is<br>
B-side IP: yyy.yy.yy<br>
<br>
But, for some reason, designate-central accesses to both IP addresses.<br>
<br>
I would like to know why this is happening.<br>
<br>
Question 2<br>
I would like to know how to change configuration to make designate-central<br>
to access "only" to active-mysql, not to inactive-mysql.<br>
<br>
Thank you in advance.<br>
<br>
Best regards,<br>
<br>
---<br>
Nobumasa Yukutomi <a href="mailto:yukutomi@m.ieice.org">yukutomi@m.ieice.org</a><br>
<br>
<br>
<br>
_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
</blockquote></div><br></div>