How to update localhost mysql data to remote mysql server

Question

i would like to update for every action(insert,update,delete) happens in localhost mysql to remote mysql server. how to i do that? .

Answer 1

Can't you use Triggers?

22.5.5: Is it possible for a trigger to update tables on a remote server? Yes. A table on a remote server could be updated using the FEDERATED storage engine.

From : http://dev.mysql.com/doc/refman/5.0/en/faqs-triggers.html#qandaitem-22-5-1-5

I wouldn't recommend this because you will be consuming bandwidth for every small change you do. You can try a scheduled job instead.

Answer 2

Enable database replication. It's not a great idea to flush frequently for performance reasons, but maybe it's an acceptable tradeoff?

Answer 3

Hi, I need this too, but WITHOUT the database replication mysql function. because the master cant have INPUT connection, just output. I want a database replication (insert, delete, update... (no select)) to all server and the master.

Thanks =)