开发者

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

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 co开发者_如何转开发mmited 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


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


Answering this in order to help persons who may end up here searching.

You can use MySQL Replication with replicate-wild-do-table configuration option to get this done.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜