Of course I am talking about a materialized view, did you try?
Here some useful links:
http://forums.mysql.com/read.php?100,21746,21746#msg-21746
and from the reply in the same forum topic
by Waheed Noor 09/10/2007 01:39PM you get this link:
http://www.shinguz.ch/MySQL/mysql_mv.html
Aloha!
Claudio
-Messaggio originale-
Da: Gary W. Smith [mailto:[EMAIL PROTECTED]
Inviato: mercoledì 20 febbraio 2008 1.18
A: mysql@lists.mysql.com
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]