The only way I can think of to achieve this is to create a separate schema and use triggers that selectively copy only the records you want into this new schema and replicate only this new schema. You will have to use binlog_format=ROW.

On Thu, 13 Jul 2023, 04:25 Andrew Gable via discuss, <discuss@lists.mariadb.org> wrote:
Hi Everyone,

I hope someone can guide me. 
 
here is my issue
 
I have a central database that is running in my back office and each of my front end machines have a database that is used just for the front end. 

most of the data that is stored in the back office is not needed on the front end but the product table is. 

the product table hold more information then what is needed on the front end (the front end system does not need to know who the supplier is of the item for example)
 
so I have the following feilds on the front end database (called posdatabase)
barcodenumber
posdeacription
pricetype
salelocation
Systemprice. 

both database are using the same field names 
 
is it possible to use replication on select Feilds on the master to the slave? I have seen on YouTube lots of videos showing replication of every table and field in a database but I don't need that)

what I want to do is that possible? 
Thank you for your time with this matter

Andrew Gable
Owner / Software developer
algPoS,Northampton 
http://www.algpos.co.uk
01604 289431

Send from iPhone Email. 


This e-mail is private, confidential and is for the intended recipient only. If misdirected, please notify the sender by telephone and confirm, by return e-mail, that it has been deleted from your system and any copies destroyed. If you are not the intended recipient you are strictly prohibited from using, printing, copying, distributing or disseminating this e-mail or any information contained in or attached to it.
_______________________________________________
discuss mailing list -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-leave@lists.mariadb.org