IPs from different providers and not static.
For external connections I’m using DNS name (IP → Cloud → DDNS) and ADD CNAME record with Mikrotik DNS (example: 1a2b3c4d5e6f.sn.mynetname.net.) to my domain (example: mikrotik.mysite.com)
It is not possible. If you send a packet out via WAN1 the remote service sees packets from that IP address and will return replies to the same address, you cannot force the remote service to return packets to a completely different IP address for WAN2.
You can use policy-based routing so that conversations from different devices on your LAN use either WAN1 or WAN2 for sending or receiving, although defining the routing policy can be difficult.
Well thats fairly straightforward (assuming you are using v7 firmware)
You should have two IP routes for the two WANS at the moment and you will note that I gave ISP 1 a lower distance so that all users will be automatically shifted to WAN1
dst-address=0.0.0.0/0 gateway=ISP1-gatewayIP distance=5
dst-address=0.0.0.0/0 gateway=ISP2-gatewayIP distance=10
To ensure the SERVER instead goes to WAN2. Yuu need a third route , a new table (not in v6), and a Route Rule.
dst-address=0.0.0.0/0 gateway=ISP2-gatewayIP distance=10 table=useWAN2
Now you will note that the action above is ‘lookup-only-in-table’ which means that if WAN2 is not available the Server will not be able to pass traffic. If you wanted the server to have access to WAN1, then you would use the single word action=‘lookup’
One last thing, assuming you have all the other users on WAN1, and that if WAN1 is not available for any reason they should switch to WAN2. The router will do this because it will see WAN2 as an available route, but to ensure wan1 users go back to WAN1 when it becomes available then modify the first route to.
dst-address=0.0.0.0/0 gateway=ISP1-gatewayIP distance=5 check-gateway=ping
+++++++++++++++++++++
If using V6 firmware one does not create a table but one enters ‘useWAN2’ as a routing mark on the extra IP route rule.
dst-address=0.0.0.0/0 gateway=ISP2-gatewayIP distance=10 routing-mark=useWAN2