I have a POS software running for over 10 years already and I’m looking to rebuild / expend the data.
Currently the server hold the data, single server no replication (yup! we do backup but that’s all).
Each company have it’s down database on the server.
The clients (POS) are .NET application that keep part of the database locally for speed and full offline access. Currently the sync is done manually via websocket messages.
I would like to remove that and have each client having READ ONLY copy of ONLY THEIR database (we don’t want client A to get data from client B)… sync magically.
If the machine reboot or is offline for a while, re-sync magically.
The write would only be made on the server (master).
My questions are:
- Would Couchbase be a good candidate for this type of architecture?
- Would that architecture scale well if we have > 100 clients?
- Can a Couchbase readonly-partial replicate be installed, configure and run silently on the machine without too much hassle?
Thanks for your time!