Replication of some tables (not whole database). Possible?

[Dean C.]

Hi,

I plan to have a master server with a database and 4 tables (A,B,C,D).

On the slaves, I just want to have 2 tables replicated. Let's say A and B. I know that I can set this up on the server side very easily.

The master server works with all tables and inserts some rows from C to A and some rows from D to B. The tables C and D are just temporary tables which are deleted afterwords.

What does really go on during the replication process? Does the slave get the whole database binlog with all A,B,C,D statements from the master or is it kind of intelligent to get the real changes from table A and B?

Since tables C and D are really huge I want to save as much time and network traffic as possible when replicating.

I hope somebody faced this problem already and give me a hint.

Thank you so much!

Dean



Edited 1 time(s). Last edit at 11/03/2005 08:22PM by Dean C..