No...not in my network...I, as the network administrator, tell MacOS what, which DNS to use ON THIS network and go as far as ensuring that firewall rules are in place so the MacOS has no choice. You can see that in post #14 in the second pic, DNS 10.8.27.1
YES, that's my case...as I had stated before that here, we are speaking of two separate networks 10.0.8.0/24 and 10.8.27.0/24 each with their own single DNS server...with caching.
I'm still struggling. Maybe you're saying that the Mikrotik DNS server on Ethernet 1's network forwards to 10.8.27.1 for certain zones? That's unrelated to specifying 10.8.27.1 as the DNS server on the interface. From my testing, I've confirmed that specifying a DNS server on other than the first interface has no effect. And your doing that is the only thing that's ever confused me in this thread.
I set up a Linux server on my network. I installed Bind DNS server and Apache web server. I configured Bind to be authoritative for a dummy domain - it was not a registered domain - call it xyz.com for this discussion. I also configured it to not recurse - it could only answer questions about servers in its own domain. I set up a simple webpage in Apache. I set
www.xyz.com to resolve to the Linux server. A result of all this was that from my Mac I could access the dummy web page at
http://www.xyz.com/bozo.html (assuming that Linux server's name server was used).
I configure one of my two network interfaces to use this new DNS server - interface 2. The other interface, interface 1, was using my usual DNS forwarder (my router).
When interface 1 was first in the network service order, I could reach the internet. I could not reach bozo.html. When interface 2 was first in the network service order, I could reach bozo.html, but not the internet.
When I said earlier: "I guess after that failure, the next DNS server is queried." I said "I guess" because I was suspicious. Both my friend and I didn't think that the failure of the first DNS would trigger the query of the second DNS. In my setup, it didn't.
My original post #13, where I asserted that only the DNS server specified on the first service entry is used, has proven to be true for my test.
I'm willing to drop this if you want. I appreciate the time you've spent. I think I've overstayed my welcome.