Distributed App Architecture Design

[Konstantin Markov]

Hi everyone.

I want to start with the fact that I couldn't find the right section for my question but I still really wanted to post it somewhere so I figured I'll do it in this sectoin. If any moderators see this please point me in the right direction.

I have a client which requires a distributed database architecture. Imagine you have an online shop and physical shops. Every physical shop has vending machines from which you can get different products. He wants the system to be able to work even offline - so that I can continue storing/updating the product quantity in each vending machine as physical sales continue even if the internet connection goes down. This would require to have a multi-master configuration with one DB which saves all data like user accounts, account balance, physical shops, vending machines product quantity, etc. I'll also need to have a DB in every physical store so that I can save vending machine's product quantity data locally too (so it's available all the time).

This led me to believe I need multi-master replication. But here my knowledge about this topic ends so I'd like to ask you to point me in the right direction. How do you think I could achieve this using MySQL? Would group replication be the way to go or there's some other way I'm not aware of. Thank you in advance.


Best,
Konstantin