MySQL table synchronization

Question

I have a server that constantly writes SQL queries it executes to a textfile. I want this textfile to be read by a second server, execute the queries there, and remove them from the textfile. This is done in an attempt to keep those 2 servers virtually synchronous with each other without changing existing code.

Maybe replication is the better solution? dev.mysql.com/doc/refman/5.1/en/replication.html — DrColossos
– DrColossos, Commented Sep 7, 2010 at 8:47

fatnjazzy · Accepted Answer · 2010-09-07 08:52:04Z

2

Try this one: http://www.maatkit.org/doc/mk-table-sync.html

But I think that Native thing such as mysql replication should be preferred

answered Sep 7, 2010 at 8:52

fatnjazzy

6,14212 gold badges60 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL table synchronization

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related