From: Claudio Nanni
Date: July 23 2010 9:04pm
Subject: Re: Replication: ignore specified columns?
List-Archive: http://lists.mysql.com/mysql/222323
Message-Id: <AANLkTi=__cpCMbpQURkdOsFsYe-EjuHsOUyxeJBJhJd9@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485f0ac9a0523b2048c14617b

--001485f0ac9a0523b2048c14617b
Content-Type: text/plain; charset=ISO-8859-1

No.

If it is for security reasons: did you think about a view on slave db?
(removing rights from source table)

In case you dont want those columns to reach the slave you could use
triggers to reflect changes from source table (or a view) on master to a
table(with missing columns) that will be replicated.

Just a couple of ideas

Claudio

2010/7/23 Bryan Cantwell <bcantwell@stripped>

> I know that you can ignore certain databases and tables in mysql
> replication, but is it possible to replicate all but a certain column or
> two from a table? This is 5.1.48 on linux.
>
> Thanks,
> Bryancan
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@stripped
>
>


-- 
Claudio

--001485f0ac9a0523b2048c14617b--