We need to replicate a table to a third part. The information in the table is
pretty much public, with the exception of one column. Is it possible to
replicate all of the tables with the exception of one column?
What I was thinking was to replication it to a 2nd machine that will limit it
to the tables we care about and then expose that slave machine as a secondary
master.
We are looking to do something like this
MasterA -> SlaveA/MasterB -> SlaveC
MasterA tableA (our machine)
field1
field2
field3
field4
SlaveA/MasterB (our machine)
field1
field2
field4
SlaveC (their machine)
field1
field2
field4
We know we can limit the tables which they can use (which is why we have
introducted SlaveA/MasterB so they will only be able to pull the tables we make
avaiable to them.
Our current method is database dumps but this is become impracticle due to
size. Replication in testing works for what we want to do, we just have a
problem with a single field.
Any ideas on how to make this work?
Gary Wayne Smith
