Take the 2-minute tour ×
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.

I must to do a POS program for college in Java, the problem is that I don't know how to link the different computers to a master computer that handles the changes of the database and sends them to the others PCs .

I've thought the best way is that every computer has their own copy of the database and the changes are made directly on this database and later sends them to the master PC, which return the changes made by others computers. Too, I could do it using only one database in the master, but I don't know if this are going to respond well when all the computers are working at the same time.

Do you have any alternative? or It'll work fine with whatever of the ways I've thought?

share|improve this question

migrated from stackoverflow.com Apr 23 '13 at 20:39

This question came from our site for professional and enthusiast programmers.

    
It depends on whether you're trying to shard or replicate. But easiest would be to just have centralized database. –  Lie Ryan Apr 23 '13 at 19:16
    
store the changes with a time stamp on each computer then sync them in server –  dave Apr 23 '13 at 19:21
1  
Assuming POS means point of sale, each register having its own database is a more robust solution than a central database. Purchases are independent, so the register database can update the central database every few minutes, assuming the connection exists. You don't want to wait until the end of the day because you probably are adjusting inventory based on purchases. –  Gilbert Le Blanc Apr 23 '13 at 19:34

2 Answers 2

SymmetricDS is the answer. It supports multiple subscribers with one direction or bi-directional asynchronous data replication. It uses web and database technologies to replicate tables between relational databases, in near real time if desired

share|improve this answer

You are looking for Database replication, if you are useng mysql, you can follow up here

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.