I've developed a point-of-sale system for our corporation, which has 25+ branches across the country. Each branch has its own MySQL POS database on a WAMP server.
I want every event that occurs in any one branch to be reflected in the databases of all the other branches.
Some people advised me with ring topology (circular replication), but there's a big problem with that: when one server goes down, replication will stop.
I want a more reliable solution for replicating my database.