hi. I'm preparing for a migration, in testing it seems like copying clients takes a long time so I'm trying to remove old ones, I have like 6k clients but only really 1k active. So my plan was this, go through and if site was turned off for more than a year delete client (jst delete row from master db). However if I delete this from the master database, it does not seem to replicate this to the other nodes. So would I have to run this query seperately on each server? Cheers
maybe you could resync the clients after you remove them from the master? if that doesn't do the job, you could probably write a little script to use the api and apply the same logic.
