MySQL Forums
Forum List  »  Replication

Back office PC (Master) - Point of sale Terminals (Slave)
Posted by: Andrew Gable
Date: July 01, 2021 12:58PM

Hi Everyone,

I was hoping someone could advice me on something

I am developing a Point of sale system that uses MySQL as the Central Database and what I would like to know is can I replicate the single back office Database to multiple Salves (IE the front end Tills)

The Idea is as such

Any updates done on the back office (IE add new items / Price change) would be sent to the PoS Terminals right away and if the Back office Server goes off line the PoS terminal can still run as the data is stored in a local MySQL server that is running on the PoS.

Is this the right use for Replication or am I going in the wrong direction with this?

The Database server is running on Debian 10 and the Point of sale systems will be Debian 10 but no GUI (my PoS application does all the graphical work)

Hopefully I have made sense to someone with this


Andy
algPoS, Northampton

Options: ReplyQuote


Subject
Views
Written By
Posted
Back office PC (Master) - Point of sale Terminals (Slave)
362
July 01, 2021 12:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.