Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
So are you asking specifically about how to replicate the MySQL database in your system? What kind of database replication do you currently have in place? – Nick Chammas Jul 2 '13 at 11:21
Why are you writing a POS system yourself? Do absolutely none of the off-the-shelf products meet your needs? Companies in the business of writing POS systems have already solved these types of problems. In this space, particularly because it's a critical part of the infrastructure of the company, it's almost always -ROI to develop your own system. – Jon Seigel Jul 2 '13 at 13:22
@NickChammas: Yes I want to replicate my database, I'm using MySQL database. – CairoCoder Jul 3 '13 at 1:10
@JonSeigel: We developed it ourselves, be cause current commercial systems doesn't meet our requirements. – CairoCoder Jul 3 '13 at 1:13
Wait, didn't Rolando answer this in your last question (in which he suggested implementing a star topology)? – Jon Seigel Jul 3 '13 at 1:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.