I have several databases located over the world, this all have the same structure, with the same tables and triggers. For clarification purposes:
Site 1: database_1 (with all its tables same as other sites)
Site 2: database_1 (with all its tables same as other sites)
Site 3: database_1 (with all its tables same as other sites)
Now in my main site I would have something like this:
Site main:
database_1_site_1 (with all its tables same as other sites)
database_1_site_2 (with all its tables same as other sites)
database_1_site_3 (with all its tables same as other sites)
Now, obviously, these databases will get bigger and bigger so I don't want to backup everything over and over again as its in GBs and it will take a long time. I would just need to backup what has changed.
How can I set this up?