First of all, these questions are just out of curiosity. I don't have such configuration, I'm just wondering how a box would behave in such environment.
Say we have a Linux box with two network interfaces, each connected to different networks with same DHCP configuration. And by chance, both DHCP servers of two networks assigned the same IP to this client.
Would client accept it as it is or request a new IP from the DHCP server in the second network?
In case it would accept it as it is, (let's say 192.168.1.100) what would happen if I bind a MySQL server to this address? Which interface would it listen?
Let's say I'm to ping 192.168.1.103 and this IP exists in both networks. Which one would get pinged?
If both networks provides Internet connectivity, which one gets preferred and how can we (or can we) manually set it?