Question about Docker and MySQL

[ayandon]

Friends,

This is the 1st time I am setting up a dedicated server at my home using RPi 4 (with Static IP).
I am also installing Docker to host and manage few sites and WordPress installations.
(mostly my previous works as demo which are no longer available in live sites)

I have a little doubt regarding Docker and MySQL, how to setup?
I do not want that every container uses its own MySQL instance which will take up too much memory and space of my RPi 4.
I want to run single common MySQL instance.
 

• Option 1: Run MySQL as a dedicated Docker Container?
  But, I might need MySQL access from outside Docker, like some Linux scripts, some database mirroring etc.
   
• Option 2: Install and run MySQL as local (traditional Linux installation)
  Will it be easy to access this MySQL by the Docker Containers?

Pls suggest.

[Levent]

Option 1 would be my choice, then you can create a virtual network in your docker compose files (assuming you are using an existing images) and connect your containers together. I would prefer everything have their mysql server though.