I currently run my “production” db which is MySQL 8 inside of a docker container which is stored locally on my NAS.

So I have a little redundancy from the RAID.

As my applications have grown in popularity, my data has become more important to me. I have recently acquired access to a second internet connection off site where I can host a second set of servers and load balance between the two.

I’ve got the web side of the distributed services worked out, but I’m not sure about the best route for data redundancy and high availability.

My ideal solution was a master to master MySQL setup over a VPN. I tried this and it wasn’t very reliable. The tables got out of sync somehow and ended up corrupting one of the DBs.

So onto the real question, do you have any recommendations for a reliable SQL based, self hosted, distributed/high availability compatible database?