List:General Discussion« Previous MessageNext Message »
From:Nanni Claudio Date:February 20 2008 8:56am
Subject:R: Column level replication q?
View as plain text  
Hi Gary,
Did you try with a view with only the public fields of your table?

Aloha!
Claudio


-----Messaggio originale-----
Da: Gary W. Smith [mailto:gary@stripped] 
Inviato: mercoledì 20 febbraio 2008 1.18
A: mysql@stripped
Oggetto: Column level replication q?

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


"Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati o,
comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario
diretto del presente messaggio, é pregato di contattare l'originario mittente e di
cancellare questo messaggio ed ogni suo allegato dal sistema di posta. Se il ricevente non
é il destinatario diretto del presente messaggio, sono vietati l'uso, la
riproduzione e la stampa di questo messaggio e di ogni suo allegato, nonché la
diffusione del loro contenuto a qualsiasi altro soggetto"
*****
"This message and any attachment are confidential and may be privileged or otherwise
protected from disclosure. If you are not the intended recipient, please contact the
sender and delete this message and any attachment from your system. If you are not the
intended recipient you must not use, copy or print this message or attachment or disclose
the contents to any other person."
Thread
Column level replication q?Gary W. Smith20 Feb
  • Re: Column level replication q?Baron Schwartz20 Feb
  • RE: Column level replication q?Gary W. Smith20 Feb
  • R: Column level replication q?Nanni Claudio20 Feb
  • R: Column level replication q?Nanni Claudio20 Feb
    • RE: Column level replication q?Gary W. Smith20 Feb
    • RE: Column level replication q?Gary W. Smith20 Feb
      • Re: Column level replication q?Michael Dykman21 Feb
    • RE: Column level replication q?Gary W. Smith21 Feb