Is it possible to do replication of only one table with different mysql databases in different hosts?

Question

Hi there.

I'm trying to do replication of one table in a remote host in my database. Suppose there is a change in the remote database and i want it commited or replicated to my database in order to keep it up to date with the lastest changes without having to run any dumps, cron scripts or something similar. Is there any way to replicate only one table from a remote database into a table inside the database in the host that i'm working with? By the way, i'm using mysql databases in a freebsd based systems both places.

Thanks for advance

Answer 1

One possible solution would be to use FEDERATED engine (possibly coupled with event scheduler to update your local table)