Replication: ignore specified columns?

Replication: ignore specified columns?

am 23.07.2010 22:52:30 von bcantwell

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=gcdmg-mysql-2@m.gmane.org

Re: Replication: ignore specified columns?

am 23.07.2010 23:04:21 von Claudio Nanni - TomTom

--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

> 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@gmail.com
>
>


--
Claudio

--001485f0ac9a0523b2048c14617b--