I’m running Percona XtraDB Cluster 5.5 with all InnoDB tables.
I need to replicate data from a couple of databases with several hundred table to a separate server (that is not part of the cluster), but only some of the data (related to a particular “user”) along with non-user-specific data.
I don’t think I can use normal master/slave replication for this sort of thing.
I could write a script to go through the different tables and extract the relevant data, but I would like to do this incrementally once per day, so is there a way to find out what rows were modified in the last 24 hours in order to copy the relevant ones?
I could perhaps add triggers to every table, but wouldn’t that cause problems? e.g. performance?
Thanks in advance.