Docker Scaling In Portainer

Hello I have a question about scaling the docker swarm, what is the best way to scale itif I have one db container and one wordpress container

  1. if I want to add more resources to the website and I scale up to split it over nodes, it effectively breaks the db connection for the site

  2. or in another use case if I want to add a second site I thought I could just scale up the wordpress site and duplicate the db container, but this doesn’t work in practise, should I effectively add a new container every time I want to make a new site

EG. what are some usecase examples of how I can effective use the docker scale

Q. is portainer doing a backend docker scale our a frontend docker scale is there a way to distinguish if I would like front end or back end scale from the gui