List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:July 23 2010 9:04pm
Subject:Re: Replication: ignore specified columns?
View as plain text  

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


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:
> To unsubscribe:


Replication: ignore specified columns?Bryan Cantwell23 Jul
  • Re: Replication: ignore specified columns?Claudio Nanni23 Jul