Hi, On Feb 19, 2008 7:17 PM, Gary W. Smith <[EMAIL PROTECTED]> wrote: > 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?
This isn't "natively" supported. You can hack it with replication to a table that has a trigger, which will then insert all but one column into another table, which you can replicate on to the final destination. But I'm scared of such hacks for anything that matters :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]