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


Subject
Views
Written By
Posted
advise on Replication
48
August 28, 2022 06:23AM


Sorry, only registered users may post in this forum.

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.