I have got two servers that run the same mysql databases. Now I need to find a way of regularly matching both databases.
For example: I add two new entries into the table on server one. At some later stage I add two different entries into the table on server two. Now I want to update both tables so that they hold all four entries.
Is there a possibility to do that with mysql dump or a similar program? Depending on how regular I make the updates it might end up a lot of entries and I couldn't be bothered to do the matching manually.
Thanks for your help!