I have a swarm with 1 manager and 2 nodes (worker 1, worker 2).
On manager and worker 1 I have 30+ services replicated between them, one of which is mysql.
On worker 2 I want to set up a mysql slave to worker 1's mysql.
However, I would like worker 2 to only be available for the mysql service, and not for any of the other services.
I could accomplish this by adding deployment constraints to every service that I don't want to replicate to worker 2, but to alter 30+ services and add a constraint for each of them seems laborious and a bit messy.
Is there an elegant way to achieve this?