Mysql scaling in docker

I am looking for mysql scaling on a swarm that could potentially be connected to multiple servers. What is the best way to ensure data is synchronized between containers on different servers?

I understand that in the standard configuration without dockers, I have to configure replication. I am wondering if there is a way to do this, which is more convenient and easy to deploy with docker.

+5
source share
2 answers

Docker-compose and docker swarm is a great tool for scaling in a Docker-compose and docker swarm environment. But currently MySQL-DB scaling is not possible in docker-compose or docker-swarm . Causes:

  • Scaling suitable for stateless containers

  • Configuration not possible for master slave in dock

  • Missing docker overlay network replication method

Perhaps in the future we have technologies that will scale the RDBMS.

+3
source

Database replication is used for this.

https://dev.mysql.com/doc/refman/5.7/en/replication.html

+1
source

Source: https://habr.com/ru/post/1245974/


All Articles