I have a problem that I don't know how I could solve it.
I have two tables in two different databases on two servers.
Server 1 (Master) has the data and server 2 is the slave. But Server 2 only needs 3 col's of 30 col+ table
And I sync insert, update and delete from the Master to the slave.
What I could do is a Cronjob, using the php application or maybe has MySQL/InnoDB a way todo it?
Best regards :)