MySQL Forums
Forum List  »  Replication

advise on Replication
Posted by: Andrew Gable
Date: August 28, 2022 06:23AM

Hello all,

I am writing a EPoS application that uses the mysql database as its database.

I was wondering if it possible to do the following with replication

1. Copy only selected fields if they have changed
2. Send data from a given table to the main database (but not get data from the master table for example a log table send to the master but not retrieve)

I have a large product table in my Main database (server) but my Tills only use 20 of the given 65 fields can I still use replication on them to keep them up to date with any changes on the back office?

or would it be better to write a small sync program that handles the updates very 30-60 seconds?

Options: ReplyQuote

Written By
advise on Replication
August 28, 2022 06:23AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.